Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shindejyoti69
Regular Visitor

pull data from a Netsuite REST API using NLauth authentication

Hi all,

 

Data is in Json format : 

 

[
{
"SO_Number": "SO/SW-AHB/002690",
"PO_Date": "03/12/2018",
"Department": "Pepsico - RFPL",
"Class": "RFPL : Pepsico - RFPL",
"Location": "RFPL : Ahmedabad - DC"

}
]

 

I want this data in power BI to desing PI Chart using NLauth,

query : 

let
Source = Json.Document(Web.Contents("https://xyz-sb1.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=7&deploy=1", [Headers=[Authorization="NLAuth nlauth_account= , nlauth_email= , nlauth_signature= , nlauth_role = ", Accept="application/json"]])),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"SO_Number", "PO_Date", "Department", "Class", "Location"}, {"SO_Number", "PO_Date", "Department", "Class", "Location"})
in
#"Expanded Value"

 

I m getting this error : 

 

DataSource Error : Web.Contents failed to get Contents  from url (400) Bad request 

 

Please give me solution, that i can take this json data in power bi table to design PI chart report.

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.