How can we manipulate/work with response data?

[mattnield]

How can we go about working with the response data from a request?

Here's a use case: Using the Open Breweries DB API, I want to get a list of all of the breweries. I want to pass in the name and phone numbers of the breweries to the body of another API call. Just those details though.

So from this:

[
    {
        "id": "banjo-brewing-fayetteville",
        "name": "Banjo Brewing",
        "brewery_type": "planning",
        "street": null,
        "address_2": null,
        "address_3": null,
        "city": "Fayetteville",
        "state": "West Virginia",
        "county_province": null,
        "postal_code": "25840",
        "country": "United States",
        "longitude": null,
        "latitude": null,
        "phone": "3042164231",
        "website_url": null,
        "updated_at": "2021-10-23T02:24:55.243Z",
        "created_at": "2021-10-23T02:24:55.243Z"
    },
    ....
    {
        "id": "dirt-road-brewing-corvallis",
        "name": "Dirt Road Brewing",
        "brewery_type": "planning",
        "street": null,
        "address_2": null,
        "address_3": null,
        "city": "Corvallis",
        "state": "Oregon",
        "county_province": null,
        "postal_code": "97330-3005",
        "country": "United States",
        "longitude": null,
        "latitude": null,
        "phone": "5415984221",
        "website_url": "http://dirtroadbrewing.com",
        "updated_at": "2021-10-23T02:24:55.243Z",
        "created_at": "2021-10-23T02:24:55.243Z"
    }
]

I want to end up with this:

[
    {
        "name": "Banjo Brewing",
        "phone": "3042164231"
    },
    ....
    {
        "name": "Dirt Road Brewing",
        "phone": "5415984221"
    }
]

Is this something we should be able to do? I've had a try at using the expression builder in the Durables block, but perhaps this isn't the right way to go about it?

[samay-v]

Hey @mattnield
I built a flow for you to demonstrate how you can achieve it, let me know if that solves your use case 😄
https://www.postman.com/postman/workspace/postman-answers/flow/626a7df1d91bbd014d59aedd

[mattnield]

Thank you @samay-v
I hadn't thought about using the loop to aggregate the individual rows together!

[mattnield]

I also just noticed that the web version contains many more shapes!

[samay-v]

The app and the web versions have the same amount of blocks, maybe try updating your app?

[mattnield]

👍 turns out Id disabled automatic updates for some reason 😖

…

On Fri, 29 Apr 2022 at 06:52, Samay Verma ***@***.***> wrote: The app and the web versions have the same amount of blocks, maybe try updating your app? — Reply to this email directly, view it on GitHub <#306 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACVH33QAR5RRA6ULFXPDLHDVHN2JVANCNFSM5USCBGMQ> . You are receiving this because you were mentioned.Message ID: ***@***.*** com>