https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi guys I am trying to access Netsuite REST WEB SE...
# general
m
Hi guys I am trying to access Netsuite REST WEB SERVICES in POSTMAN. Here is my endpoint url https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=1000 in body section I am passing this SUITEQL { "q": "SELECT id from transaction where id=147854" } I also tried with diffrent records like select id from item none of record working and throw below error but it throws below error { "title": "Bad Request", "status": 400, "o:errorDetails": [ { "detail": "Invalid search query. Detailed unprocessed description follows. Your current role does not have permission to perform this action.", "o:errorQueryParam": "q", "o:errorCode": "INVALID_PARAMETER" } ] } I already added REST WEB SERVICES in Setup > User/Roles > Manage Roles > edit role and go to setup tab AND also added all transaction, records list in transaction tab with FULL permission
b
m
@battk it already enabled this rest webservices
b
keep on going, there are 5 or 6 prerequisites you need to do
doing some is the same as doing none when it comes to these error messages
m
rest web services are in beta program and now this beta program is not available to join
b
is the transaction with id 147854 a record in the REST Web Services Supported Records
m
this are supported records but I am using suiteql
https://{accountid}.suitetalk.api.netsuite.com/services/rest/record/v1/inventoryItem/1234 this is working fine but suiteql not working
using rest web services
there are two way to fetch data using supported records and using suiteql supported records working fine but SuiteQL not working
b
good, so far you have now checked 2 out of 6 prerequisities
now for the other 4
m
where is other 4 in netsuite?
b
tell s you where in the usage column
m
I alerady did that
b
so far you have only shown that you checked 2 out of 6
do the other 4
m
NETSUITE REMOVED IT BETA FEATURE PARTICIPATION PROGRAM
Now i got it , they closed window to participate for new users in beta program so I can not tick for second feature, can you check in your netsuite account if the second point(REST Record Service (beta) feature) is available or not?
b
the beta feature is only required if you are using a beta feature
you said the transaction you were trying to access wa snot
which mean you move onto the other 4 things you havent checked yet
m
I alerady enabled this third point
first point already enabled
b
you've skipped the 3rd section
and also skipped one of the points of the 4th section
both related to each other
m
third section alrady enabled
b
excellent, and now onto the 4th section
which 3 permissions you need to add to the role you are using
so far you have only shown 2
m
I added below three permission based on their documentations
wait let me add analutics books
it added but still no luck
b
we are now onto get a new access token, making sure to use the role that you added all those permissions to
m
let me ask system administrator to generate new tokens thanks for ur help
b
you should be able to do it yourself using the User Access Token permission
both of which will allow you to confirm that the correct role and integration were assigned
m
thank you for your help, Suiteql is under beta version in restweb services thats why it not working. And netsuite close the window to participate in beta program for rest web service
b
suiteql is not beta
145 Views
Open in Slack
PreviousNext
Powered by