POST api/v2/schema

Gets schema information for one or more tables.

Request Information

URI Parameters

None.

Body Parameters

Collection of string

Request Formats

application/json, text/json

Sample:

[
  "sample string 1",
  "sample string 2"
]

application/xml, text/xml

Sample:

<ArrayOfstring xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <string>sample string 1</string>
  <string>sample string 2</string>
</ArrayOfstring>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of TableSchema

Name	Description	Type	Additional information
Table		string	None.
Fields		Collection of TableFieldSchema	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "Table": "sample string 1",
    "Fields": [
      {
        "Field": "sample string 1",
        "TypeName": "sample string 2",
        "MaxLength": 3,
        "Precision": 4,
        "Scale": 5,
        "IsNullable": true
      },
      {
        "Field": "sample string 1",
        "TypeName": "sample string 2",
        "MaxLength": 3,
        "Precision": 4,
        "Scale": 5,
        "IsNullable": true
      }
    ]
  },
  {
    "Table": "sample string 1",
    "Fields": [
      {
        "Field": "sample string 1",
        "TypeName": "sample string 2",
        "MaxLength": 3,
        "Precision": 4,
        "Scale": 5,
        "IsNullable": true
      },
      {
        "Field": "sample string 1",
        "TypeName": "sample string 2",
        "MaxLength": 3,
        "Precision": 4,
        "Scale": 5,
        "IsNullable": true
      }
    ]
  }
]

application/xml, text/xml

Sample:

<ArrayOfTableSchema xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/SchoolMint.Aeries.DataV2">
  <TableSchema>
    <Fields>
      <TableFieldSchema>
        <Field>sample string 1</Field>
        <IsNullable>true</IsNullable>
        <MaxLength>3</MaxLength>
        <Precision>4</Precision>
        <Scale>5</Scale>
        <TypeName>sample string 2</TypeName>
      </TableFieldSchema>
      <TableFieldSchema>
        <Field>sample string 1</Field>
        <IsNullable>true</IsNullable>
        <MaxLength>3</MaxLength>
        <Precision>4</Precision>
        <Scale>5</Scale>
        <TypeName>sample string 2</TypeName>
      </TableFieldSchema>
    </Fields>
    <Table>sample string 1</Table>
  </TableSchema>
  <TableSchema>
    <Fields>
      <TableFieldSchema>
        <Field>sample string 1</Field>
        <IsNullable>true</IsNullable>
        <MaxLength>3</MaxLength>
        <Precision>4</Precision>
        <Scale>5</Scale>
        <TypeName>sample string 2</TypeName>
      </TableFieldSchema>
      <TableFieldSchema>
        <Field>sample string 1</Field>
        <IsNullable>true</IsNullable>
        <MaxLength>3</MaxLength>
        <Precision>4</Precision>
        <Scale>5</Scale>
        <TypeName>sample string 2</TypeName>
      </TableFieldSchema>
    </Fields>
    <Table>sample string 1</Table>
  </TableSchema>
</ArrayOfTableSchema>