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_/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 >>>>> 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
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev