Hello
Im trying out bubble at the moment and am therefore trying to build a small crypto portfolio tracker.
At the moment im trying to integrate the Coingecko API to get some data about the market, and thus far im getting the prices of a lot coins without problems. Now i wanted to get the prices of the last 7 days of each coin, saved in this datastructure:
Where i want “asset” to point to the corresponding cryptocurrency (e.g. Cardano) and price/timestamps to be two lists where e.g. the 5th element in “price” is the price that Cardano had on the 5th timestamp. (i thought this might be a good way to save this information?).
The API call and result looks like this (screenshot from coingecko’s doc):
and i also get this result in bubble as you can see here:
As you can see in the result each entry represents 2 values, the timestamp (UNIX) and the price. I would like to get each of them in their own list, but cant get that to work as i only have this option:
and therefore end up with values like:
1629716422223, 2.8117550861033367
1629720072520, 2.8261194230304287
tldr
What i get:
What i want:
Is there an easier way than copying all the data in a buffer list and when that is done copying every 2nd item into their real list? Is there a way to extract the data directly into their own column?
Greetings