GET api/PVCA?Sql={Sql}

Request Information

URI Parameters

Name	Description	Type	Additional information
Sql		string	Required

Body Parameters

None.

Response Information

Resource Description

Collection of GetPVCA

Name	Type	Additional information
VM_VCID	string	None.
VM_VCTYPE	string	None.
VM_VCNAME	string	None.
VM_QTY	string	None.
VM_EXPIREDATE	string	None.
VM_VC_STATUS	string	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "vM_VCID": "sample string 1",
    "vM_VCTYPE": "sample string 2",
    "vM_VCNAME": "sample string 3",
    "vM_QTY": "sample string 4",
    "vM_EXPIREDATE": "sample string 5",
    "vM_VC_STATUS": "sample string 6"
  },
  {
    "vM_VCID": "sample string 1",
    "vM_VCTYPE": "sample string 2",
    "vM_VCNAME": "sample string 3",
    "vM_QTY": "sample string 4",
    "vM_EXPIREDATE": "sample string 5",
    "vM_VC_STATUS": "sample string 6"
  }
]

application/xml, text/xml

Sample:

<ArrayOfGetPVCA xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/webAPI1.Models">
  <GetPVCA>
    <VM_EXPIREDATE>sample string 5</VM_EXPIREDATE>
    <VM_QTY>sample string 4</VM_QTY>
    <VM_VCID>sample string 1</VM_VCID>
    <VM_VCNAME>sample string 3</VM_VCNAME>
    <VM_VCTYPE>sample string 2</VM_VCTYPE>
    <VM_VC_STATUS>sample string 6</VM_VC_STATUS>
  </GetPVCA>
  <GetPVCA>
    <VM_EXPIREDATE>sample string 5</VM_EXPIREDATE>
    <VM_QTY>sample string 4</VM_QTY>
    <VM_VCID>sample string 1</VM_VCID>
    <VM_VCNAME>sample string 3</VM_VCNAME>
    <VM_VCTYPE>sample string 2</VM_VCTYPE>
    <VM_VC_STATUS>sample string 6</VM_VC_STATUS>
  </GetPVCA>
</ArrayOfGetPVCA>