Bubble limitation - Iteration?

Questions
1

I have a JSON payload that I need to loop through:

The below JSON payload is a description of a return trip --> London - New York - San Francisco <–

{
  "items": {
    "-size": "4",
    "flight": [
      {
        "details": {
          "-number": "52",
          "-airline-code": "EY"
        },
        "departure": { "name": "London Heathrow Airport" },
        "arrival": { "name": "New York JFK Airport" }
      },
      {
        "details": {
          "-number": "8704",
          "-airline-code": "EY"
        },
        "departure": { "name": "New York JFK Airport" },
        "arrival": { "name": "San Francisco Airport" }
      },
      {
        "details": {
          "-number": "269",
          "-airline-code": "EY"
        },
        "departure": { "name": "San Francisco Airport" },
        "arrival": { "name": "New York JFK Airport" }
      },
      {
        "details": {
          "-number": "51",
          "-airline-code": "EY"
        },
        "departure": { "name": "New York JFK Airport" },
        "arrival": { "name": "London Heathrow Airport" }
      }
    ]
  }
}

As you can see, it has multiple arrivals and multiple departure.

How do I define the bubble endpoint logic for iterating through this without code so that multiple flights are created in the database.

Or, is there a bubble limitation - we cannot iterate through a JSON file?

I’m using the bubble Open App and my API workflow endpoint “trip” is available to everyone as also the associated workflow to create a flight.

Thanks !

2

It’s not something we support yet, but we could add that on a sponsored basis.

3

What if the JSON file was an Excel spreadsheet?

4

Hi Emmanuel,

Thanks for your feedback.

Two questions:

  1. Is this feature on the platform road map? I’m guessing that it very similar to what already exists for the standard bubble integration with Giphy or Etsy. Each of these external endpoints returns structured data to bubble which displays them in a repeating group in bubble. The only difference here is that I - as the user - I can define the which data elements to parse and how .

  2. How does the sponsorship work? Would I define my requirements, bubble develops it as a platform feature, releases it. As a result I along with all other users can use the feature as it is beneficial to everyone? Since it is a sponsored feature, I guess I would have to pay for it?

Cheers.

5

It is on the roadmap, but pretty much anything users ask for… Sponsoring gives a way for people to change the priority list if not enough users ask for the same thing at the same time.

Yes, that’s pretty much how sponsoring works.

1 Like