List within a list using external collections?

Get Help External Collections, Custom Actions & Collections
1

Hi,

I have a certain challenge. I Need to show the results which contains list of list. My json looks like this

{
    "status": "ok",
    "result": [
        {
            "balance": 38,
            "auto_refil": 0,
            "payment_methods": [
                {
                    "id": 5,
                    "id_advertiser": 6,
                    "name": "My Main Card Test",
                    "last_digits": "4xxxxxxxxxxxxxxx",
                    "is_default": 1,
                    "is_active": 1,
                    "first_name": [
                        "undefined"
                    ],
                    "last_name": [
                        "undefined"
                    ],
                    "expiry": [
                        "0500"
                    ],
                    "street_address": [
                        "Street Address"
                    ],
                    "zip": [
                        "33180"
                    ],
                    "email": [
                        "xyz@gmail.com"
                    ],
                    "city": [
                        "Aventura"
                    ],
                    "state": "Florida",
                    "phone": [
                        "1234567890"
                    ],
                    "country": [
                        "United States"
                    ],
                    "expiry_month": "05",
                    "expiry_year": "2000",
                    "complete_address": "USA"
                },
                {
                    "id": 32,
                    "id_advertiser": 6,
                    "name": "Mark-Test",
                    "last_digits": "5xxxxxxxxxxxxxx",
                    "is_default": 0,
                    "is_active": 1,
                    "first_name": [
                        "undefined"
                    ],
                    "last_name": [
                        "undefined"
                    ],
                    "expiry": [
                        "0500"
                    ],
                    "street_address": [
                        "Street Address"
                    ],
                    "zip": [
                        "33180"
                    ],
                    "email": [
                        "abcd@gmail.com"
                    ],
                    "city": [
                        "Aventura"
                    ],
                    "state": "Florida",
                    "phone": [
                        "1234567890"
                    ],
                    "country": [
                        "United States"
                    ],
                    "expiry_month": "05",
                    "expiry_year": "2000",
                    "complete_address": "Address"
                }
            ]
        }
    ]
}

The result array contains the data and in data i have another list which is Payment Method.

I can get the collection result but the issue is i can’t seem to iterate the Payment Method list. How is it possible.

Any help @Flawless?

2

Hey Jibran,

On your API call, add these 2 result keys. You have to click the + to add a 2nd result key.

First result key: result
Second result key: payment_methods

3

Hey @Flawless

It is not accepting the second result key. Throwing the error. The payment_methods list is inside the result

have tried
Second result key: payment_methods
and
Second result key: result.payment_methods

4

Screenshot of that window?