Получить список сделок crm.deal.list

curl -X POST \
        -H "Content-Type: application/json" \
        -H "Accept: application/json" \
        -d '{"SELECT":["ID","TITLE","TYPE_ID","CATEGORY_ID","STAGE_ID","OPPORTUNITY","IS_MANUAL_OPPORTUNITY","ASSIGNED_BY_ID","DATE_CREATE"],"FILTER":{"=%TITLE":"%а","CATEGORY_ID":1,"TYPE_ID":"COMPLEX","STAGE_ID":"C1:NEW",">OPPORTUNITY":10000,"<=OPPORTUNITY":20000,"IS_MANUAL_OPPORTUNITY":"Y","@ASSIGNED_BY_ID":[1,6],">DATE_CREATE":"'"$(date --date='-6 months' +%Y-%m-%d)"'"},"ORDER":{"TITLE":"ASC","OPPORTUNITY":"ASC"},"auth":"**put_access_token_here**"}' \
        https://**put_your_bitrix24_address**/rest/crm.deal.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, ISODate } from '@bitrix24/b24jssdk'
        
        declare const $b24: B24Frame
        
        // Shape of each deal returned in result[] (subset shaped by `select`)
        type CrmDealListItem = {
          ID: string
          TITLE: string
          TYPE_ID: string
          CATEGORY_ID: string
          STAGE_ID: string
          OPPORTUNITY: string
          IS_MANUAL_OPPORTUNITY: string
          ASSIGNED_BY_ID: string
          DATE_CREATE: ISODate | null
        }
        
        const now = new Date()
        const sixMonthAgo = new Date()
        sixMonthAgo.setMonth(now.getMonth() - 6)
        
        try {
          // crm.deal.list returns a single page (max 50 records). For the whole result set
          // use a list helper: $b24.actions.v2.callList.make() returns every record as one
          // array, $b24.actions.v2.fetchList.make() yields them in chunks (async generator).
          // NOTE: the list helpers do not accept `order` (it is excluded from their params, so
          // passing it is a TS error) — keep this call.make + `start` variant when sort matters.
          const response = await $b24.actions.v2.call.make<CrmDealListItem[]>({
            method: 'crm.deal.list',
            params: {
              select: [
                'ID',
                'TITLE',
                'TYPE_ID',
                'CATEGORY_ID',
                'STAGE_ID',
                'OPPORTUNITY',
                'IS_MANUAL_OPPORTUNITY',
                'ASSIGNED_BY_ID',
                'DATE_CREATE',
              ],
              filter: {
                '=%TITLE': '%а',
                CATEGORY_ID: 1,
                TYPE_ID: 'COMPLEX',
                STAGE_ID: 'C1:NEW',
                '>OPPORTUNITY': 10000,
                '<=OPPORTUNITY': 20000,
                IS_MANUAL_OPPORTUNITY: 'Y',
                '@ASSIGNED_BY_ID': [1, 6],
                '>DATE_CREATE': sixMonthAgo,
              },
              order: {
                TITLE: 'ASC',
                OPPORTUNITY: 'ASC',
              },
              start: 0,
            },
            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
            console.info('Deals on this 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 listDeals() {
            try {
              // Initialize the SDK inside a Bitrix24 frame
              const $b24 = await B24Js.initializeB24Frame()
        
              const now = new Date()
              const sixMonthAgo = new Date()
              sixMonthAgo.setMonth(now.getMonth() - 6)
        
              // crm.deal.list returns a single page (max 50 records). For the whole result set
              // use a list helper: $b24.actions.v2.callList.make() returns every record as one
              // array, $b24.actions.v2.fetchList.make() yields them in chunks (async generator).
              // NOTE: the list helpers do not accept `order` (it is excluded from their params, so
              // passing it is a TS error) — keep this call.make + `start` variant when sort matters.
              const response = await $b24.actions.v2.call.make({
                method: 'crm.deal.list',
                params: {
                  select: [
                    'ID',
                    'TITLE',
                    'TYPE_ID',
                    'CATEGORY_ID',
                    'STAGE_ID',
                    'OPPORTUNITY',
                    'IS_MANUAL_OPPORTUNITY',
                    'ASSIGNED_BY_ID',
                    'DATE_CREATE',
                  ],
                  filter: {
                    '=%TITLE': '%а',
                    CATEGORY_ID: 1,
                    TYPE_ID: 'COMPLEX',
                    STAGE_ID: 'C1:NEW',
                    '>OPPORTUNITY': 10000,
                    '<=OPPORTUNITY': 20000,
                    IS_MANUAL_OPPORTUNITY: 'Y',
                    '@ASSIGNED_BY_ID': [1, 6],
                    '>DATE_CREATE': sixMonthAgo,
                  },
                  order: {
                    TITLE: 'ASC',
                    OPPORTUNITY: 'ASC',
                  },
                  start: 0,
                },
                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
              console.info('Deals on this page:', result.length, result)
            } catch (error) {
              // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
              console.error(error)
            }
          }
        
          document.addEventListener('DOMContentLoaded', listDeals)
        </script>
        

try {
            $response = $b24Service
                ->core
                ->call(
                    'crm.deal.list',
                    [
                        'select' => [
                            'ID',
                            'TITLE',
                            'TYPE_ID',
                            'CATEGORY_ID',
                            'STAGE_ID',
                            'OPPORTUNITY',
                            'IS_MANUAL_OPPORTUNITY',
                            'ASSIGNED_BY_ID',
                            'DATE_CREATE',
                        ],
                        'filter' => [
                            '=%TITLE'              => '%а',
                            'CATEGORY_ID'          => 1,
                            'TYPE_ID'              => 'COMPLEX',
                            'STAGE_ID'             => 'C1:NEW',
                            '>OPPORTUNITY'         => 10000,
                            '<=OPPORTUNITY'        => 20000,
                            'IS_MANUAL_OPPORTUNITY' => 'Y',
                            '@ASSIGNED_BY_ID'      => [1, 6],
                            '>DATE_CREATE'         => $sixMonthAgo,
                        ],
                        'order' => [
                            'TITLE'       => 'ASC',
                            'OPPORTUNITY' => 'ASC',
                        ],
                    ]
                );
        
            $result = $response
                ->getResponseData()
                ->getResult();
        
            if ($result->error()) {
                echo 'Error: ' . $result->error();
            } else {
                echo 'Data: ' . print_r($result->data(), true);
            }
        
        } catch (Throwable $e) {
            error_log($e->getMessage());
            echo 'Error fetching deal list: ' . $e->getMessage();
        }
        

const now = new Date();
        const sixMonthAgo = new Date();
        sixMonthAgo.setMonth(now.getMonth() - 6);
        
        BX24.callMethod(
            'crm.deal.list',
            {
                select: [
                    'ID',
                    'TITLE',
                    'TYPE_ID',
                    'CATEGORY_ID',
                    'STAGE_ID',
                    'OPPORTUNITY',
                    'IS_MANUAL_OPPORTUNITY',
                    'ASSIGNED_BY_ID',
                    'DATE_CREATE',
                ],
                filter: {
                    '=%TITLE': '%а',
                    CATEGORY_ID: 1,
                    TYPE_ID: 'COMPLEX',
                    STAGE_ID: 'C1:NEW',
                    '>OPPORTUNITY': 10000,
                    '<=OPPORTUNITY': 20000,
                    IS_MANUAL_OPPORTUNITY: 'Y',
                    '@ASSIGNED_BY_ID': [1, 6],
                    '>DATE_CREATE': sixMonthAgo,
                },
                order: {
                    TITLE: 'ASC',
                    OPPORTUNITY: 'ASC',
                },
            },
            (result) => {
                result.error()
                    ? console.error(result.error())
                    : console.info(result.data())
                ;
            },
        );
        

require_once('crest.php');
        
        $sixMonthAgo = (new DateTime())->modify('-6 months')->format('Y-m-d');
        
        $result = CRest::call(
            'crm.deal.list',
            [
                'SELECT' => [
                    'ID',
                    'TITLE',
                    'TYPE_ID',
                    'CATEGORY_ID',
                    'STAGE_ID',
                    'OPPORTUNITY',
                    'IS_MANUAL_OPPORTUNITY',
                    'ASSIGNED_BY_ID',
                    'DATE_CREATE',
                ],
                'FILTER' => [
                    '=%TITLE' => '%а',
                    'CATEGORY_ID' => 1,
                    'TYPE_ID' => 'COMPLEX',
                    'STAGE_ID' => 'C1:NEW',
                    '>OPPORTUNITY' => 10000,
                    '<=OPPORTUNITY' => 20000,
                    'IS_MANUAL_OPPORTUNITY' => 'Y',
                    '@ASSIGNED_BY_ID' => [1, 6],
                    '>DATE_CREATE' => $sixMonthAgo,
                ],
                'ORDER' => [
                    'TITLE' => 'ASC',
                    'OPPORTUNITY' => 'ASC',
                ],
            ]
        );
        
        echo '<PRE>';
        print_r($result);
        echo '</PRE>';
        

from b24pysdk.client import BaseClient
        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        client: BaseClient
        
        try:
            bitrix_response = client.crm.deal.list(
                select=["ID", "TITLE", "STAGE_ID", "OPPORTUNITY", "ASSIGNED_BY_ID", "DATE_CREATE"],
                filter={">OPPORTUNITY": 1000, "!STAGE_ID": "WON", "=OPENED": "Y"},
                order={"DATE_CREATE": "DESC", "ID": "DESC"},
                start=0,
            ).response
            result = bitrix_response.result
            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}")
        

from b24pysdk.client import BaseClient
        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        client: BaseClient
        
        try:
            bitrix_response = client.crm.deal.list(
                select=["ID", "TITLE", "STAGE_ID"],
                filter={"!STAGE_ID": "LOSE"},
                order={"ID": "ASC"},
            ).as_list().response
            result = bitrix_response.result
            for item in result:
                print(item)
        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}")
        

from b24pysdk.client import BaseClient
        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        client: BaseClient
        
        try:
            bitrix_response = client.crm.deal.list(
                select=["ID", "TITLE", "STAGE_ID"],
                filter={"!STAGE_ID": "LOSE"},
                order={"ID": "DESC"},
            ).as_list_fast(descending=True).response
            result = bitrix_response.result
            for item in result:
                print(item)
        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}")