Versions Compared

Version Old Version 3 New Version 4
Changes made by

Jason Reel (Deactivated)

Jason Reel (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
borderColor#ccc
titleColor#FFFFFF
bgColor#FCFCFC
titleColor#FFFFFF
titleBGColor#a0a0a0
borderStylesolid
titleChildren API
borderStylesolid

​This API will return the results of a custom ad hoc report created in OMS.

Info
Notice

Note the data is flattened and

just

only 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

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

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