Hi when trying to filter inventory item by price
url = acc_id/record/v1/inventoryItem?q=price GREATER_OR_EQUAL 1000
response=
{
“type”: “https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1“,
“title”: “Invalid search query Search error occurred: Field ‘price’ for record ‘item’ was not found..”,
“status”: 400,
“o:errorCode”: “INVALID_PARAMETER”
}
and same happing when trying to filter with material and size
Hi,
The field ‘price’ refers to a sublist and so won’t work as you want here.
https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/item.html
You may be able to get what you need via a SuiteQL query.
Thanks,
Chris
