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