POST api/NoPaperFormMAHER/ExecuteDataSetSP_MAHER?query={query}

Documentation for 'ExecuteDataSetSP_MAHER'.

Request Information

Parameters

NameDescriptionAdditional information
query 
Documentation for 'query'.

Define this parameter in the request URI.
parameters 
Documentation for 'parameters'.

Define this parameter in the request body.

Request body formats

application/json, text/json

Sample: 
[
  "sample string 6",
  "sample string 6",
  "sample string 6"
]

application/xml, text/xml

Sample: 
<ArrayOfSqlParameter xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/System.Data.SqlClient">
  <SqlParameter>
    <__identity i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/System" />
    <DbType xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Int64</DbType>
    <Direction xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Input</Direction>
    <IsNullable xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</IsNullable>
    <ParameterName xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 6</ParameterName>
    <Precision xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Precision>
    <Scale xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Scale>
    <Size xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">15</Size>
    <SourceColumn xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 16</SourceColumn>
    <SourceColumnNullMapping xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</SourceColumnNullMapping>
    <SourceVersion xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Original</SourceVersion>
    <Value xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common" />
    <CompareInfo>None</CompareInfo>
    <ForceColumnEncryption>true</ForceColumnEncryption>
    <LocaleId>5</LocaleId>
    <Offset>14</Offset>
    <Precision>64</Precision>
    <Scale>64</Scale>
    <SqlDbType>BigInt</SqlDbType>
    <SqlValue i:nil="true" />
    <TypeName>sample string 11</TypeName>
    <UdtTypeName>sample string 10</UdtTypeName>
    <XmlSchemaCollectionDatabase>sample string 1</XmlSchemaCollectionDatabase>
    <XmlSchemaCollectionName>sample string 3</XmlSchemaCollectionName>
    <XmlSchemaCollectionOwningSchema>sample string 2</XmlSchemaCollectionOwningSchema>
  </SqlParameter>
  <SqlParameter>
    <__identity i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/System" />
    <DbType xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Int64</DbType>
    <Direction xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Input</Direction>
    <IsNullable xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</IsNullable>
    <ParameterName xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 6</ParameterName>
    <Precision xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Precision>
    <Scale xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Scale>
    <Size xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">15</Size>
    <SourceColumn xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 16</SourceColumn>
    <SourceColumnNullMapping xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</SourceColumnNullMapping>
    <SourceVersion xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Original</SourceVersion>
    <Value xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common" />
    <CompareInfo>None</CompareInfo>
    <ForceColumnEncryption>true</ForceColumnEncryption>
    <LocaleId>5</LocaleId>
    <Offset>14</Offset>
    <Precision>64</Precision>
    <Scale>64</Scale>
    <SqlDbType>BigInt</SqlDbType>
    <SqlValue i:nil="true" />
    <TypeName>sample string 11</TypeName>
    <UdtTypeName>sample string 10</UdtTypeName>
    <XmlSchemaCollectionDatabase>sample string 1</XmlSchemaCollectionDatabase>
    <XmlSchemaCollectionName>sample string 3</XmlSchemaCollectionName>
    <XmlSchemaCollectionOwningSchema>sample string 2</XmlSchemaCollectionOwningSchema>
  </SqlParameter>
  <SqlParameter>
    <__identity i:nil="true" xmlns="http://schemas.datacontract.org/2004/07/System" />
    <DbType xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Int64</DbType>
    <Direction xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Input</Direction>
    <IsNullable xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</IsNullable>
    <ParameterName xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 6</ParameterName>
    <Precision xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Precision>
    <Scale xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">64</Scale>
    <Size xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">15</Size>
    <SourceColumn xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">sample string 16</SourceColumn>
    <SourceColumnNullMapping xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">true</SourceColumnNullMapping>
    <SourceVersion xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common">Original</SourceVersion>
    <Value xmlns="http://schemas.datacontract.org/2004/07/System.Data.Common" />
    <CompareInfo>None</CompareInfo>
    <ForceColumnEncryption>true</ForceColumnEncryption>
    <LocaleId>5</LocaleId>
    <Offset>14</Offset>
    <Precision>64</Precision>
    <Scale>64</Scale>
    <SqlDbType>BigInt</SqlDbType>
    <SqlValue i:nil="true" />
    <TypeName>sample string 11</TypeName>
    <UdtTypeName>sample string 10</UdtTypeName>
    <XmlSchemaCollectionDatabase>sample string 1</XmlSchemaCollectionDatabase>
    <XmlSchemaCollectionName>sample string 3</XmlSchemaCollectionName>
    <XmlSchemaCollectionOwningSchema>sample string 2</XmlSchemaCollectionOwningSchema>
  </SqlParameter>
</ArrayOfSqlParameter>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'FormUrlEncodedMediaTypeFormatterTracer' to write type 'SqlParameter[]'.

Response Information

Response body formats

application/json, text/json, application/xml, text/xml

Sample:

Sample not available.