Build a Crypto Portfolio Tracking App: Part 6 - Persist API Data to Prevent "Error!"

In part 6 we solve for an issue where price data and asset names are unavailable if the coinGecko API has a timeout. This video will show you how to setup a table to store the API data using a scheduled automation.
------------------------------------------------------------------------------------
Crypto prices API endpoint
api.coingecko.com/api/v3/coin...{ids}
Google Sheet importJSON() Formula Used in this Video:
=importJSON("api.coingecko.com/api/v3/coin..."&join(",",unique(Assets!C2:C)))
CoinGecko API Documenation:
www.coingecko.com/en/api
importJSON() Github: gist.github.com/paulgambill/c...
------------------------------------------------------------------------------------
This is a series where we build a Crypto/Stock Portfolio tracking app from scratch. The helps users efficiently track Bitcoin, Ethereum, and stock market assets prices and networth. This video teaches advanced concepts such as creating change logs, retrieving information from APIs.
Template app that you can copy for your personal use: www.appsheet.com/templates/cr...

[@SufiShahHamidJalali]

Hey Rich!
Is it possible to build a wallet with for cryptocurrency appsheet? For example, if I have some tokens in Stellar and want to create a wallet for them so users can send and receive them. Is it possible?
Thanks for your other videos.

[@appify]

Technically you could probably create something using Appscript or an API management tool and leveraging blockchain APIs. However I would not recommend this since there is no good way to safely store the keys. It would be very dangerous for real funds.

[@SufiShahHamidJalali]

@@appify
Thanks for the clarification. What is your suggestion in building such wallets using a no-code platform? I mean do you have any option in mind?