Forum Discussion
Connect through REST API - authorization token
Hi! Has the token authorization been deprecated by any chance? Selecting From Web as data source -> Advanced, down in HTTP request header parameters I cannot see Authorization as dropdown option anymore.
4 Replies
hi niculeica
I normally don't use that when connecting to an API. Assuming the result of an API request is a JSON file, try this:
let // Define the API base URL BaseUrl = "https://api.example.com/v1/data", // Define the Bearer token BearerToken = "your_bearer_token_here", // Set up the headers _Headers = [ Authorization = "Bearer " & BearerToken, Accept = "application/json" ], // Make the API request Source = Web.Contents( BaseUrl, [ Headers = _Headers ] ), // Parse the response as JSON JsonResult = Json.Document(Source) in JsonResultHi, danextian,
Thank you for the swift reply here! I'm really novice with this connection type. I get what I would need to replace in the code you provided (I assume the code will be entered in a Blank Query, then chose JSON as option in Get data tab), but don't really have experience with JSON files.
I believe the JSON file's structure would be the one below, but do I need to declare each field's type or how do you go about creating the file itself?
[{ "approved": false, "approvedBy": "", "category": 0, "comment": "", "date": "2021-04-13T03:14:00.000+03:00", "issueId": 12637, "issueKey": "BT-11", "projectKey": "BT", "timeSpent": 7200, "username": "557058:009e0ad2-70b5-4b95-862c-12355112323", "worklogId": 11649 }niculeica Can you ping me the API you are using here ? So, that I can see whether it is using Get or POST Request. Even the link to the documentation would suffice. Thanks
