3E Data Insights API

04 - Tutorials

OVERVIEW

ODATA library provides a variety of ways for the user to filter the data. Here are some filters that you can add to your request.

Supported Commands

Description Filter Example
By any field value equal ?$filter=Field eq 'Value'

?$filter=Id eq '2'

?$filter=RowCreateDateTime eq 2020-06-09T20:00:28.467Z -- DateTime value should not be enclosed within single quotes
By any field value contains ?$filter=contains(Field, 'Value') ?$filter=contains(Task, 'Timekeeper')
Get Specific fields ?$select=Field1, Field2 ?$select=Task, Id
Get Count ?$count=true ?$count=true
Order ?$orderby=Field desc ?$orderby=Id desc
Top ?$top=2 ?$top=2
Skip ?$skip=2 ?$skip=2

 

 

Unsupported commands in DI API.

Description Filter Example
Expand Navigation Property ?$expand=NavProperty ?$expand=ActivityList_2

 

 

 

References: https://help.nintex.com/en-us/insight/OData/HE_CON_ODATAQueryCheatSheet.htm

Click here to download Postman Collection

Last Updated: Nov 08,2024