RE: SalesOrder suitetalk web services

Hi,

I am trying to extract all salesorders using suitetalk web services(rest api).

This:

GET ‘https://100000-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/metadata-catalog/salesorder’

and this:

GET ‘https://100000-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/salesOrder/’

and this

GET ‘https://100000-sb1.suitetalk.api.netsuite.com/services/rest/record/v1/salesOrder/98378’

all return status 200.

 

However when I try to use the query parameter and SquiteQL:

curl –location –request POST ‘https://100000-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=5’ \
–header ‘prefer: transient’ \
–header ‘Content-Type: application/json’ \
–header ‘Authorization: OAuth realm=”100000_SB1″,oauth_consumer_key=”something”,oauth_token=”something2″,oauth_signature_method=”HMAC-SHA256″,oauth_timestamp=”1603744267″,oauth_nonce=”something3″,oauth_version=”1.0″,oauth_signature=”something4″‘ \
–header ‘Cookie: NS_ROUTING_VERSION=LAGGING’ \
–data-raw ‘{
    “q”: “SELECT * FROM salesorder”
}’

returns status 400 with the error message

“Invalid search query. Detailed unprocessed description follows. Search error occurred: Record ‘salesorder’ was not found.”,
I have also tried to use q”: “SELECT balance FROM salesorder” but the result is the same. The last query works fine when I use it to get Customers.
I think I have the neccessary permissions for the role I am using(https://www.nuomiphp.com/eplan/en/71831.html).
Why does it not work when i use SalesOrder?

 

Any help would be much appriciated

Hendricks Rookie Asked on October 26, 2020 in SuiteAnalytics.
Add Comment
2 Answers

Finding Record Type and Field Names

SuiteQL does not use the same metadata as that used by the REST Webservice. Its more similar to a saved search where the sales order is a subtype of the transaction search type.

Intermediate Answered on October 26, 2020.
Add Comment

Your Answer

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