Создать таблицу biconnector.table.add

// 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 TableAddResult = {
  id: number
}

try {
  const response = await $b24.actions.v2.call.make<TableAddResult | BiconnectorError>({
    method: 'biconnector.table.add',
    params: {
      fields: {
        sourceId: 3,
        name: 'sales_orders',
        externalName: 'Sales orders',
        externalCode: 'sales_orders',
        description: 'Table description',
        fields: [
          { type: 'int', name: 'ID', externalCode: 'ID' },
          { type: 'string', name: 'NAME', externalCode: 'NAME' },
          { type: 'string', name: 'SURNAME', externalCode: 'SURNAME' },
          { type: 'double', name: 'SCORE', externalCode: 'SCORE' },
          { type: 'date', name: 'DATA', externalCode: 'DATA' },
          { type: 'datetime', name: 'TIME', externalCode: 'TIME' },
        ],
      },
    },
    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('Created table id:', result.id)
    }
  }
} 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 addTable() {
    try {
      // Initialize the SDK inside a Bitrix24 frame
      const $b24 = await B24Js.initializeB24Frame()

      const response = await $b24.actions.v2.call.make({
        method: 'biconnector.table.add',
        params: {
          fields: {
            sourceId: 3,
            name: 'sales_orders',
            externalName: 'Sales orders',
            externalCode: 'sales_orders',
            description: 'Table description',
            fields: [
              { type: 'int', name: 'ID', externalCode: 'ID' },
              { type: 'string', name: 'NAME', externalCode: 'NAME' },
              { type: 'string', name: 'SURNAME', externalCode: 'SURNAME' },
              { type: 'double', name: 'SCORE', externalCode: 'SCORE' },
              { type: 'date', name: 'DATA', externalCode: 'DATA' },
              { type: 'datetime', name: 'TIME', externalCode: 'TIME' },
            ],
          },
        },
        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('Created table id:', result.id)
    } catch (error) {
      // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
      console.error(error)
    }
  }

  document.addEventListener('DOMContentLoaded', addTable)
</script>

from b24pysdk.errors import BitrixAPIError, BitrixSDKException

try:
    # В b24pysdk нет готовой обертки для biconnector.table.*, поэтому метод
    # вызывается напрямую через bitrix_token.call_method()
    response = bitrix_token.call_method(
        api_method="biconnector.table.add",
        params={
            "fields": {
                "sourceId": 3,
                "name": "sales_orders",
                "externalName": "Sales orders",
                "externalCode": "sales_orders",
                "description": "Table description",
                "fields": [
                    {"type": "int", "name": "ID", "externalCode": "ID"},
                    {"type": "string", "name": "NAME", "externalCode": "NAME"},
                    {"type": "string", "name": "SURNAME", "externalCode": "SURNAME"},
                    {"type": "double", "name": "SCORE", "externalCode": "SCORE"},
                    {"type": "date", "name": "DATA", "externalCode": "DATA"},
                    {"type": "datetime", "name": "TIME", "externalCode": "TIME"},
                ],
            },
        },
    )
    result = response["result"]

    # Методы раздела кладут ошибку внутрь result и отвечают со статусом 200
    if isinstance(result, dict) and "error" in result:
        print(
            "Ошибка BIconnector",
            f"error: {result['error']['error']}",
            f"error_description: {result['error']['error_description']}",
            sep="\n",
        )
    else:
        print(result)
except BitrixAPIError as error:
    print(
        "Ошибка Bitrix API",
        f"error: {error.error}",
        f"error_description: {error.error_description}",
        sep="\n",
    )
except BitrixSDKException as error:
    print(f"Ошибка Bitrix SDK: {error.message}")
except Exception as error:
    print(f"Непредвиденная ошибка: {error}")

try {
    $response = $b24Service
        ->core
        ->call(
            'biconnector.table.add',
            [
                'fields' => [
                    'sourceId'      => 3,
                    'name'          => 'sales_orders',
                    'externalName'  => 'Sales orders',
                    'externalCode'  => 'sales_orders',
                    'description'   => 'Описание таблицы',
                    'fields'        => [
                        ['type' => 'int', 'name' => 'ID', 'externalCode' => 'ID'],
                        ['type' => 'string', 'name' => 'NAME', 'externalCode' => 'NAME'],
                        ['type' => 'string', 'name' => 'SURNAME', 'externalCode' => 'SURNAME'],
                        ['type' => 'double', 'name' => 'SCORE', 'externalCode' => 'SCORE'],
                        ['type' => 'date', 'name' => 'DATA', 'externalCode' => 'DATA'],
                        ['type' => 'datetime', 'name' => 'TIME', 'externalCode' => 'TIME'],
                    ],
                ],
            ]
        );

    $result = $response
        ->getResponseData()
        ->getResult();

    if ($result->error()) {
        error_log($result->error());
        echo 'Error: ' . $result->error();
    } else {
        $data = $result->data();

        // Методы раздела кладут ошибку внутрь result и отвечают со статусом 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 adding table: ' . $e->getMessage();
}

BX24.callMethod(
    'biconnector.table.add',
    {
        fields: {
            "sourceId": 3,
            "name": "sales_orders",
            "externalName": "Sales orders",
            "externalCode": "sales_orders",
            "description": "Описание таблицы",
            "fields": [
                { "type": "int", "name": "ID", "externalCode": "ID" },
                { "type": "string", "name": "NAME", "externalCode": "NAME" },
                { "type": "string", "name": "SURNAME", "externalCode": "SURNAME" },
                { "type": "double", "name": "SCORE", "externalCode": "SCORE" },
                { "type": "date", "name": "DATA", "externalCode": "DATA" },
                { "type": "datetime", "name": "TIME", "externalCode": "TIME" }
            ]
        }
    },
    (result) => {
        if (result.error()) {
            console.error(result.error());
            return;
        }

        const data = result.data();

        // Методы раздела кладут ошибку внутрь result и отвечают со статусом 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.add',
    [
        'fields' => [
            'sourceId' => 3,
            'name' => 'sales_orders',
            'externalName' => 'Sales orders',
            'externalCode' => 'sales_orders',
            'description' => 'Описание таблицы',
            'fields' => [
                [ 'type' => 'int', 'name' => 'ID', 'externalCode' => 'ID' ],
                [ 'type' => 'string', 'name' => 'NAME', 'externalCode' => 'NAME' ],
                [ 'type' => 'string', 'name' => 'SURNAME', 'externalCode' => 'SURNAME' ],
                [ 'type' => 'double', 'name' => 'SCORE', 'externalCode' => 'SCORE' ],
                [ 'type' => 'date', 'name' => 'DATA', 'externalCode' => 'DATA' ],
                [ 'type' => 'datetime', 'name' => 'TIME', 'externalCode' => 'TIME' ]
            ]
        ]
    ]
);

// Методы раздела кладут ошибку внутрь result и отвечают со статусом 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 и ctx уже созданы — см. раздел «SDK для Go»
res, err := client.Core().Call(ctx, "biconnector.table.add", b24.Params{
	"fields": b24.Params{
		"sourceId":     3,
		"name":         "sales_orders",
		"externalName": "Sales orders",
		"externalCode": "sales_orders",
		"description":  "Описание таблицы",
		"fields": []b24.Params{
			{
				"type":         "int",
				"name":         "ID",
				"externalCode": "ID",
			},
			{
				"type":         "string",
				"name":         "NAME",
				"externalCode": "NAME",
			},
			{
				"type":         "string",
				"name":         "SURNAME",
				"externalCode": "SURNAME",
			},
			{
				"type":         "double",
				"name":         "SCORE",
				"externalCode": "SCORE",
			},
			{
				"type":         "date",
				"name":         "DATA",
				"externalCode": "DATA",
			},
			{
				"type":         "datetime",
				"name":         "TIME",
				"externalCode": "TIME",
			},
		},
	},
})
if err != nil {
	return fmt.Errorf("biconnector.table.add: %w", err)
}

// Методы раздела кладут ошибку внутрь result и отвечают со статусом 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.add: %s: %s", apiErr.Error.Error, apiErr.Error.Description)
}

var item struct {
	ID b24.ID `json:"id"`
}
if err := json.Unmarshal(res.Result, &item); err != nil {
	return fmt.Errorf("разбор ответа: %w", err)
}
fmt.Println(item.ID)