Connect through REST API - authorization token

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
}