POST api/ExecuteSPResults?public_auth_key={public_auth_key}

Get Stored Procedure Results As JSON String

Request Information

URI Parameters

NameDescriptionTypeAdditional information
public_auth_key

string

Required

Body Parameters

SPExecutePostInput
NameDescriptionTypeAdditional information
sp_name

string

None.

parameters

Dictionary of string [key] and Object [value]

None.

Request Formats

application/json, text/json

Sample:
{
  "sp_name": "sample string 1",
  "parameters": {
    "sample string 1": {},
    "sample string 3": {}
  }
}

application/xml, text/xml

Sample:
<SPExecutePostInput xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/WebApplicationITTF1.Controllers">
  <parameters xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>sample string 1</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>sample string 3</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </parameters>
  <sp_name>sample string 1</sp_name>
</SPExecutePostInput>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of Object

None.

Response Formats

application/json, text/json

Sample:

Sample not available.