RE: SalesOrder suitetalk web services

Home

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.

Share
Comment(0)

Add Comment

2 Answers

Votes
Oldest

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.

battk Advanced Answered on October 26, 2020.

Share
Comment(0)

Add Comment

Recent Posts