Need Help with ISNet Connection

[Anonymous]

Our safety team is trying to connect to ISNet data using the query below, where the blue text are confidential variables we enter:

let
url="https://api.isnetworld.com/token",
url1 = "https://api.isnetworld.com/1.0/SiteTracker/ContractorInfo/[contractorID]/[projectID]/2020/March",
GetJson = Json.Document(Web.Contents(url, [Headers=[#"Content-Type"="application/json", CompanyKey="[companykey]", UserKey="[userkey]"]])),
AccessToken = GetJson[token],
AccessTokenHeader = "bearer "&AccessToken,
GetData = (Web.Contents(url1, [Headers=[Authorization=AccessTokenHeader]]))
in
GetData

The token returns perfectly - but we get a 500 Internal Server Error when attempting to use the token with url1.

ISNetworld – API syntax guide:
GET /1.0/SiteTracker/ContractorInfo/{Contractor_ISNID}/{Project_ID}/{Year}/{Month}

Wondering if anyone has had success connecting to the ISNet data. Any help or suggestions would be appreciated.

[v-lid-msft]

Hi @Anonymous ,

Your query looks great. It is weird to get the 500 error, such as if the token is expire, it should return authentication fail, if the items does not exist, it should return resource not found, etc...

Could you please try to post the request by using other tools outside the power bi desktop? To Verify if the request sent by desktop is correct, you can capture the http request sent by the power bi desktop. Sorry for that we know nothing about this api, but does there any possibility the {Month} mean month number such as 3 other than month name such as march? (if the api document has provided the example ”march“, please ignore this)

Best regards,

[Anonymous]

Thank you for the reply. We'll try some other validation tools and see what happens.