cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?

Highlighted
Newbie

How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?

As the title says,  I have a query that I pass to the QueryDataTableEntries service via a REST request. Aside from the max number of items returned, I don't see any way to query the first x/next x records in a Data Table. Is there any way to do this? I am trying to get the data back as JSON.

Tags (1)
3 REPLIES 3

Re: How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?

You'd have to state your query in JSON format around those requirement. I'd recommend writing a custom service to query data table entries with needed parameters.

Re: How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?

Does Thingworx have the ability to query distinct values for a column in a table with JSON?

Re: How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?

You may use sql queries or javascript;  also please refer to the json snippets available in the composer: