Forum Discussion

niculeica's avatar
niculeica
Helper I
1 year ago

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 anym...
Need Help
danextian's avatar
danextian
Super User
1 year ago

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
    JsonResult
niculeica's avatar
niculeica
Helper I
1 year ago

Hi, 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
}