A few useful OData commands | Questionmark

A few useful OData commands

Applies to the following products: 
Questionmark OnDemand
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.7

Questionmark's Results API uses the Microsoft implementation of OData and thus supports all the commands found at:

You may find the below Results API-specific commands useful.

You can send the following request to filter data to only retrieve results from a certain period of time (such as, in this example, results from the beginning of 2012 until now).

https://ondemand.questionmark.com/123456/odata/Results?$filter=ResultFinishedUtc gt datetime'2011-12-31T00:00:00'

You can use the $expand operater along with the date filter to return the participant record for each result that the above command would retrieve.

https://ondemand.questionmark.com/123456/odata/Results?$filter=ResultFinishedUtc gt datetime'2011-12-31T00:00:00'&$expand=Participant