---
title: "REST - Table"
canonical: "https://help.agiloft.com/space/HELP/43715609/REST+-+Table"
format: markdown
---
The EWTable operation returns a list of all the tables and fields in the system.

- **Returns**: For tables, the label and logical table name are returned. For fields, the field name, label, type, and required flag are returned. Linked fields return only the source table information. Choice fields return the ID and name of the selected value. Action buttons, related tables, embedded search results, and embedded communications are not supported.
- **Supported Content-Type**:
  - For requests: application/x-www-form-urlencoded
  - For returns: application/json
- Accepts a URL with URL-encoded parameters and record data. For more information about general URL conventions, see [REST Interface](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43715778).
- Use the `table` parameter to request information only about a specific table, rather than every table and field in the system. This parameter accepts the table's logical name, such as `table=contacts`.
- Use the parameter `includelinkedinfo` to request additional information about linked fields. An example with `includelinkedinfo=true` is included below.
- Use the parameter `skipColumnsInfo` and set it to `true` to request only table information and not field information.

> ⚠️ This operation supports GET and POST requests. It must be used with [EWLogin](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714204) or OAuth 2.0 authorization.
> ⚠️ 
> ⚠️ This operation is never used asynchronously.

## Example

Assume an instance of Agiloft is available on localhost, port 8080 and is called "Demo". Retrieve a list of the tables and fields, and include information about any linked fields.

After obtaining an authorization token with [JWT](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714204), the following request is issued: 

```xml
https://localhost:8080/ewws/EWTable/.json?$KB=Demo&includelinkedinfo=true
```

A result similar to the following excerpt will be returned: 

```xml
{
    "success": true,
    "message": "",
    "result": {
        "tables": [
            {
              "label": "WMI Sample",
               "logicalName": "wmi_sample",
               "fields": [
                   {
                       "columnLabel": "ID",
                       "columnName": "id",
                       "columnType": "BIGINT",
                       "columnTypeDomain":"swautoincrementfield"
                   },
                   {
                       "columnLabel": "Type",
                       "columnName": "type",
                       "columnType": "BIGINT",
                       "columnTypeDomain": "swobjecttype"
                   },
                   {
                       "columnLabel": "Date Updated",
                       "columnName": "date_updated",
                       "columnType": "DATETIME",
                       "columnTypeDomain": "swdatetimefield"
                   },
                   {
						"columnLabel": "Updated By",
						"columnName": "_1794_full_name",
						"columnType": "VARCHAR",
						"columnTypeDomain": "swshorttextfield",
						"isLinked": true,
						"linkedInfo": [
							{
							"linkedTable": "contacts",
							"linkedColumn": "full_name",
							"linkedDao": "_dao3_link0"
							}
						],
						"textFieldType": "text/plain"
					},

...
```

> Macro (hide-if)
> 
> #### Related articles
> 
> > Macro (contentbylabel)