Create a thing in database from repeating group

[ammanahmed2004]

I’m trying to push all crypto prices from my repeating group into the database as separate things. I am unable to figure out how to do it.

I’m doing it via a repeating group because all the data ends up in one line when i call the API directly to the db, and there doesn’t seem to be a way to iterate through that…

Help would be appreciated

[Sarah_Biberei]

Doing the same thing at the moment. Which API are you using?

[na811]

This plugin might help, lets you run actions on each cell in an RG

Orchestra (repeating group addon) Plugin for Bubble, by Vinicius Brito from UB...

[ammanahmed2004]

coingecko

[Sarah_Biberei]

Yeah, did the same.

So what I did (don’t know whether this fits to your requirements).

My goal was to rebuild that view: Kryptowährungspreise, Diagramme und Marktkapitalisierungen | CoinMarketCap

So I needed the current data, the list of all 100 cryptos which are listed on this view and the historic data of the last 7 days.

I took the first api: https://api.coingecko.com/api/v3/coins/markets to just display this in my repeatingroup.

I created a backenworkflow which creates a new entry for every historic data with this API: https://api.coingecko.com/api/v3/coins/[id]/market_chart

I created my own diagram and display the trending charts of the last 7 days:

As you only want to save the data from this API https://api.coingecko.com/api/v3/coins/markets (that’s my assumption from your screnshots) you would need to do the following:

1. Create Backend Workflow to create new thing (your crypto). I only used name and price, please adapt:

2. Create another workflow which contains the list of the cryptos you want to create
   
   

3. Place a button (or whatever to let the workflow run) I used a button;

4. Final result looks like this:

[Sarah_Biberei]

Please adjust this to your needs. I just saw that I don’t want to have this as external API. This is just for testing purpose.

[ammanahmed2004]

thank you for taking the time to help!

[Sarah_Biberei]

Sure, happy to help.