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

Rookie Asked on October 26, 2020 in SuiteAnalytics.
Add Comment
2 Answer(s)

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

ah, thank you

Rookie Answered on October 26, 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