List Live Price Grid Items

post/pricegridmanager.fetch/{id}

Retrieves Live Price Grid Items.

A filter can be applied.

Filter example:

Returns the item where id = 644.

Please note:

Filtering by typedId is not accepted by this enpoint.

{
   "endRow":300,
   "oldValues":null,
   "operationType":"fetch",
   "startRow":0,
   "textMatchStyle":"exact",
   "data":{
      "_constructor":"AdvancedCriteria",
      "operator":"and",
      "criteria":[
         {
            "fieldName":"id",
            "operator":"equals",
            "value":644
         }
      ]
   }
}

Required Permission Roles with the Required Permission
PRICEGRID_FETCH Edit LPG & Add Products (PB_PRICEGRIDEDITOR_ADD_SKU), Edit LPG (PB_PRICEGRIDEDITOR), Administer LPG (PB_PRICEGRIDS), Investigate for Support (SUPPORT), Administer Plasma (PLASMA), Manage Workflow Logics (WF_BUILDER)
Securitybasic or X-PriceFx-jwt
Request
path Parameters
id
required
string

The id of the Live Price Grid you want to retrieve items for. You can retrieve the id of the LPG, for example, by calling the /fetch/PG endpoint.

Request Body schema: application/json
endRow
number
Default: 300

The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.

oldValues
any
operationType
string non-empty

Enter fetch, null, or omit the param.

startRow
number

The number of the first row that defines the start of the result set's returned objects. Use this parameter if you want to implement paging for results.

textMatchStyle
string non-empty
object
_constructor
string non-empty
operator
string non-empty
Array of objects non-empty unique
Array (non-empty)
fieldName
string non-empty
operator
string non-empty

Specify an operator of the filter criteria.

Possible values: "equals" "iEquals" "notEqual" "iNotEqual" "isNull" "notNull" "contains" "iContains" "containsPattern" "iContainsPattern" "notContains" "iNotContains" "startsWith" "iStartsWith" "notStartsWith" "iNotStartsWith" "endsWith" "iEndsWith" "notEndsWith" "iNotEndsWith" … 4 more
value
string
Responses
200

OK

Response Schema: application/json
object
node
string non-empty
csrfToken
string non-empty
startRow
number
Array of objects non-empty unique
Array (non-empty)
version
number
typedId
string non-empty
sku
string non-empty
priceGridId
number
manualEditVersion
number
manualPriceExpired
boolean
createDate
string non-empty
createdBy
number
lastUpdateDate
string non-empty
lastUpdateBy
number
itemExtensions
object
completeResultsAvailable
boolean
endRow
number
Default: 300

The number of the end row that defines the end of the result set's returned objects. Use this parameter if you want to implement paging for results.

totalRows
number
status
number
Request samples
application/json
{
  • "endRow": 300,
  • "oldValues": null,
  • "operationType": "fetch",
  • "startRow": 0,
  • "textMatchStyle": "exact",
  • "data": {
    • "_constructor": "AdvancedCriteria",
    • "operator": "and",
    • "criteria": [
      • {
        • "fieldName": "currency",
        • "operator": "equals",
        • "value": "USD"
        }
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "csrfToken": "string",
    • "startRow": 0,
    • "data": [
      • {
        • "version": 0,
        • "typedId": "string",
        • "sku": "string",
        • "priceGridId": 0,
        • "manualEditVersion": 0,
        • "manualPriceExpired": true,
        • "createDate": "string",
        • "createdBy": 0,
        • "lastUpdateDate": "string",
        • "lastUpdateBy": 0,
        • "itemExtensions": { },
        • "completeResultsAvailable": true
        }
      ],
    • "endRow": 300,
    • "totalRows": 0,
    • "status": 0
    }
}