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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 <[email protected]> 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 <[email protected]> >>>> 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 < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Gokul, >>>>>> >>>>>> On Thu, Jan 11, 2018 at 11:41 AM, Gokul Balakrishnan <[email protected]> >>>>>> 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 <[email protected]> >>>>>>> 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 < >>>>>>>> [email protected]> 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_/actualName >>>>>>>>> >>>>>>>>> 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 >>>>>> [email protected] >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Dev mailing list >>>>> [email protected] >>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>> >>>>> >>>> >>>> >>>> -- >>>> Thanks & Regards, >>>> >>>> *Fazlan Nazeem* >>>> Senior Software Engineer >>>> WSO2 Inc >>>> Mobile : +94772338839 >>>> [email protected] >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> <http://wso2.com/signature> >> Sajith Dimal >> Software Engineer >> Email : [email protected] >> 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 : [email protected] Mobile : +94783101496 WSO2 Inc. | http://wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
