Forum Discussion

jayhawk's avatar
jayhawk
Advocate I
6 years ago

Connect to API. Bearer Token

Hi I am having a hard time connecting to data via API.  I am attempting pull out data from Samsara, https://www.samsara.com/api#. (the website is public info).  They use something called Bearer Toke...
Need Help
KHC0587's avatar
KHC0587
Frequent Visitor
3 years ago

Did anyone figure out how to set up automatic refreshes on this data source? I have been able to pull the data from Samsara (thank you all for the above support), but when I publish online, I can't set up refreshes due to missing web credentials?

 

This is my M-Script call:

Json.Document(Web.Contents("https://api.samsara.com/fleet/vehicles", [Headers=[Authorization="Bearer myapiKey"]]))

 

and off of the vehicle id columns i call:

#"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each Json.Document(Web.Contents("https://api.samsara.com/",[RelativePath = "v1/fleet/trips" & "?startMs=" & Text.From(Duration.TotalSeconds(startMs - #datetime(1970, 1, 1, 0, 0, 0))) & "000" & "&endMs=" & Text.From(Duration.TotalSeconds(Date.From(DateTimeZone.LocalNow())-#date(1970, 1, 1))) & "000" & "&vehicleId=" & [data.id], Headers = [Authorization = "Bearer " & "myapiKey"]]))),

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Did you resolve this? I'm stuck with the same issue

  • KHC0587's avatar
    KHC0587
    Frequent Visitor
    3 years ago

    Unfortunately, no I never solved it, ended up just abandoning the project as leadership lost interest in it.