nexo | Preact apps with Deno | Server Side Rendering library

when I query the api, I get a response like this

(of course many other items):

{ "quick-nexo-eth": { "vaultApr": 4.226980461491351, "compoundingsPerYear": 2190, "beefyPerformanceFee": 0.045, "vaultApy": 67.23150416911541, "lpFee": 0.003, "tradingApr": 0.032865666659524465, "totalApy": 69.47397804081551 },

"quick-qi-quick": { "vaultApr": 244.9061731630718, "compoundingsPerYear": 2190, "beefyPerformanceFee": 0.045, "vaultApy": 6.659993754798221e+100, "lpFee": 0.003, "tradingApr": 0.0919483717454164, "totalApy": 7.27236933638656e+100 } }

for each item, I would like to add the name (ie "quick-nexo-eth") and value of "totalApy" to a list so that I have a list that shows only name and totalapy, ie

my_list=[("quick-nexo-eth",69.47),("quick-qi-quick",7.27)]

some items in the list don't have the "totalApy" at all, so have to take that into consideration. any help is apreciated. thx :)

I'm trying to fill a dictionary using scraped data from a web site, I get the data, then I assigned it to the dictionary, when I print the dictionary the data shows up. I haven't been able to access only one row of the dictionary, what am I missing?

Here is the code:

I want to create a new json file from the variables which are fetched from another json. I am a beginner with jq.

I'm trying to add electron to my angular project but it just gives me white screen. I looked up tutorial how to add it to angular but none of them worked.

Here is my main.js which is located: my-app/main.js

I'm trying to create multiple dependant dropdown lists that filter a data set inside Google Sheet.

The "Rate Filter Basic" tab works the way I expect it to, without creating an ArrayFunction to replicate the dropdowns.

The "Rate Table" tab is the data source I'm filtering.

The "Rate Filter Adv" tab is where I'm trying to create an ArrayFormula that will auto populate the deeper levels of the dropdown lists. I have been learning that not all functions allow me to nest ArrayFormula or AND OR clauses inside them.

The tabs with "" are where I have rebuilt the dropdown data for each list. "Payments" has a highlighted cel with the "NEXO" which should not be there.

Where I have come unstuck, is on the "Payment" Dropdown, that is dependant on the first 2 (Service, Token). On the "Rate Filter Adv" tab, the cel D5 should only have "In-Kind" as a result. Not In-Kind and NEXO.

I'm open to completely new ways to solve this.
I'm trying everything I can. Currently looking at QUERY, but I'm working through the ArrayFormula, AND, OR, limitations on that too.

DEMO SHEET

https://docs.google.com/spreadsheets/d/1rcWYgNeAXE8mEb43m0Jf50cQ9U9ntA0yd8znXAi5kMU/edit?usp=sharing

Thank you.