POST api/app/reporting

Allows apps to access readonly stored proceedures for reporting These stored procs are only written by rezi, and will have to be approved before adding to the system, the stored procs must return a json string

Request Information

URI Parameters

None.

Body Parameters

{ "StoredProcName": "MyStoredProceedureName", "parameters": [ { "Name": "parameter1Name", "Value": "10-10-2021" }, { "Name": "monthsAgo", "Value": 3 }, { "Name": "negIds", "Value": [10101,10102,10103], "Type":"Int64" //c# .net built in type name }, ] }

AppReportingQueryDataContract
NameDescriptionTypeAdditional information
StoredProcName

string

None.

parameters

Collection of AppReportingQueryParametersDataContract

None.

Request Formats

application/json, text/json

Sample:
{
  "StoredProcName": "sample string 1",
  "parameters": [
    {
      "Name": "sample string 1",
      "Value": {},
      "Type": "sample string 3"
    },
    {
      "Name": "sample string 1",
      "Value": {},
      "Type": "sample string 3"
    }
  ]
}

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

the values as dictionary of names and values

HttpResponseMessage
NameDescriptionTypeAdditional information
Version

Version

None.

Content

HttpContent

None.

StatusCode

HttpStatusCode

None.

ReasonPhrase

string

None.

Headers

Collection of Object

None.

RequestMessage

HttpRequestMessage

None.

IsSuccessStatusCode

boolean

None.