This API will return the results of a custom ad hoc report created in OMS.
Info
Notice the data is flattened and just the requested columns are returned. Because the data is flattened, there may be duplicate rows for some people, but that can easily be handled during processing once the data is returned. Going this route allows users to dictate which fields are returned by theAPI.
URL https://base.url.org/mvc/api/oms/adhoc-query/query-results/{{ ID }}
Parameters
Parameter Name
Required
Description
Default
ID
required
the numeric ID of the saved ad hoc report query
Responses
200 OK
Results were found that match the request and are included in the response body
401 Unauthorized
The current account in the request header does not have access to the API
403 Forbidden
The current account in the request header does not have access to the territory requested in the request URL
404 Not Found
Returned if NO results were found that match the specified criteria
500 Internal Server Error
One or more request string parameters are invalid or an error was encountered by the server while processing the request