Получить список сделок 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
        

// callListMethod: Получает все данные сразу. Используйте только для небольших выборок (< 1000 элементов) из-за высокой нагрузки на память.
        
        const now = new Date();
        const sixMonthAgo = new Date();
        sixMonthAgo.setMonth(now.getMonth() - 6);
        
        try {
          const response = await $b24.callListMethod(
            '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())
              ;
            },
          );
        } catch (error) {
          console.error('Request failed', error);
        }
        
        // fetchListMethod: Выбирает данные по частям с помощью итератора. Используйте для больших объемов данных для эффективного потребления памяти.
        
        const now = new Date();
        const sixMonthAgo = new Date();
        sixMonthAgo.setMonth(now.getMonth() - 6);
        
        try {
          const generator = $b24.fetchListMethod('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',
            },
          }, 'ID');
          for await (const page of generator) {
            for (const entity of page) {
              console.log('Entity:', entity);
            }
          }
        } catch (error) {
          console.error('Request failed', error);
        }
        
        // callMethod: Ручное управление постраничной навигацией через параметр start. Используйте для точного контроля над пакетами запросов. Для больших данных менее эффективен, чем fetchListMethod.
        
        const now = new Date();
        const sixMonthAgo = new Date();
        sixMonthAgo.setMonth(now.getMonth() - 6);
        
        try {
          const response = await $b24.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',
            },
          }, 0);
          const result = response.getData().result || [];
          for (const entity of result) {
            console.log('Entity:', entity);
          }
        } catch (error) {
          console.error('Request failed', error);
        }
        

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>';