POST api/Schema?sqlQuery={sqlQuery}&numrecs={numrecs}

Request Information

URI Parameters

Name	Description	Type	Additional information
sqlQuery		string	Required
numrecs		integer	Required

Body Parameters

MyPars

Name	Description	Type	Additional information
thegsid		CustrackSID	None.
themysql		string	None.

Request Formats

application/json, text/json

Sample:

{
  "thegsid": {
    "API_Version": "sample string 1",
    "Employee_No": "sample string 2",
    "Emp_Name": "sample string 3",
    "Guid": "sample string 4",
    "ConnString": "sample string 5",
    "Security_Aray": [
      true,
      true
    ],
    "Organisation_Name": "sample string 6",
    "Territory_Code": "sample string 7",
    "EvoCompany": "sample string 8",
    "CKEY": "sample string 9",
    "refno": 10,
    "Services": "sample string 11",
    "QBCode": "sample string 12",
    "QBRealmID": "sample string 13",
    "VatPerc": 14.1
  },
  "themysql": "sample string 1"
}

application/xml, text/xml

Sample:

<SchemaController.MyPars xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Custrack_API.Controllers">
  <thegsid xmlns:d2p1="http://schemas.datacontract.org/2004/07/Custrack_API.Models">
    <d2p1:API_Version>sample string 1</d2p1:API_Version>
    <d2p1:CKEY>sample string 9</d2p1:CKEY>
    <d2p1:ConnString>sample string 5</d2p1:ConnString>
    <d2p1:Emp_Name>sample string 3</d2p1:Emp_Name>
    <d2p1:Employee_No>sample string 2</d2p1:Employee_No>
    <d2p1:EvoCompany>sample string 8</d2p1:EvoCompany>
    <d2p1:Guid>sample string 4</d2p1:Guid>
    <d2p1:Organisation_Name>sample string 6</d2p1:Organisation_Name>
    <d2p1:QBCode>sample string 12</d2p1:QBCode>
    <d2p1:QBRealmID>sample string 13</d2p1:QBRealmID>
    <d2p1:Security_Aray xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:boolean>true</d3p1:boolean>
      <d3p1:boolean>true</d3p1:boolean>
    </d2p1:Security_Aray>
    <d2p1:Services>sample string 11</d2p1:Services>
    <d2p1:Territory_Code>sample string 7</d2p1:Territory_Code>
    <d2p1:VatPerc>14.1</d2p1:VatPerc>
    <d2p1:refno>10</d2p1:refno>
  </thegsid>
  <themysql>sample string 1</themysql>
</SchemaController.MyPars>

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 'MyPars'.

Response Information

Resource Description

string

Response Formats

application/json, text/json

Sample:

"sample string 1"

application/xml, text/xml

Sample:

<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">sample string 1</string>