PUT api/DatasetFromStoredProcedure

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
StoredProcedureName	string	None.
SqlParametersList	Collection of SqlParamaterForStoredProcedure	None.
SecurityToken	globally unique identifier	None.
CustomerId	globally unique identifier	None.
UniqueIdDispositivo	globally unique identifier	None.
Ambiente	string	None.
DataBaseLogicalName	string	None.
ApiAppName	string	None.

Request Formats

application/json, text/json

Sample:

{
  "StoredProcedureName": "sample string 1",
  "SqlParametersList": [
    {
      "ParameterName": "sample string 1",
      "SqlDbTypeName": "sample string 2",
      "ParameterDirectionName": "sample string 3",
      "PrarameterValue": {},
      "PrarameterValueByteArray": "QEA="
    },
    {
      "ParameterName": "sample string 1",
      "SqlDbTypeName": "sample string 2",
      "ParameterDirectionName": "sample string 3",
      "PrarameterValue": {},
      "PrarameterValueByteArray": "QEA="
    }
  ],
  "SecurityToken": "7c47f14c-333c-49f8-9c3c-86b806dfb30e",
  "CustomerId": "1fbce07b-ceed-4e5a-aca7-05dd1a9806bf",
  "UniqueIdDispositivo": "d1cce5e8-a8ca-4822-adca-3489e3a54797",
  "Ambiente": "sample string 4",
  "DataBaseLogicalName": "sample string 5",
  "ApiAppName": "sample string 6"
}

application/xml, text/xml

Sample:

<DatasetFromStoredProcedureRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/XmaintServices.Models">
  <Ambiente>sample string 4</Ambiente>
  <ApiAppName>sample string 6</ApiAppName>
  <CustomerId>1fbce07b-ceed-4e5a-aca7-05dd1a9806bf</CustomerId>
  <DataBaseLogicalName>sample string 5</DataBaseLogicalName>
  <SecurityToken>7c47f14c-333c-49f8-9c3c-86b806dfb30e</SecurityToken>
  <UniqueIdDispositivo>d1cce5e8-a8ca-4822-adca-3489e3a54797</UniqueIdDispositivo>
  <SqlParametersList>
    <SqlParamaterForStoredProcedure>
      <ParameterDirectionName>sample string 3</ParameterDirectionName>
      <ParameterName>sample string 1</ParameterName>
      <PrarameterValue />
      <PrarameterValueByteArray>QEA=</PrarameterValueByteArray>
      <SqlDbTypeName>sample string 2</SqlDbTypeName>
    </SqlParamaterForStoredProcedure>
    <SqlParamaterForStoredProcedure>
      <ParameterDirectionName>sample string 3</ParameterDirectionName>
      <ParameterName>sample string 1</ParameterName>
      <PrarameterValue />
      <PrarameterValueByteArray>QEA=</PrarameterValueByteArray>
      <SqlDbTypeName>sample string 2</SqlDbTypeName>
    </SqlParamaterForStoredProcedure>
  </SqlParametersList>
  <StoredProcedureName>sample string 1</StoredProcedureName>
</DatasetFromStoredProcedureRequest>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'DatasetFromStoredProcedureRequest'.

Response Information

Resource Description

DatasetFromStoredProcedureResult

Name	Type	Additional information
sProcName	string	None.
DataSetXml	string	None.
SecurityToken	globally unique identifier	None.
CustomerId	globally unique identifier	None.
ErrorMessage	string	None.
AuthorizationErrorMessage	string	None.
Success	boolean	None.

Response Formats

application/json, text/json

Sample:

{
  "sProcName": "sample string 1",
  "DataSetXml": "sample string 2",
  "SecurityToken": "06b51e4c-6d49-40bf-9684-e58547c1fa62",
  "CustomerId": "4c26120e-f10e-4c60-b4d8-5355bd6bc0d7",
  "ErrorMessage": "sample string 5",
  "AuthorizationErrorMessage": "sample string 6",
  "Success": true
}

application/xml, text/xml

Sample:

<DatasetFromStoredProcedureResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/XmaintServices.Models">
  <AuthorizationErrorMessage>sample string 6</AuthorizationErrorMessage>
  <CustomerId>4c26120e-f10e-4c60-b4d8-5355bd6bc0d7</CustomerId>
  <ErrorMessage>sample string 5</ErrorMessage>
  <SecurityToken>06b51e4c-6d49-40bf-9684-e58547c1fa62</SecurityToken>
  <Success>true</Success>
  <DataSetXml>sample string 2</DataSetXml>
  <sProcName>sample string 1</sProcName>
</DatasetFromStoredProcedureResult>