Forum Discussion
Can not connect to NetSuite from Power Query but can connect with Postman
I am hoping someone can help me connect Power Query to NetSuite. I am able to connect and run a query using Postman but when I try to duplicate the headers and body in Web.Contents, I get an error of Access to the resource is forbidden. Any help is very much appreciated. Here is my power query steps:
response = Web.Contents("https://12345.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=customscript_suiteapi&deploy=1", [Headers=[#"Content-Type"="application/json", Authorization="OAuth realm=""12345"",oauth_consumer_key=""CONSUMERKEY"",oauth_token=""OAUTHTOKEN"",oauth_signature_method=""HMAC-SHA256"",oauth_timestamp=""1705976764"",oauth_nonce=""dVnFfCDMbPW"",oauth_version=""1.0"",oauth_signature=""9hmTQRKY3cgVLLnsrdEcKhg1fDI8w81Wo367rR9f7HA%3D"""]]),
1 Reply
Hi ukenstor ,
It's hard to tell what the problem is just based on the information available, can you take a screenshot of the complete error message?
Or you can try to connect to NetSuite using other methods. There are three options to get data from the Netsuite service:1. Purchase the SuiteAnalytics Connect (ODBC) functionality from NetSuite
2. Leverage NetSuite’s Web Query report functionality
3. Leverage API Server
You can refer to the following documentation to try to connect:
Connect NetSuite to Power BI - DataChant
Use the API Server and NetSuite ADO.NET Provider in Microsoft Power BI (cdata.com)
Work with Live NetSuite Data in Power Query (cdata.com)
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
