RE: SalesOrder suitetalk web services


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


GET ‘’

and this:

GET ‘’

and this

GET ‘’

all return status 200.


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

curl –location –request POST ‘’ \
–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″‘ \
–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(
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.

Advanced Answered on October 26, 2020.
Add Comment

Your Answer

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