# List Live Price Grids Retrieves all Price Grids based on filter settings. --- Filter example: Returns only Price Grids where status = CANCELLED. json { "data":{ "_constructor":"AdvancedCriteria", "operator":"and", "criteria":[ { "fieldName":"status", "operator":"equals", "value":"CANCELLED" } ] } } --- Endpoint: POST /fetch/PG Security: basic, X-PriceFx-jwt ## Request fields (application/json): - `endRow` (number) 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) - `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) - `data` (object) - `data._constructor` (string) - `data.operator` (string) - `data.criteria` (array) - `data.criteria.fieldName` (string) - `data.criteria.operator` (string) Specify an operator of the filter criteria. Enum: "equals", "iEquals", "notEqual", "iNotEqual", "isNull", "notNull", "contains", "iContains", "containsPattern", "iContainsPattern", "notContains", "iNotContains", "startsWith", "iStartsWith", "notStartsWith", "iNotStartsWith", "endsWith", "iEndsWith", "notEndsWith", "iNotEndsWith", "iBetween", "iBetweenInclusive", "inSet", "notInSet" - `data.criteria.value` (string) ## Response 200 fields (application/json): - `response` (object) - `response.status` (number) - `response.startRow` (number) - `response.node` (string) - `response.csrfToken` (string) - `response.data` (array) - `response.data.version` (number) - `response.data.typedId` (string) - `response.data.label` (string) - `response.data.calculationMessages` (string) - `response.data.numberOfItems` (number) - `response.data.keepManualOverrides` (boolean) - `response.data.writeOnlyChangedItems` (boolean) - `response.data.configuration` (string) - `response.data.numberOfApprovedItems` (number) - `response.data.numberOfOpenItems` (number) - `response.data.numberOfDeniedItems` (number) - `response.data.numberOfSubmittedItems` (number) - `response.data.numberOfAutoApprovedItems` (number) - `response.data.priceGridType` (string) - `response.data.createdByName` (string) - `response.data.lastUpdateByName` (string) - `response.data.updateDate` (string) - `response.data.updatedBy` (number) - `response.data.createDate` (string) - `response.data.createdBy` (number) - `response.data.lastUpdateDate` (string) - `response.data.lastUpdateBy` (number) - `response.data.calculationStartDate` (string) - `response.data.calculationDate` (string) - `response.data.partialCalculationDate` (string) - `response.data.id` (number) - `response.endRow` (number) 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.