View ERM Query Results

Returns the results of a query in the ERM solution. Queries are accessible only to their authors, editors, and audience members.

 

URL

{RMUrl}/api/enterpriseriskmanagement/queries/<Query>[?[page=<Page>][[&]page_size=<PageSize>]]

 

REQUEST METHOD

GET

 

URL PARAMETERS

Query: This parameter is provided in the URL and can be either the query name or the query GUID. Queries with special characters in their names cannot be run through the API.

page: Number of the page to be displayed. Valid values: 1 to the maximum number of pages. If omitted, the value 1 is used. If the value is greater than the maximum number of pages, a blank list will be returned.

page_size: Number of items displayed per page. Valid values: 1 to 1,000. If omitted, the default value of 10 is used.

 

REQUEST EXAMPLES

The first ten results of the "Enterprise Objectives" query:

{RMUrl}/api/enterpriseriskmanagement/queries/Enterprise Objectives

{RMUrl}/api/enterpriseriskmanagement/queries/cc45b704-b3d5-11e0-8b69-001ec91f4b0a

 

Results 21 through 30 (third page, size 10):

{RMUrl}/api/enterpriseriskmanagement/queries/Enterprise Objectives?page=3&page_size=10

{RMUrl}/api/enterpriseriskmanagement/queries/cc45b704-b3d5-11e0-8b69-001ec91f4b0a?page=3&page_size=10

 

SUCCESS RESPONSE

Returns a dynamic list of objects, according to the columns selected when creating the query and their respective values.

 

SUCCESS RESPONSE EXAMPLE

[

{      

"AccountingDate":"\/Date(1426042800000-0300)\/","Type":"Financing Assets","LossEventResponsible":"Carlos Luiz Magno (deleted)","Name":"Petrobras Bonds","Value":220.0},

{"AccountingDate":"\/Date(1426906800000-0300)\/","Type":"Legal","LossEventResponsible":"Felipe Mariano","Name":"Orion Legal Process","Value":50.0},

{"AccountingDate":"\/Date(1436324400000-0300)\/","Type":"Generic","LossEventResponsible":"Mauro Taberna","Name":"Small Court Losses","Value":1.0},

{"AccountingDate":"\/Date(1443754800000-0300)\/","Type":"Legal","LossEventResponsible":"Muriel Motta","Name":" CRIO Trial Court Decision","Value":300.0

}

]