Get Product Rows of the CRM Object crm.item.productrow.list

curl -X POST \
        -H "Content-Type: application/json" \
        -H "Accept: application/json" \
        -d '{"filter":{"=ownerType":"D","=ownerId":13142,">price":5000},"order":{"price":"desc"},"auth":"**put_access_token_here**"}' \
        https://**put_your_bitrix24_address**/rest/crm.item.productrow.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
        
        // Shape of the payload returned in result (match the "response handling" section of the page)
        type ProductRowListResult = {
          productRows: {
            id: number
            ownerId: number
            ownerType: string
            productId: number
            productName: string
            price: number
            priceAccount: number
            priceExclusive: number
            priceNetto: number
            priceBrutto: number
            quantity: number
            discountTypeId: number
            discountRate: number
            discountSum: number
            taxRate: number | null
            taxIncluded: string
            customized: string
            measureCode: number
            measureName: string
            sort: number
            xmlId: string
            type: number
            storeId: number
          }[]
        }
        
        try {
          // crm.item.productrow.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<ProductRowListResult>({
            method: 'crm.item.productrow.list',
            params: {
              filter: {
                '=ownerType': 'D',
                '=ownerId': 13142,
                '>price': 5000,
              },
              order: {
                price: 'desc',
              },
              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(result.productRows.length, result.productRows)
          }
        } 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 listProductRows() {
            try {
              // Initialize the SDK inside a Bitrix24 frame
              const $b24 = await B24Js.initializeB24Frame()
        
              // crm.item.productrow.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.item.productrow.list',
                params: {
                  filter: {
                    '=ownerType': 'D',
                    '=ownerId': 13142,
                    '>price': 5000,
                  },
                  order: {
                    price: 'desc',
                  },
                  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(result.productRows.length, result.productRows)
            } catch (error) {
              // Thrown on transport or SDK failures (AjaxError, SdkError, etc.)
              console.error(error)
            }
          }
        
          document.addEventListener('DOMContentLoaded', listProductRows)
        </script>
        

        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        try:
            bitrix_response = client.crm.item.productrow.list(
                filter={
                    "=ownerType": "D",
                    "=ownerId": 13142,
                    ">price": 5000,
                },
                order={
                    "price": "desc",
                },
            ).response
            result = bitrix_response.result
            print(result)
        except BitrixAPIError as error:
            print(
                "Bitrix API Error",
                f"error: {error.error}",
                f"error_description: {error.error_description}",
                sep="\n",
            )
        except BitrixSDKException as error:
            print(f"Bitrix SDK Error: {error.message}")
        except Exception as error:
            print(f"Unexpected error: {error}")
        

        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        try:
            bitrix_response = client.crm.item.productrow.list(
                filter={
                    "=ownerType": "D",
                    "=ownerId": 13142,
                    ">price": 5000,
                },
                order={
                    "price": "desc",
                },
            ).as_list().response
            result = bitrix_response.result
            for item in result:
                print(item)
        except BitrixAPIError as error:
            print(
                "Bitrix API Error",
                f"error: {error.error}",
                f"error_description: {error.error_description}",
                sep="\n",
            )
        except BitrixSDKException as error:
            print(f"Bitrix SDK Error: {error.message}")
        except Exception as error:
            print(f"Unexpected error: {error}")
        

        from b24pysdk.errors import BitrixAPIError, BitrixSDKException
        
        try:
            bitrix_response = client.crm.item.productrow.list(
                filter={
                    "=ownerType": "D",
                    "=ownerId": 13142,
                    ">price": 5000,
                },
                order={
                    "price": "desc",
                },
            ).as_list_fast(descending=True).response
            result = bitrix_response.result
            for item in result:
                print(item)
        except BitrixAPIError as error:
            print(
                "Bitrix API Error",
                f"error: {error.error}",
                f"error_description: {error.error_description}",
                sep="\n",
            )
        except BitrixSDKException as error:
            print(f"Bitrix SDK Error: {error.message}")
        except Exception as error:
            print(f"Unexpected error: {error}")
        

try {
            $response = $b24Service
                ->core
                ->call(
                    'crm.item.productrow.list',
                    [
                        'filter' => [
                            "=ownerType" => 'D',
                            "=ownerId"   => 13142,
                            ">price"     => 5000,
                        ],
                        'order'  => [
                            'price' => "desc"
                        ],
                    ]
                );
        
            $result = $response
                ->getResponseData()
                ->getResult();
        
            echo 'Success: ' . print_r($result, true);
        
        } catch (Throwable $e) {
            error_log($e->getMessage());
            echo 'Error listing product rows: ' . $e->getMessage();
        }
        

BX24.callMethod(
            'crm.item.productrow.list', {
                filter: {
                    "=ownerType": 'D',
                    "=ownerId": 13142,
                    ">price": 5000,
                },
                order: {
                    price: "desc"
                },
            },
            function(result) {
                if (result.error()) {
                    console.error(result.error());
                } else {
                    console.log(result.data());
                }
            }
        );
        

require_once('crest.php');
        
        $result = CRest::call(
            'crm.item.productrow.list',
            [
                'filter' => [
                    "=ownerType" => 'D',
                    "=ownerId" => 13142,
                    ">price" => 5000,
                ],
                'order' => [
                    'price' => "desc"
                ]
            ]
        );
        
        echo '<PRE>';
        print_r($result);
        echo '</PRE>';
        

// client and ctx are already created — see the Go SDK section
        res, err := client.Core().Call(ctx, "crm.item.productrow.list", b24.Params{
        	"filter": b24.Params{
        		"=ownerType": "D",
        		"=ownerId":   13142,
        		">price":     5000,
        	},
        	"order": b24.Params{
        		"price": "desc",
        	},
        }, b24.WithIdempotent())
        if err != nil {
        	return fmt.Errorf("crm.item.productrow.list: %w", err)
        }
        
        // The method wraps the response in an object with the "productRows" key.
        raw, ok := b24.Unwrap(res.Result, "productRows")
        if !ok {
        	return fmt.Errorf("no productRows key in the response")
        }
        
        var items []struct {
        	ID          b24.ID `json:"id"`
        	OwnerID     b24.ID `json:"ownerId"`
        	OwnerType   string `json:"ownerType"`
        	ProductID   b24.ID `json:"productId"`
        	ProductName string `json:"productName"`
        	Price       int    `json:"price"`
        }
        if err := json.Unmarshal(raw, &items); err != nil {
        	return fmt.Errorf("parse response: %w", err)
        }
        for _, it := range items {
        	fmt.Println(it.ID)
        }