Description
We can fetch some of the beta record fields using SuiteQL in postman. Here Assembly Item is an example for beta record.
Solution
We can only fetch the following fields of Assembly item record using SuiteQL
- Assembly
- Bills of materials
- Can be master
- Master default
To use SuiteQL, we need to be careful of the following
The method used to should be post instead of GET and the URL will of the below form where 6826574 is the Netsuite account id. Limit=5 means we can fetch 5 records at a time.
https://6826574.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=5
In the params section, we need to specify the limit.
In the Authorization section, we need to specify the Consumer Key, Consumer Secret, Access Token, Token Secret etc which will be available after creating a new access token in Netsuite.
In the Advanced section, you need to specify the Netsuite Id in the Realm
In the Headers section, add the following
In the Body part, add the query like the following
After setting the above settings, Click the Send button near the URL.
Then it will return the assembly items as the response
