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 }, ] }

Dezrez.Core.DataContracts.External.Api.Apps.Query.Get.AppReportingQueryDataContract

Name	Description	Type	Additional information
StoredProcName		string	None.
parameters		Collection of Dezrez.Core.DataContracts.External.Api.Apps.Query.Get.AppReportingQueryParametersDataContract	None.

Request Formats

application/x-www-form-urlencoded

Sample:

Sample not available.

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"
    }
  ]
}

Response Information

Resource Description

the values as dictionary of names and values

System.Net.Http.HttpResponseMessage

Name	Type	Additional information
Version	System.Version	None.
Content	System.Net.Http.HttpContent	None.
StatusCode	System.Net.HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	System.Net.Http.HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.