Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
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.
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.
Does Thingworx have the ability to query distinct values for a column in a table with JSON?
You may use sql queries or javascript; also please refer to the json snippets available in the composer: