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

Rookie Asked on August 21, 2020 in SuiteApps.
Add Comment
1 Answer(s)

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

Intermediate Answered on August 21, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor