I am new to APIs and currently working on a project to analyse data from a job website, reed.co.uk. I am trying to export the data to a spreadsheet with the variable names as headers, rather than a json. A typical GET request, e.g.
curl --location --request GET 'https://www.reed.co.uk/api/1.0/search?keywords=accountant&location=london' \
Returns this:
"results": [
{
"jobId": 44137966,
"employerId": 575264,
"employerName": "REED",
"employerProfileId": null,
"employerProfileName": null,
"jobTitle": "Management Accountant",
"locationName": "Maidstone",
"minimumSalary": 28000.00,
"maximumSalary": 35000.00,
"currency": "GBP",
"expirationDate": "28/10/2021",
"date": "21/09/2021",
"jobDescription": " My client is looking to recruit an ambitious and commercially aware Management Accountant. Working closely with the Finance Director, you will provide accurate and timely management accounting information and reports in accordance with strict deadlines. In addition, you will work closely with the finance team providing support on a daily basis. Please note: The standard hours of work are 7.00am to 3.45pm, Mo... ",
"applications": 3,
"jobUrl": "https://www.reed.co.uk/jobs/management-accountant/44137966"
etc etc
If I then follow Postman's own method for writing to csv (
Step 5: Check the folder Responses