Skip to main content
1-Visitor
November 21, 2017
Question

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

  • November 21, 2017
  • 3 replies
  • 2302 views

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.

3 replies

20-Turquoise
November 21, 2017

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.

kbetances1-VisitorAuthor
1-Visitor
November 22, 2017

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

20-Turquoise
November 27, 2017

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