Nested data from API, Bubble only recognizes first item of several

Need help APIs
1

Hi,

I am trying to display data in a repeating group from an API call. The API call returns nested JSON data. I store this list of data on list shifter and then display the data in the repeating group (it does not touch the data base). However, Bubble only recognizes the first item of the nested data list

For example the data is structured as follows:

image
image464×514 8.33 KB

The issue is that each segment has multiple nested items but I cannot figure out how to get the repeating group to show the items after the first.

In the repeating group it only shows the Slices per row and then when I try to put each segment within another RG within the original RG, bubble still only recognizes the first item from the segment. I have tried conditional formatting and filters, but I can not get access to the items after the first.

Does anyone know of a solution to parsing multiple items from nested data from an API call?

Thanks for all help!

2

Can you share the full payload content?

3 
{
    "meta": {
        "limit": 50,
        "before": null,
        "after": null
    },
    "data": [
        {
            "updated_at": "2022-07-16T17:35:07.942911Z",
            "total_emissions_kg": "386",
            "total_currency": "USD",
            "total_amount": "441.86",
            "tax_currency": "USD",
            "tax_amount": "67.41",
            "slices": [
                {
                    "segments": [
                        {
                            "passengers": [
                                {
                                    "passenger_id": "pas_0000ALYXjoq2QJqaSUHP7a",
                                    "fare_basis_code": "Y20LGTN2",
                                    "cabin_class_marketing_name": "Economy",
                                    "cabin_class": "economy",
                                    "baggages": [
                                        {
                                            "type": "checked",
                                            "quantity": 1
                                        }
                                    ]
                                }
                            ],
                            "origin_terminal": "2",
                            "origin": {
                                "type": "airport",
                                "time_zone": "America/New_York",
                                "name": "Palm Beach International Airport",
                                "longitude": -80.094206,
                                "latitude": 26.684474,
                                "id": "arp_pbi_us",
                                "icao_code": "KPBI",
                                "iata_country_code": "US",
                                "iata_code": "PBI",
                                "iata_city_code": "PBI",
                                "city_name": "West Palm Beach",
                                "city": {
                                    "type": "city",
                                    "time_zone": null,
                                    "name": "West Palm Beach",
                                    "longitude": null,
                                    "latitude": null,
                                    "id": "cit_pbi_us",
                                    "icao_code": null,
                                    "iata_country_code": "US",
                                    "iata_code": "PBI",
                                    "iata_city_code": "PBI",
                                    "city_name": null
                                },
                                "airports": null
                            },
                            "operating_carrier_flight_number": "3748",
                            "operating_carrier": {
                                "name": "Duffel Airways",
                                "logo_symbol_url": "https://assets.duffel.com/img/airlines/for-light-background/full-color-logo/ZZ.svg",
                                "logo_lockup_url": null,
                                "id": "arl_00009VME7D6ivUu8dn35WK",
                                "iata_code": "ZZ"
                            },
                            "marketing_carrier_flight_number": "3748",
                            "marketing_carrier": {
                                "name": "Duffel Airways",
                                "logo_symbol_url": "https://assets.duffel.com/img/airlines/for-light-background/full-color-logo/ZZ.svg",
                                "logo_lockup_url": null,
                                "id": "arl_00009VME7D6ivUu8dn35WK",
                                "iata_code": "ZZ"
                            },
                            "id": "seg_0000ALYXjp73P3STJGEzdg",
                            "duration": "PT5H28M",
                            "distance": "3667.948515454707",
                            "destination_terminal": "1",
                            "destination": {
                                "type": "airport",
                                "time_zone": "America/Los_Angeles",
                                "name": "Palm Springs International Airport",
                                "longitude": -116.507025,
                                "latitude": 33.830009,
                                "id": "arp_psp_us",
                                "icao_code": "KPSP",
                                "iata_country_code": "US",
                                "iata_code": "PSP",
                                "iata_city_code": "PSP",
                                "city_name": "Palm Springs",
                                "city": {
                                    "type": "city",
                                    "time_zone": null,
                                    "name": "Palm Springs",
                                    "longitude": null,
                                    "latitude": null,
                                    "id": "cit_psp_us",
                                    "icao_code": null,
                                    "iata_country_code": "US",
                                    "iata_code": "PSP",
                                    "iata_city_code": "PSP",
                                    "city_name": null
                                },
                                "airports": null
                            },
                            "departing_at": "2022-07-23T23:00:00",
                            "arriving_at": "2022-07-24T01:28:00",
                            "aircraft": {
                                "name": "Boeing 777-300",
                                "id": "arc_00009VMF8AhXSSRnQDI6HE",
                                "iata_code": "773"
                            }
                        }
                    ],
                    "origin_type": "airport",
                    "origin": {
                        "type": "airport",
                        "time_zone": "America/New_York",
                        "name": "Palm Beach International Airport",
                        "longitude": -80.094206,
                        "latitude": 26.684474,
                        "id": "arp_pbi_us",
                        "icao_code": "KPBI",
                        "iata_country_code": "US",
                        "iata_code": "PBI",
                        "iata_city_code": "PBI",
                        "city_name": "West Palm Beach",
                        "city": {
                            "type": "city",
                            "time_zone": null,
                            "name": "West Palm Beach",
                            "longitude": null,
                            "latitude": null,
                            "id": "cit_pbi_us",
                            "icao_code": null,
                            "iata_country_code": "US",
                            "iata_code": "PBI",
                            "iata_city_code": "PBI",
                            "city_name": null
                        },
                        "airports": null
                    },
                    "id": "sli_0000ALYXjp7PNjk3KMPHBw",
                    "fare_brand_name": "Basic",
                    "duration": "PT5H28M",
                    "destination_type": "airport",
                    "destination": {
                        "type": "airport",
                        "time_zone": "America/Los_Angeles",
                        "name": "Palm Springs International Airport",
                        "longitude": -116.507025,
                        "latitude": 33.830009,
                        "id": "arp_psp_us",
                        "icao_code": "KPSP",
                        "iata_country_code": "US",
                        "iata_code": "PSP",
                        "iata_city_code": "PSP",
                        "city_name": "Palm Springs",
                        "city": {
                            "type": "city",
                            "time_zone": null,
                            "name": "Palm Springs",
                            "longitude": null,
                            "latitude": null,
                            "id": "cit_psp_us",
                            "icao_code": null,
                            "iata_country_code": "US",
                            "iata_code": "PSP",
                            "iata_city_code": "PSP",
                            "city_name": null
                        },
                        "airports": null
                    },
                    "conditions": {
                        "change_before_departure": {
                            "penalty_currency": null,
                            "penalty_amount": null,
                            "allowed": false
                        }
                    }
                },
                {
                    "segments": [
                        {
                            "passengers": [
                                {
                                    "passenger_id": "pas_0000ALYXjoq2QJqaSUHP7a",
                                    "fare_basis_code": "Y20LGTN2",
                                    "cabin_class_marketing_name": "Economy",
                                    "cabin_class": "economy",
                                    "baggages": [
                                        {
                                            "type": "checked",
                                            "quantity": 1
                                        }
                                    ]
                                }
                            ],
                            "origin_terminal": "2",
                            "origin": {
                                "type": "airport",
                                "time_zone": "America/Los_Angeles",
                                "name": "Palm Springs International Airport",
                                "longitude": -116.507025,
                                "latitude": 33.830009,
                                "id": "arp_psp_us",
                                "icao_code": "KPSP",
                                "iata_country_code": "US",
                                "iata_code": "PSP",
                                "iata_city_code": "PSP",
                                "city_name": "Palm Springs",
                                "city": {
                                    "type": "city",
                                    "time_zone": null,
                                    "name": "Palm Springs",
                                    "longitude": null,
                                    "latitude": null,
                                    "id": "cit_psp_us",
                                    "icao_code": null,
                                    "iata_country_code": "US",
                                    "iata_code": "PSP",
                                    "iata_city_code": "PSP",
                                    "city_name": null
                                },
                                "airports": null
                            },
                            "operating_carrier_flight_number": "3748",
                            "operating_carrier": {
                                "name": "Duffel Airways",
                                "logo_symbol_url": "https://assets.duffel.com/img/airlines/for-light-background/full-color-logo/ZZ.svg",
                                "logo_lockup_url": null,
                                "id": "arl_00009VME7D6ivUu8dn35WK",
                                "iata_code": "ZZ"
                            },
                            "marketing_carrier_flight_number": "3748",
                            "marketing_carrier": {
                                "name": "Duffel Airways",
                                "logo_symbol_url": "https://assets.duffel.com/img/airlines/for-light-background/full-color-logo/ZZ.svg",
                                "logo_lockup_url": null,
                                "id": "arl_00009VME7D6ivUu8dn35WK",
                                "iata_code": "ZZ"
                            },
                            "id": "seg_0000ALYXjp7PNjk3KMPHBx",
                            "duration": "PT5H28M",
                            "distance": "3667.948515454707",
                            "destination_terminal": "1",
                            "destination": {
                                "type": "airport",
                                "time_zone": "America/New_York",
                                "name": "Palm Beach International Airport",
                                "longitude": -80.094206,
                                "latitude": 26.684474,
                                "id": "arp_pbi_us",
                                "icao_code": "KPBI",
                                "iata_country_code": "US",
                                "iata_code": "PBI",
                                "iata_city_code": "PBI",
                                "city_name": "West Palm Beach",
                                "city": {
                                    "type": "city",
                                    "time_zone": null,
                                    "name": "West Palm Beach",
                                    "longitude": null,
                                    "latitude": null,
                                    "id": "cit_pbi_us",
                                    "icao_code": null,
                                    "iata_country_code": "US",
                                    "iata_code": "PBI",
                                    "iata_city_code": "PBI",
                                    "city_name": null
                                },
                                "airports": null
                            },
                            "departing_at": "2022-07-30T23:00:00",
                            "arriving_at": "2022-07-31T07:28:00",
                            "aircraft": {
                                "name": "Boeing 777-300",
                                "id": "arc_00009VMF8AhXSSRnQDI6HE",
                                "iata_code": "773"
                            }
                        }
                    ],
                    "origin_type": "airport",
                    "origin": {
                        "type": "airport",
                        "time_zone": "America/Los_Angeles",
                        "name": "Palm Springs International Airport",
                        "longitude": -116.507025,
                        "latitude": 33.830009,
                        "id": "arp_psp_us",
                        "icao_code": "KPSP",
                        "iata_country_code": "US",
                        "iata_code": "PSP",
                        "iata_city_code": "PSP",
                        "city_name": "Palm Springs",
                        "city": {
                            "type": "city",
                            "time_zone": null,
                            "name": "Palm Springs",
                            "longitude": null,
                            "latitude": null,
                            "id": "cit_psp_us",
                            "icao_code": null,
                            "iata_country_code": "US",
                            "iata_code": "PSP",
                            "iata_city_code": "PSP",
                            "city_name": null
                        },
                        "airports": null
                    },
                    "id": "sli_0000ALYXjp7lMQ1dLSZYkC",
                    "fare_brand_name": "Basic",
                    "duration": "PT5H28M",
                    "destination_type": "airport",
                    "destination": {
                        "type": "airport",
                        "time_zone": "America/New_York",
                        "name": "Palm Beach International Airport",
                        "longitude": -80.094206,
                        "latitude": 26.684474,
                        "id": "arp_pbi_us",
                        "icao_code": "KPBI",
                        "iata_country_code": "US",
                        "iata_code": "PBI",
                        "iata_city_code": "PBI",
                        "city_name": "West Palm Beach",
                        "city": {
                            "type": "city",
                            "time_zone": null,
                            "name": "West Palm Beach",
                            "longitude": null,
                            "latitude": null,
                            "id": "cit_pbi_us",
                            "icao_code": null,
                            "iata_country_code": "US",
                            "iata_code": "PBI",
                            "iata_city_code": "PBI",
                            "city_name": null
                        },
                        "airports": null
                    },
                    "conditions": {
                        "change_before_departure": {
                            "penalty_currency": null,
                            "penalty_amount": null,
                            "allowed": false
                        }
                    }
                }
            ],
            "payment_requirements": {
                "requires_instant_payment": false,
                "price_guarantee_expires_at": "2022-07-18T17:35:07Z",
                "payment_required_by": "2022-07-19T17:35:07Z"
            },
            "passengers": [
                {
                    "type": "adult",
                    "loyalty_programme_accounts": [],
                    "id": "pas_0000ALYXjoq2QJqaSUHP7a",
                    "given_name": null,
                    "family_name": null,
                    "age": null
                }
            ],
            "passenger_identity_documents_required": false,
            "partial": false,
            "owner": {
                "name": "Duffel Airways",
                "logo_symbol_url": "https://assets.duffel.com/img/airlines/for-light-background/full-color-logo/ZZ.svg",
                "logo_lockup_url": null,
                "id": "arl_00009VME7D6ivUu8dn35WK",
                "iata_code": "ZZ"
            },
            "live_mode": false,
            "id": "off_0000ALYXjp7lMQ1dLSZYkD",
            "expires_at": "2022-07-16T18:05:07.932169Z",
            "created_at": "2022-07-16T17:35:07.942911Z",
            "conditions": {
                "refund_before_departure": {
                    "penalty_currency": "GBP",
                    "penalty_amount": "60.00",
                    "allowed": true
                },
                "change_before_departure": {
                    "penalty_currency": null,
                    "penalty_amount": null,
                    "allowed": false
                }
            },
            "base_currency": "USD",
            "base_amount": "374.45",
            "allowed_passenger_identity_document_types": []
        },
        {
            "updated_at": "2022-07-16T17:35:07.942911Z",
            "total_emissions_kg": "460",
            "total_currency": "USD",
            "total_amount": "218.26",
            "tax_currency": "USD",
            "tax_amount": "33.29",
            "slices": [
                {
                    "segments": [
                        {
                            "passengers": [
                                {
                                    "passenger_id": "pas_0000ALYXjoq2QJqaSUHP7a",
                                    "fare_basis_code": "P20LGTN2",
                                    "cabin_class_marketing_name": "Premium Economy",
                                    "cabin_class": "premium_economy",
                                    "baggages": [
                                        {
                                            "type": "checked",
                                            "quantity": 1
                                        }
                                    ]
                                }
                            ],
                            "origin_terminal": "2",
4

@Jici
Yes, the payload is very long, but it is basically one ‘slice’ after the other. Below is the beginning slice to the second one.

5

And why do you need list shifter?

8

Do you have any idea how to solve such an issue? since i’m facing it too

So i have an api call that is sending a list back and i want to group the data in a RG but then grouping them by the second item alaways and it shows only the first one

9

Not sure what the question is, but for me I displayed the data from the API call and then I used dynamic data to select either :first item, :last item, or (in your case) :item #