Insert specific data from an API list/array

tim12 · 2020-10-02T12:34:29.688Z

My endpoint gets data from a webhook. This api data contains an array like this:

"meta_data": [
        {
            "id": 1,
            "key": "a",
            "value": "14"
        },
        {
            "id": 2,
            "key": "b",
            "value": "20"
        },
        {
            "id": 3,
            "key": "c",
            "value": "55"
        }
]

When using “Insert dynamic data -> request data”, I can pick “meta_data”.

But how do I choose the value of ‘meta_data’ with key “b” for example?

Thanx for the help!

tim12 · 2020-12-14T13:21:53.219Z

Still looking for this answer

jdiaz · 2020-12-14T13:47:19.872Z

I think that because it is an array, you should be able to pick"meta_data" and then a bunch of the list functions like first item, last item, item#, and so on. If you use the item # with the number 2, it will give you the options of the id, key, and value. At least that is how it has been working for me when working with JSON payloads from an API.

tim12 · 2020-12-14T14:44:08.900Z

Thanks for your response. Normally this works for me. But now I have a variable amount of meta_data. So I need something like

GET value WHERE id=3

Do you know what I mean?

jdiaz · 2020-12-14T15:18:51.039Z

Have you tried filtering on the meta data object and then see if you can do it on Id?