Retrieves records from the Product Extensions table.
Export the table to the Excel file (XLSX), CSV, or JSON using the output
URL query parameter. When exporting to the file, specify fields (within the resultFields
property) you want to include in the output table.
Example request body for the export action:
{
"data":{
"criteria":[
],
"operator":"and"
},
"resultFields":[
"sku",
"lastUpdateDate",
"attribute1"
],
"valueFields":[
]
}
You can choose fields to be returned in the response by employing the resultFields
or valueFields
filter:
resultFields: returns key-value pairs as objects. This is the more friendly response compared to valueFields but the server fetches all fields from the database in the backend which might result in a slower performance. See the List Products' listProductsResponseExample_resultFields response example.
valueFields: returns just an array of values. Use this option if a better performance is required. See the List Products' listProductsResponseExample_valueFields response example.
{- "endRow": 0,
- "oldValues": null,
- "operationType": "string",
- "startRow": 0,
- "textMatchStyle": "string",
- "data": {
- "_constructor": "string",
- "operator": "string",
- "criteria": [
- {
- "fieldName": "string",
- "operator": "string",
- "value": "string"
}
]
}, - "sortBy": [
- { }
]
}
{- "response": {
- "node": "e2e-staging-node",
- "data": [
- {
- "version": 1,
- "typedId": "20.PX8",
- "name": "pcost",
- "sku": "11111",
- "createDate": "2021-11-04T17:01:34",
- "createdBy": 2147490696,
- "lastUpdateDate": "2021-11-04T17:02:34",
- "lastUpdateBy": 2147490696,
- "attribute1": "100",
- "attribute2": null,
- "attribute3": null,
- "attribute4": null,
- "attribute5": null,
- "attribute6": null,
- "attribute7": null,
- "attribute8": null
}
], - "endRow": 1,
- "totalRows": 1,
- "status": 0
}
}