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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

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

kbetances
2-Explorer

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.

3 REPLIES 3
posipova
20-Turquoise
(To:kbetances)

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?

posipova
20-Turquoise
(To:kbetances)

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

Announcements


Top Tags