GET rest/Columns

Request Information

URI Parameters

None.

Body Parameters

None.

Response Information

Resource Description

Collection of ColumnModel

Name	Type	Additional information
ID	integer	None.
TableID	integer	None.
Name	string	None.
Field	string	None.
DataTypeID	integer	None.
DataType	string	None.
DataTypeFormat	string	None.
DataTypeDisplay	string	None.
UnknownDataType	boolean	None.
Formula	string	None.
InBuilt	boolean	None.
Order	integer	None.
DefaultValue	string	None.
CreateDate	date	None.
ModifiedDate	date	None.
CreatedUser	string	None.
CreatedUserID	integer	None.
ModifiedUser	string	None.
ModifiedUserID	integer	None.
CalculatedFormula	string	None.
VisibleByDefault	boolean	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "ID": 1,
    "TableID": 2,
    "Name": "sample string 3",
    "Field": "sample string 4",
    "DataTypeID": 5,
    "DataType": "sample string 6",
    "DataTypeFormat": "sample string 7",
    "DataTypeDisplay": "sample string 8",
    "UnknownDataType": true,
    "Formula": "sample string 10",
    "InBuilt": true,
    "Order": 12,
    "DefaultValue": "sample string 13",
    "CreateDate": "2026-04-03T03:36:13.1892125+00:00",
    "ModifiedDate": "2026-04-03T03:36:13.1892125+00:00",
    "CreatedUser": "sample string 15",
    "CreatedUserID": 16,
    "ModifiedUser": "sample string 17",
    "ModifiedUserID": 1,
    "CalculatedFormula": "sample string 18",
    "VisibleByDefault": true
  },
  {
    "ID": 1,
    "TableID": 2,
    "Name": "sample string 3",
    "Field": "sample string 4",
    "DataTypeID": 5,
    "DataType": "sample string 6",
    "DataTypeFormat": "sample string 7",
    "DataTypeDisplay": "sample string 8",
    "UnknownDataType": true,
    "Formula": "sample string 10",
    "InBuilt": true,
    "Order": 12,
    "DefaultValue": "sample string 13",
    "CreateDate": "2026-04-03T03:36:13.1892125+00:00",
    "ModifiedDate": "2026-04-03T03:36:13.1892125+00:00",
    "CreatedUser": "sample string 15",
    "CreatedUserID": 16,
    "ModifiedUser": "sample string 17",
    "ModifiedUserID": 1,
    "CalculatedFormula": "sample string 18",
    "VisibleByDefault": true
  }
]

text/xml

Sample:

<ArrayOfColumnModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Navigator.Models">
  <ColumnModel>
    <CalculatedFormula>sample string 18</CalculatedFormula>
    <CreateDate>2026-04-03T03:36:13.1892125+00:00</CreateDate>
    <CreatedUser>sample string 15</CreatedUser>
    <CreatedUserID>16</CreatedUserID>
    <DataType>sample string 6</DataType>
    <DataTypeDisplay>sample string 8</DataTypeDisplay>
    <DataTypeFormat>sample string 7</DataTypeFormat>
    <DataTypeID>5</DataTypeID>
    <DefaultValue>sample string 13</DefaultValue>
    <Field>sample string 4</Field>
    <Formula>sample string 10</Formula>
    <ID>1</ID>
    <InBuilt>true</InBuilt>
    <ModifiedDate>2026-04-03T03:36:13.1892125+00:00</ModifiedDate>
    <ModifiedUser>sample string 17</ModifiedUser>
    <ModifiedUserID>1</ModifiedUserID>
    <Name>sample string 3</Name>
    <Order>12</Order>
    <TableID>2</TableID>
    <UnknownDataType>true</UnknownDataType>
    <VisibleByDefault>true</VisibleByDefault>
  </ColumnModel>
  <ColumnModel>
    <CalculatedFormula>sample string 18</CalculatedFormula>
    <CreateDate>2026-04-03T03:36:13.1892125+00:00</CreateDate>
    <CreatedUser>sample string 15</CreatedUser>
    <CreatedUserID>16</CreatedUserID>
    <DataType>sample string 6</DataType>
    <DataTypeDisplay>sample string 8</DataTypeDisplay>
    <DataTypeFormat>sample string 7</DataTypeFormat>
    <DataTypeID>5</DataTypeID>
    <DefaultValue>sample string 13</DefaultValue>
    <Field>sample string 4</Field>
    <Formula>sample string 10</Formula>
    <ID>1</ID>
    <InBuilt>true</InBuilt>
    <ModifiedDate>2026-04-03T03:36:13.1892125+00:00</ModifiedDate>
    <ModifiedUser>sample string 17</ModifiedUser>
    <ModifiedUserID>1</ModifiedUserID>
    <Name>sample string 3</Name>
    <Order>12</Order>
    <TableID>2</TableID>
    <UnknownDataType>true</UnknownDataType>
    <VisibleByDefault>true</VisibleByDefault>
  </ColumnModel>
</ArrayOfColumnModel>