Hi,
I am trying to test the connection to https://podserver.co/api/shops/pours, but it gives me below error:
{
“status”: “error”,
“message”: “You must be logged in to do this.”
}
I am able to connect to this url through Power BI using below script:
let
authName = “xxxxx”,
authPass = “xxxxx”,
url = “https://podserver.co/”,
days=“30”,
start=“2020-08-01”,
daysp = Number.FromText(#“days”)*-1,
startdatep = DateTime.Date( Date.AddDays(DateTime.LocalNow(), #“daysp”)),
starttextp = Date.ToText( #“startdatep”, “yyyy-MM-dd”),
GetJson = Web.Contents(url,
[
RelativePath = “api/login”,
Headers = [#“Content-Type”=“application/x-www-form-urlencoded;charset=UTF-8”],
Content = Text.ToBinary(“username=” & authName & “&password=” & authPass)
]
),
token = Json.Document(GetJson)[data],
// Gets token from the Json response
authToken = token[authToken],
authId = token[userId],
apiHeaders = [#“X-Auth-Token”=authToken,
#“X-User-Id”=authId],
// Get paint shops
GetShops = Web.Contents(url,
[
RelativePath = “api/shops/pours”,
Headers = apiHeaders,
Query = [#“start”=start, #“days”=days]
//Query = [#“start”=starttextp, #“days”=days]
]
),
json_tab = Table.FromList(Json.Document(GetShops), Splitter.SplitByNothing()),
expand_1 = Table.ExpandRecordColumn(json_tab, “Column1”, {"_id", “companyName”, “contactName”, “phone”, “email”, “address”, “archived”, “pours”}),
#“Expanded pours” = Table.ExpandListColumn(expand_1, “pours”),
#“Expanded pours1” = Table.ExpandRecordColumn(#“Expanded pours”, “pours”, {“pourId”, “date”, “units”, “mixer”, “jobNum”, “pourCost”, “targetCost”, “mfr”, “colCode”, “colName”, “stdNum”, “variation”, “weight”, “density”}, {“pours.pourId”, “pours.date”, “pours.units”, “pours.mixer”, “pours.jobNum”, “pours.pourCost”, “pours.targetCost”, “pours.mfr”, “pours.colCode”, “pours.colName”, “pours.stdNum”, “pours.variation”, “pours.weight”, “pours.density”})
in
#“Expanded pours1”
Can someone help me to test this connection.
Thanks.