Get Table Fields biconnector.table.fields

Choose a tool for developing with an AI agent:

  • use Alaio Vibecode to build an app for Bitrix24 from a task description without knowing any programming language. The agent writes the code and deploys the app to a server, with no manual hosting setup
  • use the MCP server to develop a REST API integration in your own project. The agent refers to the official REST documentation

Scope: biconnector

Who can execute the method: A user who has both the "Access to BI Builder" and "Access to Analytics Hub" permissions

The biconnector.table.fields method returns the description of the table fields.

The purpose of each field is described in the table fields table.

The method returns a static schema of the table fields — it is the same in any Bitrix24 and does not depend on the tables that were created. Unlike the other methods of the family, this method is available to a webhook, but it still checks both permissions and returns the ACCESS_DENIED error without them

Method Parameters

No parameters.

Code Examples

How to Use Examples in Documentation

curl -X POST \
        -H "Content-Type: application/json" \
        -H "Accept: application/json" \
        -d '{}' \
        https://**put_your_bitrix24_address**/rest/**put_your_user_id_here**/**put_your_webhook_here**/biconnector.table.fields
        
curl -X POST \
        -H "Content-Type: application/json" \
        -H "Accept: application/json" \
        -d '{"auth":"**put_access_token_here**"}' \
        https://**put_your_bitrix24_address**/rest/biconnector.table.fields
        
// This snippet is an ES module: top-level await requires type="module" or a bundler.
        // $b24 is an already-initialized SDK instance (see the SDK "Get started" guide).
        import { Text } from '@bitrix24/b24jssdk'
        import type { B24Frame } from '@bitrix24/b24jssdk'
        
        declare const $b24: B24Frame
        
        // Methods of this section put errors inside result and answer with HTTP 200
        type BiconnectorError = {
          error: {
            error: string
            error_description: string
          }
        }
        
        // Shape of the payload returned in result (match the "response handling" section of the page)
        type TableFieldsResult = {
          fields: {
            title: string
            type: string
            isRequired: boolean
            isReadOnly: boolean
            isImmutable: boolean
            isMultiple: boolean
          }[]
        }
        
        try {
          const response = await $b24.actions.v2.call.make<TableFieldsResult | BiconnectorError>({
            method: 'biconnector.table.fields',
            params: {},
            requestId: Text.getUuidRfc4122()
          })
        
          // The payload is available only on a successful response
          if (!response.isSuccess) {
            console.error(response.getErrorMessages().join('; '))
          } else {
            const result = response.getData()!.result
        
            // The SDK sees HTTP 200 as success, so check the error inside result yourself
            if ('error' in result) {
              console.error(result.error.error, result.error.error_description)
            } else {
              console.info('Table entity fields count:', result.fields.length, result.fields)
            }
          }
        } catch (error) {
          // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
          console.error(error)
        }
        
<!-- Load the SDK (UMD build); it is exposed as the global B24Js -->
        <script src="https://unpkg.com/@bitrix24/b24jssdk@1/dist/umd/index.min.js"></script>
        <script>
          async function getTableFields() {
            try {
              // Initialize the SDK inside a Bitrix24 frame
              const $b24 = await B24Js.initializeB24Frame()
        
              const response = await $b24.actions.v2.call.make({
                method: 'biconnector.table.fields',
                params: {},
                requestId: B24Js.Text.getUuidRfc4122()
              })
        
              // The payload is available only on a successful response
              if (!response.isSuccess) {
                console.error(response.getErrorMessages().join('; '))
                return
              }
        
              const result = response.getData().result
        
              // The SDK sees HTTP 200 as success, so check the error inside result yourself
              if (result && result.error) {
                console.error(result.error.error, result.error.error_description)
                return
              }
        
              console.info('Table entity fields count:', result.fields.length, result.fields)
            } catch (error) {
              // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
              console.error(error)
            }
          }
        
          document.addEventListener('DOMContentLoaded', getTableFields)
        </script>
        
from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        try:
            # b24pysdk has no ready-made wrapper for biconnector.table.*, so the method
            # is called directly through bitrix_token.call_method()
            response = bitrix_token.call_method(
                api_method="biconnector.table.fields",
            )
            result = response["result"]
        
            # Methods of this section put errors inside result and answer with HTTP 200
            if isinstance(result, dict) and "error" in result:
                print(
                    "BIconnector error",
                    f"error: {result['error']['error']}",
                    f"error_description: {result['error']['error_description']}",
                    sep="\n",
                )
            else:
                print(result)
        except BitrixAPIError as error:
            print(
                "Bitrix API error",
                f"error: {error.error}",
                f"error_description: {error.error_description}",
                sep="\n",
            )
        except BitrixSDKException as error:
            print(f"Bitrix SDK error: {error.message}")
        except Exception as error:
            print(f"Unexpected error: {error}")
        
try {
            $response = $b24Service
                ->core
                ->call(
                    'biconnector.table.fields',
                    []
                );
        
            $result = $response
                ->getResponseData()
                ->getResult();
        
            if ($result->error()) {
                echo 'Error: ' . $result->error();
            } else {
                $data = $result->data();
        
                // Methods of this section put errors inside result and answer with HTTP 200
                if (isset($data['error'])) {
                    echo 'BIconnector error: ' . $data['error']['error'] . ': ' . $data['error']['error_description'];
                } else {
                    echo 'Success: ' . print_r($data, true);
                }
            }
        
        } catch (Throwable $e) {
            error_log($e->getMessage());
            echo 'Error calling biconnector.table.fields: ' . $e->getMessage();
        }
        
BX24.callMethod(
            'biconnector.table.fields',
            {},
            (result) => {
                if (result.error()) {
                    console.error(result.error());
                    return;
                }
        
                const data = result.data();
        
                // Methods of this section put errors inside result and answer with HTTP 200
                if (data && data.error) {
                    console.error(data.error.error, data.error.error_description);
                    return;
                }
        
                console.info(data);
            },
        );
        
require_once('crest.php');
        
        $result = CRest::call(
            'biconnector.table.fields',
            []
        );
        
        // Methods of this section put errors inside result and answer with HTTP 200
        if (isset($result['result']['error'])) {
            echo 'BIconnector error: ' . $result['result']['error']['error']
                . ': ' . $result['result']['error']['error_description'];
        } else {
            echo '<PRE>';
            print_r($result);
            echo '</PRE>';
        }
        
// client and ctx are already created — see the Go SDK section
        res, err := client.Core().Call(ctx, "biconnector.table.fields", nil, b24.WithIdempotent())
        if err != nil {
        	return fmt.Errorf("biconnector.table.fields: %w", err)
        }
        
        // Methods of this section put errors inside result and answer with HTTP 200.
        var apiErr struct {
        	Error *struct {
        		Error       string `json:"error"`
        		Description string `json:"error_description"`
        	} `json:"error"`
        }
        if err := json.Unmarshal(res.Result, &apiErr); err == nil && apiErr.Error != nil {
        	return fmt.Errorf("biconnector.table.fields: %s: %s", apiErr.Error.Error, apiErr.Error.Description)
        }
        
        // The method wraps the response in an object with the "fields" key.
        raw, ok := b24.Unwrap(res.Result, "fields")
        if !ok {
        	return fmt.Errorf("no fields key in the response")
        }
        
        var items []struct {
        	Title       string `json:"title"`
        	Type        string `json:"type"`
        	IsRequired  bool   `json:"isRequired"`
        	IsReadOnly  bool   `json:"isReadOnly"`
        	IsImmutable bool   `json:"isImmutable"`
        	IsMultiple  bool   `json:"isMultiple"`
        }
        if err := json.Unmarshal(raw, &items); err != nil {
        	return fmt.Errorf("parse response: %w", err)
        }
        for _, it := range items {
        	fmt.Println(it.Title)
        }
        

Response Handling

HTTP status: 200

{
          "result": {
            "fields": [
              {
                "title": "id",
                "type": "integer",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "sourceId",
                "type": "integer",
                "isRequired": true,
                "isReadOnly": false,
                "isImmutable": true,
                "isMultiple": false
              },
              {
                "title": "name",
                "type": "string",
                "isRequired": true,
                "isReadOnly": false,
                "isImmutable": true,
                "isMultiple": false
              },
              {
                "title": "type",
                "type": "string",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "description",
                "type": "string",
                "isRequired": false,
                "isReadOnly": false,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "externalName",
                "type": "string",
                "isRequired": true,
                "isReadOnly": false,
                "isImmutable": true,
                "isMultiple": false
              },
              {
                "title": "externalCode",
                "type": "string",
                "isRequired": true,
                "isReadOnly": false,
                "isImmutable": true,
                "isMultiple": false
              },
              {
                "title": "externalId",
                "type": "integer",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "dateCreate",
                "type": "datetime",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "dateUpdate",
                "type": "datetime",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "createdById",
                "type": "integer",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "updatedById",
                "type": "integer",
                "isRequired": true,
                "isReadOnly": true,
                "isImmutable": false,
                "isMultiple": false
              },
              {
                "title": "fields",
                "type": "array",
                "isRequired": true,
                "isReadOnly": false,
                "isImmutable": false,
                "isMultiple": true
              }
            ]
          },
          "time": {
            "start": 1740757652.264398,
            "finish": 1740757652.343882,
            "duration": 0.0794839859008789,
            "processing": 2.002716064453125e-5,
            "date_start": "2025-02-28T15:47:32+00:00",
            "date_finish": "2025-02-28T15:47:32+00:00"
          }
        }
        

Returned Data

Name
type

Description

result
object

Root element of the response. It contains the single fields key

result.fields
object[]

Array of table field descriptors, one element per field (detailed description)

time
time

Information about the request execution time

Element of the fields array

Name
type

Description

title
string

Name of the table field. The purpose of the fields is described in the table fields table

type
string

Field type. The method returns the integer, string, array, and datetime values

isRequired
boolean

Indicates that the field is required in the object schema. On creation, you only have to pass the fields whose isRequired is true and isReadOnly is false: read-only fields also have this flag set to true, but they cannot be passed

isReadOnly
boolean

The field is read-only and cannot be passed to add or update

isImmutable
boolean

The value is set once when the table is created and does not change afterwards

isMultiple
boolean

Multiple field. If it is true, the value is passed as an array

The schema describes the fields of the table itself, not the data columns. It does not fully match the fields table: the CSV parsing parameters — csvDelimiter, csvEncoding, and csvHasHeaders — are absent from the schema, although they do arrive in the get and list responses. It is exactly against this schema that select, filter, and order of the biconnector.table.list method are checked. The composition of columns is returned by the biconnector.table.get method and changed by biconnector.table.fields.update.

Error Handling

HTTP status: 200

{
            "result": {
                "error": {
                    "error": "ACCESS_DENIED",
                    "error_description": "Access denied."
                }
            }
        }
        

The method returns an error inside the result field and with HTTP status 200. Check result.error: the SDK wrappers parse only the top level of the response and treat such an error as a success

Name
type

Description

error
string

String error code. It consists of digits, Latin letters, and underscores. It may arrive empty — in that case only error_description shows the reason

error_description
string

Error message for the developer. Do not show it to the end user without processing

Possible Error Codes

Code

Description

Value

ACCESS_DENIED

Access denied.

One of the two permissions is missing

Statuses and System Error Codes

HTTP Status: 4xx, 5xx

The errors described below are returned by the REST API itself, not by the logic of a specific method. They can arrive in response to any method.

Status

Code
Error Message

Description

500

INTERNAL_SERVER_ERROR
Internal server error

An internal server error has occurred. Retry the call, and if the error persists, contact the server administrator or Bitrix24 technical support

500

ERROR_UNEXPECTED_ANSWER
Server returned an unexpected response

The server returned an unexpected response. Retry the call, and if the error persists, contact the server administrator or Bitrix24 technical support

503

QUERY_LIMIT_EXCEEDED
Too many requests

The request intensity limit has been exceeded

429

OPERATION_TIME_LIMIT
Method is blocked due to operation time limit

The method is blocked because the request resource intensity limit has been exceeded. The block is lifted automatically once the accumulated execution time of the method no longer exceeds the limit

401

NO_AUTH_FOUND
Wrong authorization data

The request contains no authorization data: neither an access token nor a webhook code was passed

401

INVALID_REQUEST
Https required

Methods are called over the HTTPS protocol only

401

OVERLOAD_LIMIT
REST API is blocked due to overload

The REST API is blocked due to overload. This is a manual individual block. To have it lifted, contact Bitrix24 technical support

401

ACCESS_DENIED
REST is available only on commercial plans

REST API access is not active for this account. In Bitrix24 Cloud, check the current plan or trial status: Vibe+ plans include REST API access, while Essentials plans do not. A webhook receives a different error message — REST is available only by subscription

401

INVALID_CREDENTIALS
Invalid request credentials

No active webhook with the specified user identifier and secret code was found

404

ERROR_METHOD_NOT_FOUND
Method not found!

No method with this name was found. The name is misspelled, the method does not exist in the REST API, or it is unavailable without the required scope

401

insufficient_scope
The request requires higher privileges than provided by the webhook token

The request requires broader permissions than the token has: for a webhook these are the permissions granted to it, for an application it is the scope. For an application, the error message ends with provided by the access token

401

expired_token
The access token provided has expired

The access token has expired

401

user_access_error
The user does not have access to the application

The application is installed, but the Bitrix24 administrator has granted access to it only to specific users

403

PORTAL_DELETED
Portal was deleted

The public part of the site is closed. To open it on an on-premise installation, disable the "Temporary closure of the public part of the site" option. Path to the setting: Desktop > Settings > Product Settings > Module Settings > Main Module > Temporary closure of the public part of the site

Continue Learning