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
