RE: Get work orders via services/rest/record and services/rest/query
Hello!
I can get list of orders or a particular order using REST Record service i.e. with get http request to https://account-id.suitetalk.api.netsuite.com/services/rest/record/v1/workorder.
But if I try to do the same via REST Query service i.e. with post http request to https://account-id.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=200
with payload {“q”: “select * from workorder”}, I’ve got an error
{ "type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1", "title": "Bad Request", "status": 400, "o:errorDetails": [ { "detail": "Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'workorder' was not found.", "o:errorQueryParam": "q", "o:errorCode": "INVALID_PARAMETER" } ] }
Could somebody please explain to me the difference in record and query services? Why quering does not work for workorder?
Hello Chris,
I’ve got it. Thanks a lot!