How to Use REST API to pull filter in Power Query

[Adam Taylor]

Hello,

I'm looking at ways to automatically pull data out of Jira and looking online a recommended way of doing so is through the REST API and uploading the JSON file to Power Query. Being fairly new to this i'm not entirely sure of the process and some guidance would be great. 

I have a specific filter that I would like to pull information from and so i'm using the URL:

XXX.atlassian.net/rest/api/3/filter'NameofFilter'

which gives me the JSON data. I have then saved that as a JSON file within Notepad++ and gone to upload into Excel however the data doesn't seem to load and so wondering if i've pulling the data correctly in the first place?