GET api/ErpVTFormpathanddesc/GetErpVTDataTypeandMaxlength?TABLE_NAME={TABLE_NAME}&COLUMN_NAME={COLUMN_NAME}

Request Information

URI Parameters

Name	Description	Type	Additional information
TABLE_NAME		string	Required
COLUMN_NAME		string	Required

Body Parameters

None.

Response Information

Resource Description

ErpVTDataTypeandMaxlengthApiResponse

Name	Type	Additional information
status	string	None.
message	string	None.
response	ErpVTDataTypeandMaxlength	None.

Response Formats

application/json, text/json

Sample:

{
  "status": "sample string 1",
  "message": "sample string 2",
  "response": {
    "DATA_TYPE": "sample string 1",
    "NUMERIC_PRECISION": "sample string 2",
    "NUMERIC_SCALE": "sample string 3",
    "CHARACTER_MAXIMUM_LENGTH": "sample string 4",
    "maxlengthField": "sample string 5",
    "IS_NULLABLE": "sample string 6"
  }
}

text/html

Sample:

{"status":"sample string 1","message":"sample string 2","response":{"DATA_TYPE":"sample string 1","NUMERIC_PRECISION":"sample string 2","NUMERIC_SCALE":"sample string 3","CHARACTER_MAXIMUM_LENGTH":"sample string 4","maxlengthField":"sample string 5","IS_NULLABLE":"sample string 6"}}

application/xml, text/xml

Sample:

<ErpVTDataTypeandMaxlengthApiResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/SuntechSupportServices.Models.ERP_VT">
  <message>sample string 2</message>
  <response>
    <CHARACTER_MAXIMUM_LENGTH>sample string 4</CHARACTER_MAXIMUM_LENGTH>
    <DATA_TYPE>sample string 1</DATA_TYPE>
    <IS_NULLABLE>sample string 6</IS_NULLABLE>
    <NUMERIC_PRECISION>sample string 2</NUMERIC_PRECISION>
    <NUMERIC_SCALE>sample string 3</NUMERIC_SCALE>
    <maxlengthField>sample string 5</maxlengthField>
  </response>
  <status>sample string 1</status>
</ErpVTDataTypeandMaxlengthApiResponse>

multipart/form-data

Sample:

--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="status"

sample string 1
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="message"

sample string 2
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.DATA_TYPE"

sample string 1
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.NUMERIC_PRECISION"

sample string 2
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.NUMERIC_SCALE"

sample string 3
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.CHARACTER_MAXIMUM_LENGTH"

sample string 4
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.maxlengthField"

sample string 5
--MultipartDataMediaFormatterBoundary1q2w3e
Content-Disposition: form-data; name="response.IS_NULLABLE"

sample string 6
--MultipartDataMediaFormatterBoundary1q2w3e--