Hello Sajith, Thank you for this information. Now the documentation is updated accordingly. Can you please check [1]?
[1] https://docs.wso2.com/display/DAS320/Inferring+the+Actual+Table+Name+from+the+Encoded+Name Best Regards, Rukshani. On Tue, Apr 24, 2018 at 3:42 PM, Sajith Perera <saji...@wso2.com> wrote: > Hi Rukshani, > > Please find the requested information: > > Sample cURL command > curl -H "Content-Type: application/json" -H "Authorization: Basic > YWRtaW46YWRtaW4=" -v https://localhost:9443/analytics/tables/ANX___ > 7LtvlqNk_/actualName -k > > Example > GET (with auth) https://<DAS_HOST>:9443/analytics/tables/ANX___ > 7LtvlqNk_/actualName > > Sample output > SAMPLE_TABLE > > REST API response > HTTP status code 200 > For descriptions of the HTTP status codes, see HTTP Status Codes. > > Regards, > SajithD > > On Mon, Apr 23, 2018 at 4:27 PM, Rukshani Weerasinha <ruksh...@wso2.com> > wrote: > >> Hi Sajith, >> >> I will do this within the week. Thank you for sharing this information. >> >> Best Regards, >> Rukshani. >> >> On Fri, Apr 20, 2018 at 11:59 AM, Sajith Perera <saji...@wso2.com> wrote: >> >>> +[Rukshani] >>> >>> Hi All, >>> >>> We need to update the documentation [1] by adding the following entry >>> for the $subject implementation. >>> >>> GET (with auth) https://<DAS_HOST>:9443/analytics/tables/<ENCODED_NAME> >>> /actualName >>> >>> [1] - https://docs.wso2.com/display/DAS320/Analytics+REST+API+Guide >>> >>> Regards, >>> SajithD >>> >>> On Fri, Apr 20, 2018 at 11:30 AM, Gimantha Bandara <giman...@wso2.com> >>> wrote: >>> >>>> Hi Fazlan, >>>> >>>> It is there in apim analytics 2.2.0 and also as a WUM update in 2.1.0 >>>> >>>> On Fri, Apr 20, 2018 at 5:19 AM, Fazlan Nazeem <fazl...@wso2.com> >>>> wrote: >>>> >>>>> Hi all, >>>>> >>>>> Was this implemented? if so can someone point me to the documentation? >>>>> I need to find the actual table name using the encoded name. If there is >>>>> any other alternative please let me know. >>>>> >>>>> On Thu, Jan 11, 2018 at 8:21 AM, Sajith Ravindra <saji...@wso2.com> >>>>> wrote: >>>>> >>>>>> Have to agree with Sinthuja on this. >>>>>> >>>>>> IMO this is a simple utility function. People will be mostly using >>>>>> this while debugging an issue to get the actual table name. Having script >>>>>> makes things much easy and simple IMO. >>>>>> >>>>>> Thanks >>>>>> *,Sajith Ravindra* >>>>>> Associate Technical Lead >>>>>> WSO2 Inc.; http://wso2.com >>>>>> lean.enterprise.middleware >>>>>> >>>>>> mobile: +94 77 2273550 >>>>>> blog: http://sajithr.blogspot.com/ >>>>>> <http://lk.linkedin.com/pub/shani-ranasinghe/34/111/ab> >>>>>> >>>>>> On Thu, Jan 11, 2018 at 12:21 AM, Sinthuja Rajendran < >>>>>> sinth...@wso2.com> wrote: >>>>>> >>>>>>> Hi Gokul, >>>>>>> >>>>>>> On Thu, Jan 11, 2018 at 11:41 AM, Gokul Balakrishnan <go...@wso2.com >>>>>>> > wrote: >>>>>>> >>>>>>>> Hi Sinthuja, >>>>>>>> >>>>>>>> Agree with your point. However, a new script will come with its own >>>>>>>> complexities such as segregating permissions and preventing users from >>>>>>>> retrieving names of tables not belonging to their tenant. >>>>>>>> >>>>>>> >>>>>>> Anyhow, this is devops/advanced user related work, and not a general >>>>>>> user related operation. Because inorder to get the encoded table name, >>>>>>> the >>>>>>> user should have the access to the database and knowing the table >>>>>>> name/schema will not impose any security threat. So I don't think having >>>>>>> shell script will reveal any additional security threat, given that the >>>>>>> user who will be using this feature will be already having the db level >>>>>>> access. >>>>>>> >>>>>>> >>>>>>>> In addition, we already have a REST API operation for doing it the >>>>>>>> other way (human-readable name to encoded name) already, hence the >>>>>>>> decision >>>>>>>> to add this to the REST API too. >>>>>>>> >>>>>>> >>>>>>> Hmm.. Ok.. >>>>>>> >>>>>>> Thanks, >>>>>>> Sinthuja. >>>>>>> >>>>>>> Best, >>>>>>>> >>>>>>>> On 11 January 2018 at 11:17, Sinthuja Rajendran <sinth...@wso2.com> >>>>>>>> wrote: >>>>>>>> >>>>>>>>> Hi Gokul, >>>>>>>>> >>>>>>>>> +1 to have a feature which returns the actual table name from the >>>>>>>>> encoded table name that exists in the data storage. >>>>>>>>> >>>>>>>>> But IMHO, having REST API for this is not a correct way of doing, >>>>>>>>> because REST APIs are intended to integrate this with external >>>>>>>>> systems, and >>>>>>>>> hence core analytics data operations need to be exposed via the REST >>>>>>>>> API. >>>>>>>>> But this feature is kind of a utility operation for debugging and not >>>>>>>>> meant >>>>>>>>> to be used by the users for normal table operations and also AFAIR >>>>>>>>> it's >>>>>>>>> applicable for RDBMS analytics data sources, not for others such as >>>>>>>>> HBase. >>>>>>>>> >>>>>>>>> Therefore I propose, we'll have a utility shell script like a >>>>>>>>> tool, which will take the encoded table name, and the data source >>>>>>>>> type as >>>>>>>>> params, and prompt the user-defined table name. >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> Sinthuja. >>>>>>>>> >>>>>>>>> On Thu, Jan 11, 2018 at 11:01 AM, Gokul Balakrishnan < >>>>>>>>> go...@wso2.com> wrote: >>>>>>>>> >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> We have come across many cases where DAS tables stored in the >>>>>>>>>> EVENT or PROCESSED stores (which have encoded names to comply with DB >>>>>>>>>> vendor limitations) cannot be identified as representing which >>>>>>>>>> actual table >>>>>>>>>> just by looking at them. This is a very useful functionality to have, >>>>>>>>>> especially when debugging issues. >>>>>>>>>> >>>>>>>>>> In order to address this, I've implemented a DAS REST API >>>>>>>>>> operation which will simply examine the calling user's tables and >>>>>>>>>> print out >>>>>>>>>> the name of the actual table if a match is found. >>>>>>>>>> >>>>>>>>>> The usage will be as follows: >>>>>>>>>> >>>>>>>>>> GET (with auth) https://<DAS_HOST>:9443/analyt >>>>>>>>>> ics/tables/<ENCODED_NAME>/actualName >>>>>>>>>> >>>>>>>>>> Example cURL command: >>>>>>>>>> >>>>>>>>>> curl -k -H "Authorization: Basic YWRtaW46YWRtaW4=" >>>>>>>>>> https://localhost:9443/analytics/tables/ANX___7Lleafa0_/actu >>>>>>>>>> alName >>>>>>>>>> >>>>>>>>>> We're planning to release this as a WUM update for DAS 3.1.0 and >>>>>>>>>> related products. >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> Gokul Balakrishnan >>>>>>>>>> Senior Software Engineer, >>>>>>>>>> WSO2, Inc. http://wso2.com >>>>>>>>>> M +94 77 5935 789 | +44 7563 570502 <+44%207563%20570502> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Sinthuja Rajendran* >>>>>>>>> Senior Technical Lead >>>>>>>>> WSO2, Inc.:http://wso2.com >>>>>>>>> >>>>>>>>> Blog: http://sinthu-rajan.blogspot.com/ >>>>>>>>> Mobile: +94774273955 <+94%2077%20427%203955> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Gokul Balakrishnan >>>>>>>> Senior Software Engineer, >>>>>>>> WSO2, Inc. http://wso2.com >>>>>>>> M +94 77 5935 789 | +44 7563 570502 <+44%207563%20570502> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Sinthuja Rajendran* >>>>>>> Senior Technical Lead >>>>>>> WSO2, Inc.:http://wso2.com >>>>>>> >>>>>>> Blog: http://sinthu-rajan.blogspot.com/ >>>>>>> Mobile: +94774273955 <+94%2077%20427%203955> >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Dev mailing list >>>>>>> Dev@wso2.org >>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> >>>>> *Fazlan Nazeem* >>>>> Senior Software Engineer >>>>> WSO2 Inc >>>>> Mobile : +94772338839 >>>>> fazl...@wso2.com >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> Dev@wso2.org >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> Dev@wso2.org >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> <http://wso2.com/signature> >>> Sajith Dimal >>> Software Engineer >>> Email : saji...@wso2.com >>> Mobile : +94783101496 >>> WSO2 Inc. | http://wso2.com >>> lean.enterprise.middleware >>> >> >> >> >> -- >> Rukshani Weerasinha >> >> WSO2 Inc. >> Web:http://wso2.com >> Mobile: 0777 683 738 >> >> > > > -- > <http://wso2.com/signature> > Sajith Dimal > Software Engineer > Email : saji...@wso2.com > Mobile : +94783101496 > WSO2 Inc. | http://wso2.com > lean.enterprise.middleware > -- Rukshani Weerasinha WSO2 Inc. Web:http://wso2.com Mobile: 0777 683 738
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev