GET api/GetTableFieldsByTableName/{table}

Request Information

URI Parameters

NameDescriptionTypeAdditional information
table

string

Required

Body Parameters

None.

Response Information

Resource Description

Collection of TableFields
NameDescriptionTypeAdditional information
LookupTable

string

None.

LookupDetailsValue

string

None.

LookupDetailsID

integer

None.

DataType

string

None.

LookupGroup

string

None.

Category

string

None.

DBFieldName

string

None.

Response Formats

application/json, text/json

Sample:
[
  {
    "LookupTable": "sample string 1",
    "LookupDetailsValue": "sample string 2",
    "LookupDetailsID": 3,
    "DataType": "sample string 4",
    "LookupGroup": "sample string 5",
    "Category": "sample string 6",
    "DBFieldName": "sample string 7"
  },
  {
    "LookupTable": "sample string 1",
    "LookupDetailsValue": "sample string 2",
    "LookupDetailsID": 3,
    "DataType": "sample string 4",
    "LookupGroup": "sample string 5",
    "Category": "sample string 6",
    "DBFieldName": "sample string 7"
  }
]

application/xml, text/xml

Sample:
<ArrayOfTableFields xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Goaa.iPro.Data.Admin.CustomClasses">
  <TableFields>
    <Category>sample string 6</Category>
    <DBFieldName>sample string 7</DBFieldName>
    <DataType>sample string 4</DataType>
    <LookupDetailsID>3</LookupDetailsID>
    <LookupDetailsValue>sample string 2</LookupDetailsValue>
    <LookupGroup>sample string 5</LookupGroup>
    <LookupTable>sample string 1</LookupTable>
  </TableFields>
  <TableFields>
    <Category>sample string 6</Category>
    <DBFieldName>sample string 7</DBFieldName>
    <DataType>sample string 4</DataType>
    <LookupDetailsID>3</LookupDetailsID>
    <LookupDetailsValue>sample string 2</LookupDetailsValue>
    <LookupGroup>sample string 5</LookupGroup>
    <LookupTable>sample string 1</LookupTable>
  </TableFields>
</ArrayOfTableFields>