This is something we've talked about adding. A few questions that will help us plan:
How do you call this API? Is it a GET request which includes the necessary authentication tokens? Is the response a single map as shown below with all the records in the "data" array, regardless of the number of records? Or could there be, for example, a need for paging? On Sun, Oct 25, 2015 at 6:12 PM, Santosh Srinivas < [email protected]> wrote: > Hello Drill Team, > > I am huge fan of Apache Drill. I have a unique case where I have an COTS > application which returns me the data in JSON format as a service. Is there > any way I can enable Drill to query against that data as a service? > > As an example: I have an app which returns me a JSON service as follows, > can I use Drill to query this in Real Time and we need to use this data to > develop some Tableau Dashboards. > > Appreciate your help. > > { > > "data": > > [ > > { > > "ID": "123456ABC", > "name": "Validate Product Data", > "objCode": "TASK", > "project": > > { > "ID": "234ABC", > "name": "NAME 1", > "objCode": "PROJ" > }, > "actualStartDate": "2015-08-10T14:16:49:095-0400", > "actualCompletionDate": "2015-08-10T14:16:49:095-0400" > > }, > { > > "ID": "7787ABC", > "name": "Enter Product Data", > "objCode": "TASK", > "project": > > { > "ID": "NEW678AB", > "name": "NAME 2", > "objCode": "PROJ" > }, > "actualStartDate": "2015-08-10T14:16:50:964-0400", > "actualCompletionDate": "2015-08-10T14:16:50:964-0400" > > } > > } > > > -- > Regards, > > Santosh > Tale Research >
