pull data from a Netsuite REST API using NLauth authentication

shindejyoti69 — Fri, 14 Dec 2018 10:06:45 GMT

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.

topic pull data from a Netsuite REST API using NLauth authentication in Developer

pull data from a Netsuite REST API using NLauth authentication