Forum Academy Marketplace Showcase Pricing Features

Create a thing in database from repeating group

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

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

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

coingecko

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:

image

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:


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

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

  1. Final result looks like this:

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.

thank you for taking the time to help!

Sure, happy to help.