Получить список таблиц biconnector.table.list

// 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 each TableItem returned in result[]
type TableItem = {
  id: number
  name: string
  description: string
}

try {
  // biconnector.table.list returns a single page (max 50 records). The list helpers
  // ($b24.actions.v2.callList.make, fetchList.make) do not work here: this method uses
  // its own `page` navigation and returns neither `total` nor `next`. Walk the pages
  // yourself, increasing `page` until a response comes back with fewer than 50 records.
  const response = await $b24.actions.v2.call.make<TableItem[] | BiconnectorError>({
    method: 'biconnector.table.list',
    params: {
      select: ['id', 'name', 'description'],
      filter: {
        '%=name': 'sales%',
        '!description': '',
        '@sourceId': [2, 4],
      },
      order: {
        dateCreate: 'DESC',
      },
      page: 1,
    },
    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 (!Array.isArray(result)) {
      console.error(result.error.error, result.error.error_description)
    } else {
      console.info('Tables page:', result.length, result)
    }
  }
} 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 listTables() {
    try {
      // Initialize the SDK inside a Bitrix24 frame
      const $b24 = await B24Js.initializeB24Frame()

      // biconnector.table.list returns a single page (max 50 records). The list helpers
      // ($b24.actions.v2.callList.make, fetchList.make) do not work here: this method uses
      // its own `page` navigation and returns neither `total` nor `next`. Walk the pages
      // yourself, increasing `page` until a response comes back with fewer than 50 records.
      const response = await $b24.actions.v2.call.make({
        method: 'biconnector.table.list',
        params: {
          select: ['id', 'name', 'description'],
          filter: {
            '%=name': 'sales%',
            '!description': '',
            '@sourceId': [2, 4],
          },
          order: {
            dateCreate: 'DESC',
          },
          page: 1,
        },
        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('Tables page:', result.length, result)
    } catch (error) {
      // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
      console.error(error)
    }
  }

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

from b24pysdk.errors import BitrixAPIError, BitrixSDKException

try:
    # В b24pysdk нет готовой обертки для biconnector.table.*, поэтому метод
    # вызывается напрямую через bitrix_token.call_method()
    response = bitrix_token.call_method(
        api_method="biconnector.table.list",
        params={
            "select": ["id", "name", "description"],
            "filter": {
                "%=name": "sales%",
                "!description": "",
                "@sourceId": [2, 4],
            },
            "order": {
                "dateCreate": "DESC",
            },
            "page": 1,
        },
    )
    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.list',
            [
                'select' => ["id", "name", "description"],
                'filter' => [
                    '%=name'      => "sales%",
                    '!description' => "",
                    "@sourceId"   => [2, 4]
                ],
                'order'  => [
                    'dateCreate' => "DESC"
                ],
                'page'   => 1
            ]
        );

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

    if ($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 'Data: ' . print_r($data, true);
        }
    }

} catch (Throwable $e) {
    error_log($e->getMessage());
    echo 'Error calling biconnector.table.list: ' . $e->getMessage();
}

BX24.callMethod(
    'biconnector.table.list',
    {
        select: ["id", "name", "description"],
        filter: {
            '%=name': "sales%",
            '!description': "",
            "@sourceId": [2, 4]
        },
        order: {
            dateCreate: "DESC"
        },
        page: 1
    },
    (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.list',
    [
        'select' => ["id", "name", "description"],
        'filter' => ['%=name' => "sales%", '!description' => "", '@sourceId' => [2, 4]],
        'order' => ['dateCreate' => "DESC"],
        'page' => 1
    ]
);

// Методы раздела кладут ошибку внутрь 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.list", b24.Params{
	"select": []string{"id", "name", "description"},
	"filter": b24.Params{
		"%=name":       "sales%",
		"!description": "",
		"@sourceId":    []int{2, 4},
	},
	"order": b24.Params{
		"dateCreate": "DESC",
	},
	"page": 1,
}, b24.WithIdempotent())
if err != nil {
	return fmt.Errorf("biconnector.table.list: %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.list: %s: %s", apiErr.Error.Error, apiErr.Error.Description)
}

var items []struct {
	ID          b24.ID `json:"id"`
	Name        string `json:"name"`
	Description string `json:"description"`
}
if err := json.Unmarshal(res.Result, &items); err != nil {
	return fmt.Errorf("разбор ответа: %w", err)
}
for _, it := range items {
	fmt.Println(it.ID, it.Name)
}

// Total и Next этот метод не возвращает: постраничный обход
// строится по параметру page, пока в ответе приходит 50 записей.