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

Request Formats

{
  "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