Home > Software engineering >  How do I export a response on postman to a clearly laid-out csv/xls file?
How do I export a response on postman to a clearly laid-out csv/xls file?

Time:10-12

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 (enter image description here

Step 5: Check the folder Responses

enter image description here

  • Related