RE: Rest API Code Example for Item fulfillment by status

Hello,

 

I have a developer trying to get item fulfillments by status of “packed”, ID “B”. I wanted to get a url example of this.

I see a code example for transform like below:

POST https://<accountID>/services/rest/record/v1/salesorder/{{SALES_ORDER_ID}}/!transform/itemFulfillment
{ “item”:{ “items”:[ { “orderLine”:1, “location”:6, “itemreceive”: true } { “orderLine”: 3 “location”: 6, “itemreceive”: false } ] }
}

 

My dev’s current url:

 https://xxxxxxx.suitetalk.api.netsuite.com/services/rest/record/v1/itemFulfillment?limit=10&offset=0&q=shipStatus CONTAIN B

I get this error response
{“type”:”https://www.rfc-editor.org/rfc/rfc9110.html#section-15.5.1“,”title”:”Bad Request”,”status”:400,”o:errorDetails”:[{“detail”:”Unknown field name ‘shipStatus’ in the search query. The field does not exist on this record type.”,”o:errorQueryParam”:”q”,”o:errorCode”:”NONEXISTENT_FIELD”}]}
Add Comment
1 Answers

Hi,

I couldn’t get it to work with collection filtering.

However you can run SuiteQL queries through REST Web Services:
https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157909186990.html

POST https://tstdrv2257824.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql

{
“q”:”SELECT id, status, BUILTIN.DF(status) FROM transaction WHERE type = ‘ItemShip’ AND status = ‘C'”
}

Here is status of C is Item Fulfillment : Shipped.

Please let me know if you need any more details.

Thanks,

Chris

Advanced Answered on August 2, 2024.

Thanks Chris!! I greatly appreciate your help. I’ll relay this to my dev.

on August 2, 2024.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.