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

[kbetances]

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.

[posipova]

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.

[kbetances]

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

[posipova]

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