Get product rows of the CRM object crm.item.productrow.list

Scope: crm

Who can execute the method: requires read access permission for the CRM object whose product rows are being selected.

The method retrieves product rows of the CRM object.

Method Parameters

Required parameters are marked with *

Name `type`	Description
filter* `object`	Object for filtering selected records in the format `{"field_1": "value_1", ... "field_N": "value_N"}`. Possible values for `field` correspond to the fields of the `crm_item_product_row` object. The following keys must be present: =ownerType =ownerId In `=ownerType`, pass the Short symbolic code of the type. The key may have an additional prefix that specifies the behavior of the filter. Possible prefix values: `=` — equals (works with arrays as well) `%` — LIKE, substring search. The % symbol in the filter value does not need to be passed. The search looks for the substring in any position of the string. `>` — greater than `<` — less than `!=` — not equal `!%` — NOT LIKE, substring search. The % symbol in the filter value does not need to be passed. The search goes from both sides. `>=` — greater than or equal to `<=` — less than or equal to `=%` — LIKE, substring search. The % symbol needs to be passed in the value. Examples: `"mol%"` — searching for values starting with "mol" `"%mol"` — searching for values ending with "mol" `"%mol%"` — searching for values where "mol" can be in any position `%=` — LIKE (see description above) `!=%` — NOT LIKE, substring search. The % symbol needs to be passed in the value. Examples: `"mol%"` — searching for values not starting with "mol" `"%mol"` — searching for values not ending with "mol" `"%mol%"` — searching for values where the substring "mol" is not present in any position `!%=` — NOT LIKE (see description above)
order `object`	Object for sorting selected elements of the shipment table in the format `{"field_1": "order_1", ... "field_N": "order_N"}`. Possible values for `field` correspond to the fields of the `crm_item_product_row` object. Possible values for `order`: `asc` — in ascending order `desc` — in descending order
start `integer`	Parameter used for managing pagination. The page size of results is always static: 50 records. To select the second page of results, you need to pass the value `50`. To select the third page of results, the value is `100`, and so on. The formula for calculating the value of the `start` parameter: `start = (N-1) * 50`, where `N` — the number of the desired page

Code Examples

How to Use Examples in Documentation

cURL (Webhook)

cURL (OAuth)

PHP

BX24.js

PHP CRest

curl -X POST \
        -H "Content-Type: application/json" \
        -H "Accept: application/json" \
        -d '{"filter":{"=ownerType":"D","=ownerId":13142,">price":5000},"order":{"price":"desc"}}' \
        https://**put_your_bitrix24_address**/rest/**put_your_user_id_here**/**put_your_webhook_here**/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

// callListMethod: Retrieves all data at once. Use only for small selections (< 1000 items) due to high memory usage.
        
        try {
          const response = await $b24.callListMethod(
            'crm.item.productrow.list',
            {
              filter: {
                "=ownerType": 'D',
                "=ownerId": 13142,
                ">price": 5000,
              },
              order: {
                price: "desc"
              },
            },
            (progress) => { console.log('Progress:', progress) }
          )
          const items = response.getData() || []
          for (const entity of items) { console.log('Entity:', entity) }
        } catch (error) {
          console.error('Request failed', error)
        }
        
        // fetchListMethod: Retrieves data in parts using an iterator. Use it for large data volumes to optimize memory usage.
        
        try {
          const generator = $b24.fetchListMethod('crm.item.productrow.list', {
            filter: {
              "=ownerType": 'D',
              "=ownerId": 13142,
              ">price": 5000,
            },
            order: {
              price: "desc"
            },
          }, 'ID')
          for await (const page of generator) {
            for (const entity of page) { console.log('Entity:', entity) }
          }
        } catch (error) {
          console.error('Request failed', error)
        }
        
        // callMethod: Manually controls pagination through the start parameter. Use it for precise control of request batches. For large datasets, it is less efficient than fetchListMethod.
        
        try {
          const response = await $b24.callMethod('crm.item.productrow.list', {
            filter: {
              "=ownerType": 'D',
              "=ownerId": 13142,
              ">price": 5000,
            },
            order: {
              price: "desc"
            },
          }, 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.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>';

Successful Response

HTTP status: 200

{
           "result": {
              "productRows": [
                 {
                    "id": 17649,
                    "ownerId": 13142,
                    "ownerType": "D",
                    "productId": 9621,
                    "productName": "iphone 14",
                    "price": 90000,
                    "priceAccount": 90000,
                    "priceExclusive": 81818.18,
                    "priceNetto": 90909.09,
                    "priceBrutto": 100000,
                    "quantity": 3,
                    "discountTypeId": 2,
                    "discountRate": 10,
                    "discountSum": 9090.91,
                    "taxRate": 10,
                    "taxIncluded": "Y",
                    "customized": "Y",
                    "measureCode": 796,
                    "measureName": "pcs",
                    "sort": 20,
                    "xmlId": "sale_basket_8147",
                    "type": 4,
                    "storeId": 19
                 },
                 {
                    "id": 17650,
                    "ownerId": 13142,
                    "ownerType": "D",
                    "productId": 9623,
                    "productName": "iphone 10xs",
                    "price": 5550,
                    "priceAccount": 5550,
                    "priceExclusive": 5550,
                    "priceNetto": 5550,
                    "priceBrutto": 5550,
                    "quantity": 1,
                    "discountTypeId": 2,
                    "discountRate": 0,
                    "discountSum": 0,
                    "taxRate": null,
                    "taxIncluded": "Y",
                    "customized": "Y",
                    "measureCode": 6,
                    "measureName": "m",
                    "sort": 10,
                    "xmlId": "sale_basket_8148",
                    "type": 4,
                    "storeId": 17
                 }
              ]
           },
           "total": 2,
           "time": {
              "start": 1716905609.186602,
              "finish": 1716905609.434087,
              "duration": 0.24748492240905762,
              "processing": 0.06894516944885254,
              "date_start": "2024-05-28T17:13:29+02:00",
              "date_finish": "2024-05-28T17:13:29+02:00"
           }
        }

Returned Data

Name `type`	Description
result `object`	Root element of the response
productRows `crm_item_product_row[]`	Array of objects containing information about the selected product rows of the CRM object
total `integer`	Total number of records found
time `time`	Information about the execution time of the request

Error Handling

HTTP status: 400

{
           "error": "ACCESS_DENIED",
           "error_description": "Access denied"
        }

Name `type`	Description
error `string`	String error code. It may consist of digits, Latin letters, and underscores
error_description `error_description`	Textual description of the error. The description is not intended to be shown to the end user in its raw form

Possible Error Codes

Code	Description
`ACCESS_DENIED`	Access denied
`INVALID_ARG_VALUE`	Invalid values for input parameters
`100`	Required parameters not provided
`0`	Other errors (e.g., fatal errors)

HTTP Status: 20x, 40x, 50x

The errors described below may occur when calling any method.

Status	Code Error Message	Description
`500`	`INTERNAL_SERVER_ERROR` Internal server error	An internal server error has occurred, please contact the server administrator or Bitrix24 technical support
`500`	`ERROR_UNEXPECTED_ANSWER` Server returned an unexpected response	An internal server error has occurred, please contact the server administrator or Bitrix24 technical support
`503`	`QUERY_LIMIT_EXCEEDED` Too many requests	The request intensity limit has been exceeded
`405`	`ERROR_BATCH_METHOD_NOT_ALLOWED` Method is not allowed for batch usage	The current method is not allowed to be called using batch
`400`	`ERROR_BATCH_LENGTH_EXCEEDED` Max batch length exceeded	The maximum length of parameters passed to the batch method has been exceeded
`401`	`NO_AUTH_FOUND` Wrong authorization data	Invalid access token or webhook code
`400`	`INVALID_REQUEST` Https required	The methods must be called using the HTTPS protocol
`503`	`OVERLOAD_LIMIT` REST API is blocked due to overload	The REST API is blocked due to overload. This is a manual individual block, to remove it you need to contact Bitrix24 technical support
`403`	`ACCESS_DENIED` REST API is available only on commercial plans	The REST API is available only on commercial plans
`403`	`INVALID_CREDENTIALS` Invalid request credentials	The user whose access token or webhook was used to call the method lacks permissions
`404`	`ERROR_MANIFEST_IS_NOT_AVAILABLE` Manifest is not available	The manifest is not available
`403`	`insufficient_scope` The request requires higher privileges than provided by the webhook token	The request requires higher privileges than those provided by the webhook token
`401`	`expired_token` The access token provided has expired	The provided access token has expired
`403`	`user_access_error` The user does not have access to the application	The user does not have access to the application. This means that the application is installed, but the account administrator has allowed access to this application only for specific users
`500`	`PORTAL_DELETED` Portal was deleted	The public part of the site is closed. To open the public part of the site on an on-premise installation, disable the option "Temporary closure of the public part of the site". Path to the setting: Desktop > Settings > Product Settings > Module Settings > Main Module > Temporary closure of the public part of the site

Continue Learning

Link Product Item to CRM Object

Get List of Unpaid Products

Get product rows of the CRM object crm.item.productrow.list

Method ParametersMethod Parameters

Code ExamplesCode Examples

Successful ResponseSuccessful Response

Returned DataReturned Data

Error HandlingError Handling

Possible Error CodesPossible Error Codes

Continue LearningContinue Learning