I am also getting status 500 on the first GET(login attempt). Anyone experiencing this and how you fix it?
@albertsugianto2340
2 жыл бұрын
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
@JBFromOZ
2 жыл бұрын
YOU HELPED ME THANK YOU!!!!
@EthanSierra48
3 жыл бұрын
Thanks a lot for this! How would you populate a multi select field when creating a customer?
@MayankRaja0
2 жыл бұрын
This is a great help, thank you. Is there also an example for oauth1 authorization which uses tokens pre-generated in Netsuite?
@mycloud1976
4 жыл бұрын
If you get stuck at the POST at 10:35, repeat the previous GET request and execute the POST immediately after.
@mshparber
3 жыл бұрын
Thanks! You saved me a couple of hours!
@aamir0077
2 жыл бұрын
Spent hours but eventually saw this comment. Thanks!
@vikassinghal8478
3 жыл бұрын
you have make my day
@stalinathavan1043
3 жыл бұрын
same for RESTlet Scripts ?
@jz4379
2 жыл бұрын
Where I can find other POST request example beside the SQL query and token
@manthansoni8900
2 жыл бұрын
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
@jankool01
3 жыл бұрын
Very good.
@anujraj4736
3 жыл бұрын
I'm getting invalid grant issue. How you solved this issue ? I've not added any extra white spaces which you mentioned.
@jobethhuzainadjaluddin3298
3 жыл бұрын
same here. also getting this error. no extra spaces.
@vikashrawat2954
3 жыл бұрын
How to integrate netsuite with Zycus can you pls let me know about it
@Weeeegeee
3 жыл бұрын
What would you recommend for a "scope_mismatch" error after logging in on the local host?
@joycejacob3561
4 жыл бұрын
Thanks a lot!
@ntmq1986
3 жыл бұрын
Is there a way to use client_credentials grant type?
@אבירןיוספי
3 жыл бұрын
First of all thank you very much for the video. I get status 500 in the first GET (in the login attempt). know why?
@n317
3 жыл бұрын
i'm getting the same thing. Have you resolved this one?
@אבירןיוספי
3 жыл бұрын
@@n317 No
@n317
3 жыл бұрын
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'
@אבירןיוספי
3 жыл бұрын
@@n317tnx, i will try
@jobethhuzainadjaluddin3298
3 жыл бұрын
@@אבירןיוספי Hey, just curious if you fixed this error on your end?
@ngocthien9416
3 жыл бұрын
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 ?
@salimhossain2192
Жыл бұрын
I am doing exactly same. its always returning `invalid_grant`
@mbasaffar
3 жыл бұрын
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
@poonamnodiya128
Жыл бұрын
Can we demerge duplicate customer?
@johnhohn6207
3 жыл бұрын
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
2 жыл бұрын
Hi John. Did you ever find a way to retrieve another Refresh token without going to a manual process (Step 1)?
@satyamchourey6120
Жыл бұрын
@@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 !!
@mdfaizi9864
9 ай бұрын
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
@yashdas2531
4 жыл бұрын
Amazing... Thanks for sharing.
@mshparber
4 жыл бұрын
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!
@eidebaillytechnology3915
3 жыл бұрын
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!
@mshparber
3 жыл бұрын
@@eidebaillytechnology3915 It helps very much! Thank you!!!
@mshparber
3 жыл бұрын
@@eidebaillytechnology3915 Thanks a lot!
@humzariaz7345
3 жыл бұрын
How you resolve invalid_grant error at 10:46 ?
@TheSlampor
3 жыл бұрын
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.
@adamstrauss3155
3 жыл бұрын
There was some white space in his request that is why he get invalid_grant
@mshparber
3 жыл бұрын
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?
@anchitaggarwal3206
2 жыл бұрын
Hi, I am stuck with /record/v1/journalEntry could you help me with the same
@mshparber
3 жыл бұрын
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?
@eidebaillytechnology3915
3 жыл бұрын
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!
@jakechamberlain6023
2 жыл бұрын
@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!
@taufeeqahmad9813
4 жыл бұрын
nice
@xbots4196
3 жыл бұрын
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.
@danielstarkman2771
3 жыл бұрын
did you solve it? I get the same error...
@pradeeppol4281
3 жыл бұрын
Can we generate the code in the script which we generates by copy and pasting url in the browser?
@eidebaillytechnology3915
3 жыл бұрын
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.
@stalinathavan1043
3 жыл бұрын
@@eidebaillytechnology3915 same video apply for REStlet scripts ??
@Kmeg12
2 жыл бұрын
Is this apart of the bundle in NetSuite? The application name in the video and the bundle in NS have the same name.
Пікірлер: 58