00:02 Setting up NetSuite for REST API connections 02:15 Setting up Rest APIs in NetSuite 04:15 Authorization process and using Postman for Rest API 06:20 Setting up Rest APIs in NetSuite to ensure security and successful request handling. 08:27 Setting up authorization for Rest APIs in NetSuite 11:04 Obtaining and refreshing access tokens in NetSuite Rest API integration. 13:48 Setting up Rest APIs in NetSuite for querying data and limiting responses to 5. 16:11 Setting up Rest API in NetSuite allows easy access and management of tokens for developers
Is Netsuite SOAP API supports Formula Text column from Saved Search ? because when I fetch the SOAP API saved search Data it does not return Formula text column
Try redoing the previous step and then quickly copying the authorization code over to the post request. I was stumped on this for a while. It appears to expire after a short time.
Does code in 10:19 ever expire? I am building queries in Power BI. It doesn't have the ability to show login screen to user or to do redirect. It does successfully passes headers and body, but it needs this code. So is it changing or can I get it once manually and don't worry about it?
Hi Michael! Great question.The code referenced does change each time it is requested, and it expires as it is only supposed to last long enough to generate the access and refresh tokens. If you are trying to directly connect Power BI to NetSuite, you may need to use Power BI desktop to create a custom connector that can manage the token refresh process. You may also be able to use Postman or another tool to generate the access and refresh tokens to pass to your queries. Hope that helps!
@Michael Shparber - hey man, just curious whether you were able to figure out a connection using Power BI. I'm plagued by the lack of visibility to our netsuite data without a direct connection. My NetSuite knowledge is limited but I live in Power BI, so it'd be a huge lift if I could at least see the data as I trial & error my way through this integration project. Anything helps!
Hello Can i use it to pull out all inventory database and tranaction “ creat table query” to local access db? I want to to move to netsuite, however, i will need to keep using my self developed little software by access that i have been using since many years🤯. Untill netsuite has all data nessary in 2-3 years Thanks
Once I complete all the steps as you show here and I get the refresh_token value, can it be used forever? I,e. Can I get a new useable token next week or next year by doing a “refresh_token”authorization call using this value in the refresh_token parm?
@@shafiqhossain6333 I am kinda looking for the same, it Expires in a week and I have to reset it manually every week. Not able to automate this as well !!
At the second steps where we use code (from oauth consent screen) to post to token endpoint to get access/refresh tokens, i always got 401 Invalid login attempt message. Not sure what happened ?
Hello Pradeep! You can retrieve the code needed to get the tokens from with your own programming code, if you wish. You just need to capture the full redirect URL with query parameters that NetSuite sends you to after logging in. The methods shown here were selected to be easy to show to mixed programmer and NetSuite admin audiences.
When I use "SELECT * FROM customer" - it works, but when I use "SELECT * FROM journalentry" - it gives Bad Request 400 error: "title": "Invalid search query Search error occurred: Record 'journalentry' was not found.." I do see this record in my RecordsBrowser. I also am able to get results if I call "/record/v1/journalEntry". So why my "/query/v1/suiteql" doesn't work with journalentries?
Thanks a lot! Where can I find the documentations of ERD objects available to query? For example, I want to get journal entries data. How do I know what select to write? Thanks!
Hi Michale! Oracle does not make an ERD diagram available to users, but there are several documents you could reference to help find the records you want. If the records are available in the REST web services directly (as Journal Entries is) you can find them in the REST API browser here: system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2020.2/index.html There is also the instance-specific schema/record/ analytics browser at: .app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/account.html You should be able to use the internal ID names in your FROM clauses.
And within NetSuite, you can go to Setup > Records Catalog to see the records catalog. Hope this helps!
Thank you very much for this video. It was really helpful. I am following same steps as mentioned in the video, but when I am trying to construct the link, I am always getting 401 unauthorized error. Appreciate if anyone could help me out here.
![[ESS] How to write your very first SuiteScript - for non-developers!](http://i.ytimg.com/vi/I-7HzlhyXNI/mqdefault.jpg)
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
I am also getting status 500 on the first GET(login attempt). Anyone experiencing this and how you fix it?
00:02 Setting up NetSuite for REST API connections
02:15 Setting up Rest APIs in NetSuite
04:15 Authorization process and using Postman for Rest API
06:20 Setting up Rest APIs in NetSuite to ensure security and successful request handling.
08:27 Setting up authorization for Rest APIs in NetSuite
11:04 Obtaining and refreshing access tokens in NetSuite Rest API integration.
13:48 Setting up Rest APIs in NetSuite for querying data and limiting responses to 5.
16:11 Setting up Rest API in NetSuite allows easy access and management of tokens for developers
same for RESTlet Scripts ?
Thanks a lot for this! How would you populate a multi select field when creating a customer?
Is Netsuite SOAP API supports Formula Text column from Saved Search ? because when I fetch the SOAP API saved search Data it does not return Formula text column
Where I can find other POST request example beside the SQL query and token
How you resolve invalid_grant error at 10:46 ?
Try redoing the previous step and then quickly copying the authorization code over to the post request. I was stumped on this for a while. It appears to expire after a short time.
There was some white space in his request that is why he get invalid_grant
Does code in 10:19 ever expire?
I am building queries in Power BI. It doesn't have the ability to show login screen to user or to do redirect.
It does successfully passes headers and body, but it needs this code. So is it changing or can I get it once manually and don't worry about it?
Hi Michael! Great question.The code referenced does change each time it is requested, and it expires as it is only supposed to last long enough to generate the access and refresh tokens. If you are trying to directly connect Power BI to NetSuite, you may need to use Power BI desktop to create a custom connector that can manage the token refresh process. You may also be able to use Postman or another tool to generate the access and refresh tokens to pass to your queries. Hope that helps!
@Michael Shparber - hey man, just curious whether you were able to figure out a connection using Power BI. I'm plagued by the lack of visibility to our netsuite data without a direct connection. My NetSuite knowledge is limited but I live in Power BI, so it'd be a huge lift if I could at least see the data as I trial & error my way through this integration project. Anything helps!
I'm getting invalid grant issue. How you solved this issue ? I've not added any extra white spaces which you mentioned.
same here. also getting this error. no extra spaces.
Is there a way to use client_credentials grant type?
This is a great help, thank you. Is there also an example for oauth1 authorization which uses tokens pre-generated in Netsuite?
How to integrate netsuite with Zycus can you pls let me know about it
Can we demerge duplicate customer?
Hello
Can i use it to pull out all inventory database and tranaction “ creat table query” to local access db?
I want to to move to netsuite, however, i will need to keep using my self developed little software by access that i have been using since many years🤯. Untill netsuite has all data nessary in 2-3 years
Thanks
Once I complete all the steps as you show here and I get the refresh_token value, can it be used forever? I,e. Can I get a new useable token next week or next year by doing a “refresh_token”authorization call using this value in the refresh_token parm?
Hi John. Did you ever find a way to retrieve another Refresh token without going to a manual process (Step 1)?
@@shafiqhossain6333 I am kinda looking for the same, it Expires in a week and I have to reset it manually every week. Not able to automate this as well !!
First of all thank you very much for the video.
I get status 500 in the first GET (in the login attempt).
know why?
i'm getting the same thing. Have you resolved this one?
@@n317 No
I have figured it out. I typed in redirect_url (L) instead of redirect_uri (i). I also got the mistake of typing in 'clientid' instead of 'client_id'
@@n317tnx, i will try
@@אבירןיוספי Hey, just curious if you fixed this error on your end?
if you have invalid grant problem, make sure that the body is written as "redirect_uri" not "redirect_url". Emphasis on the i vs l
YOU HELPED ME THANK YOU!!!!
What would you recommend for a "scope_mismatch" error after logging in on the local host?
At the second steps where we use code (from oauth consent screen) to post to token endpoint to get access/refresh tokens, i always got 401 Invalid login attempt message. Not sure what happened ?
If you get stuck at the POST at 10:35, repeat the previous GET request and execute the POST immediately after.
Thanks! You saved me a couple of hours!
Spent hours but eventually saw this comment. Thanks!
Can we generate the code in the script which we generates by copy and pasting url in the browser?
Hello Pradeep! You can retrieve the code needed to get the tokens from with your own programming code, if you wish. You just need to capture the full redirect URL with query parameters that NetSuite sends you to after logging in. The methods shown here were selected to be easy to show to mixed programmer and NetSuite admin audiences.
@@eidebaillytechnology3915 same video apply for REStlet scripts ??
I am doing exactly same. its always returning `invalid_grant`
you have make my day
When I use "SELECT * FROM customer" - it works, but when I use "SELECT * FROM journalentry" - it gives Bad Request 400 error:
"title": "Invalid search query Search error occurred: Record 'journalentry' was not found.."
I do see this record in my RecordsBrowser. I also am able to get results if I call "/record/v1/journalEntry". So why my "/query/v1/suiteql" doesn't work with journalentries?
Hi, I am stuck with /record/v1/journalEntry could you help me with the same
Thanks a lot! Where can I find the documentations of ERD objects available to query? For example, I want to get journal entries data. How do I know what select to write? Thanks!
Hi Michale! Oracle does not make an ERD diagram available to users, but there are several documents you could reference to help find the records you want. If the records are available in the REST web services directly (as Journal Entries is) you can find them in the REST API browser here: system.netsuite.com/help/helpcenter/en_US/APIs/REST_API_Browser/record/v1/2020.2/index.html
There is also the instance-specific schema/record/ analytics browser at: .app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/account.html
You should be able to use the internal ID names in your FROM clauses.
And within NetSuite, you can go to Setup > Records Catalog to see the records catalog. Hope this helps!
@@eidebaillytechnology3915 It helps very much! Thank you!!!
@@eidebaillytechnology3915 Thanks a lot!
Is this apart of the bundle in NetSuite? The application name in the video and the bundle in NS have the same name.
Very good.
Thanks a lot!
Thank you very much for this video. It was really helpful. I am following same steps as mentioned in the video, but when I am trying to construct the link, I am always getting 401 unauthorized error. Appreciate if anyone could help me out here.
did you solve it?
I get the same error...
How to create INVOICE in NetSuite using API's
are you working on netsuite?
Have you found any?
Amazing... Thanks for sharing.
nice
I wonder why oracle did this real SHITT service..