NetSuite using Oauth 1

[ScotSunnergren]

I have been following the instructions from https://medium.com/@mgr/how-to-connect-to-netsuite-from-microsoft-power-automate-using-oauth-1-0-1d7...

With the help of Reddit, I got past the invalid signature but now I am getting a 400 bad request response and seem to be stuck.

Has anyone got this to work?  Any ideas?

[JustinLiu]

I try to use the same approach and get the 401.

@ScotSunnergren Have you find the solution now? Thanks

[ScotSunnergren]

I had to go in a different direction and use an Azure Function app to do the authentication. 

[KristenL4]

I'm following the medium article and running into the same issue.  Can you share how you used the Azure Function to authenticate?

[ScotSunnergren]

You would have to be familiar with both the use of Oauth1 to access NetSuite as well as writing Function Apps in Azure. 

I use an HTTP trigger app so it works like a WebHook receiver.  I can post to that receiver from a PowerAutomate process and get a returned result. I store creds in Azure within the function app keys.  I personally use the powershell scripting but there are a number of languages that can be used. If you have used token based access before from other programs, you can copy that code and there are many sources to find that code on the web. 


I set up a scripts on NetSuite to receive a single variable with JSON information.  

My Function App takes that JSON as the body but also takes parameters of "Method", "ScriptID", "DeploymentID", "Realm" which are defined and passed from the Power Automate process.  Those allow my functionapp to specify a get or post, the suitescript and deployment to be accessed, and whether I want to hit production or sandbox.  The function app simply sends the JSON provided in the HTTP body through to the SuiteScript and receives whatever the SuiteScript returns and returns that to the calling PowerAutomate process.

So I can use the same FunctionApp with any number of SuiteScripts that have been set up to receive a JSON body as input. 

It is an unfortunate that we have to have a "middleman" like this and cannot have PowerAutomate connector that works with NetSuite. I can only assume that Microsoft would prefer you to use Dynamics365 and are not really concerned with creating a proper connector to a 3rd Party ERP but it leaves a huge number of otherwise-Microsoft devotees out in the cold. 

[Uthoocha]

Hi Scot, I've read your post from‎ 07-24-2023 and many other older threads and posts from around the web on the Topic of sending or receiving data from Netsuite using a Power Automation flow. Can you tell me if it is still the case, to the best of your knowledge, that such middleware is required, and that oAuth2 can not be used in a HTTP flow action to Get a valid action Token, to make a call to the netsuite Suitetalk API? 

We only want to build some simple flows to create orders in Netsuite, with products as Items, when an Order is Processed in Dynamics CRM. We've achieved other data flows submitting to APIs such as Hubspot and Zendesk. I just can't find one clear solution or success story on the web that shows someone achieving this with Netsuite. Hope to hear from you soon, any help or pointers would be helpful before I embark following you down the same rabbit holes you have already gone down.