This API will return the results of a custom ad hoc report created in OMS.
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 |
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 |