How do you query the next x records in a DataTable using the QueryDataTableEntries service using REST API?
Nov 21, 2017
10:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nov 21, 2017
10:50 AM
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.
Labels:
- Labels:
-
Connectivity
- Tags:
- rest api
3 REPLIES 3
Nov 21, 2017
11:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nov 21, 2017
11:12 AM
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.
Nov 22, 2017
07:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nov 22, 2017
07:04 AM
Does Thingworx have the ability to query distinct values for a column in a table with JSON?
Nov 27, 2017
02:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nov 27, 2017
02:22 PM
You may use sql queries or javascript; also please refer to the json snippets available in the composer:
![](/skins/images/695EE5AD3E567050FEDD72575855ED93/ptc_skin/images/icon_anonymous_message.png)