How to Filter Items by Stage Name

require_once 'vendor/autoload.php';
        
        use Bitrix24\SDK\Services\ServiceBuilderFactory;
        use Symfony\Component\EventDispatcher\EventDispatcher;
        use Monolog\Logger;
        use Monolog\Handler\StreamHandler;
        
        $logger = new Logger('b24');
        $logger->pushHandler(new StreamHandler('php://stdout'));
        
        $serviceBuilder = (new ServiceBuilderFactory(new EventDispatcher(), $logger))
            ->initFromWebhook('https://your-domain.bitrix24.com/rest/USER_ID/TOKEN/');
        
        $result = $serviceBuilder->core->call(
            'crm.category.list',
            [
                'entityTypeId' => 2
            ]
        );
        

from b24pysdk import BitrixWebhook, Client
        from b24pysdk.errors import BitrixAPIError
        
        client = Client(
            BitrixWebhook(
                domain="your-domain.bitrix24.com",
                webhook_token="user_id/webhook_key",
            )
        )
        
        result = client.crm.category.list(
            entity_type_id=2,
        ).response.result
        

$result = $serviceBuilder->getCRMScope()->status()->list(
            [],
            [
                'ENTITY_ID' => 'DEAL_STAGE_10'
            ]
        );
        

result = client.crm.status.list(
            filter={
                "ENTITY_ID": "DEAL_STAGE_10",
            }
        ).response.result
        

$result = $serviceBuilder->getCRMScope()->item()->list(
            2,
            [],
            [
                "stageId" => ["C10:PREPAYMENT_INVOICE"],
            ],
            [
                "id",
                "title",
                "assignedById",
                "opportunity",
            ]
        );
        

result = client.crm.item.list(
            entity_type_id=2,
            select=["id", "title", "assignedById", "opportunity"],
            filter={
                "stageId": ["C10:PREPAYMENT_INVOICE"],
            },
        ).response.result
        

$result = $serviceBuilder->getUserScope()->user()->get(
            [],
            ['ID' => 29]
        );
        

result = client.user.get(
            filter={"ID": 29},
        ).response.result
        

require_once 'vendor/autoload.php';
        
        use Bitrix24\SDK\Services\ServiceBuilderFactory;
        use Symfony\Component\EventDispatcher\EventDispatcher;
        use Monolog\Logger;
        use Monolog\Handler\StreamHandler;
        
        $logger = new Logger('b24');
        $logger->pushHandler(new StreamHandler('php://stdout'));
        
        $serviceBuilder = (new ServiceBuilderFactory(new EventDispatcher(), $logger))
            ->initFromWebhook('https://your-domain.bitrix24.com/rest/USER_ID/TOKEN/');
        
        $crm = $serviceBuilder->getCRMScope();
        
        // Step 1: Request funnel name from user
        $funnelName = readline("Enter deal funnel name: ");
        
        // Step 2: Get list of funnels
        $categories = $serviceBuilder->core->call(
            'crm.category.list',
            [
                'entityTypeId' => 2
            ]
        )->getResponseData()->getResult()['categories'];
        
        $selectedFunnel = null;
        
        foreach ($categories as $category) {
            if ($category['name'] === $funnelName) {
                $selectedFunnel = $category;
                break;
            }
        }
        
        if (!$selectedFunnel) {
            echo "Funnel not found.\n";
            exit;
        }
        
        $funnelId = $selectedFunnel['id'];
        
        // Step 3: Request stage name from user
        $stageName = readline("Enter stage name: ");
        
        // Step 4: Get list of stages for the selected funnel
        $entityID = $funnelId === 0 ? "DEAL_STAGE" : "DEAL_STAGE_{$funnelId}";
        
        $stages = $crm->status()->list(
            [],
            [
                'ENTITY_ID' => $entityID
            ]
        )->getStatuses();
        
        $selectedStage = null;
        
        foreach ($stages as $stage) {
            if ($stage->NAME === $stageName) {
                $selectedStage = $stage;
                break;
            }
        }
        
        if (!$selectedStage) {
            echo "Stage not found.\n";
            exit;
        }
        
        $stageId = $selectedStage->STATUS_ID;
        
        // Step 5: Get list of deals at the selected stage
        $deals = $crm->item()->list(
            2,
            [],
            [
                "stageId" => $stageId
            ],
            [
                "id",
                "title",
                "assignedById",
                "opportunity"
            ]
        )->getItems();
        
        $uniqueResponsibleIds = [];
        foreach ($deals as $deal) {
            $uniqueResponsibleIds[$deal->assignedById] = $deal->assignedById;
        }
        
        $userMap = [];
        
        // Step 6: Get user information
        foreach ($uniqueResponsibleIds as $userId) {
            $users = $serviceBuilder->getUserScope()->user()->get(
                [],
                ['ID' => $userId]
            )->getUsers();
        
            if (empty($users)) {
                continue;
            }
        
            $user = $users[0];
            $userMap[$userId] = [
                'name' => $user->NAME,
                'lastName' => $user->LAST_NAME
            ];
        }
        
        // Step 7: Output results as a text table
        $table = [];
        
        // Header
        $table[] = [
            "Deal ID",
            "Name",
            "Responsible first name",
            "Responsible last name",
            "Expected revenue"
        ];
        
        // Data rows
        foreach ($deals as $deal) {
            $responsible = $userMap[$deal->assignedById] ?? ['name' => 'Unknown', 'lastName' => 'Unknown'];
            $table[] = [
                $deal->id,
                $deal->title,
                $responsible['name'],
                $responsible['lastName'],
                $deal->opportunity ?? 0
            ];
        }
        
        // Table output
        foreach ($table as $row) {
            echo implode("\t", $row) . "\n";
        }
        

from b24pysdk import BitrixWebhook, Client
        from b24pysdk.errors import BitrixAPIError
        
        client = Client(
            BitrixWebhook(
                domain="your-domain.bitrix24.com",
                webhook_token="user_id/webhook_key",
            )
        )
        
        funnel_name = input("Enter deal funnel name: ")
        
        try:
            categories = client.crm.category.list(entity_type_id=2).response.result.get("categories", [])
            selected_funnel = next(
                (c for c in categories if c.get("name") == funnel_name),
                None,
            )
        
            if not selected_funnel:
                print("Funnel not found.")
            else:
                stage_name = input("Enter stage name: ")
                funnel_id = int(selected_funnel["id"])
                entity_id = "DEAL_STAGE" if funnel_id == 0 else f"DEAL_STAGE_{funnel_id}"
                stages = client.crm.status.list(filter={"ENTITY_ID": entity_id}).response.result
                selected_stage = next(
                    (s for s in stages if s.get("NAME") == stage_name),
                    None,
                )
        
                if not selected_stage:
                    print("Stage not found.")
                else:
                    items = client.crm.item.list(
                        entity_type_id=2,
                        select=["id", "title", "assignedById", "opportunity"],
                        filter={"stageId": selected_stage["STATUS_ID"]},
                    ).response.result.get("items", [])
        
                    user_ids = sorted({int(item["assignedById"]) for item in items if item.get("assignedById")})
                    users = client.user.get(filter={"ID": user_ids}).response.result if user_ids else []
                    user_map = {
                        int(user["ID"]): {
                            "name": user.get("NAME", ""),
                            "lastName": user.get("LAST_NAME", ""),
                        }
                        for user in users
                    }
        
                    table = []
        
                    table.append(
                        [
                            "Deal ID",
                            "Name",
                            "Responsible first name",
                            "Responsible last name",
                            "Expected revenue",
                        ]
                    )
        
                    for deal in items:
                        responsible = user_map.get(int(deal["assignedById"]), {"name": "Unknown", "lastName": "Unknown"})
                        table.append(
                            [
                                str(deal["id"]),
                                str(deal.get("title", "")),
                                str(responsible["name"]),
                                str(responsible["lastName"]),
                                str(deal.get("opportunity", 0)),
                            ]
                        )
        
                    for row in table:
                        print("\t".join(row))
        except BitrixAPIError as error:
            print(f"Error: {error}")