I'm totally new to this stuff. Never even heard of json/api/etc three days ago. Basically, I'm using the google sheets formula "=ImportJSON("https://universalis.app/api/Primal/7024")" to import data. However, there's almost 4000 cells worth of data in there and I only want about 10-20 cells worth of that. How can I narrow down what data it sends? These are the only cells I want info from D2-D12. I assume I can adjust the formula after if I want, say, D2-D22 instead. Thank you.
1 Answers
If your ImportJSON is from this, how about the following modified formula?
Modified formula:
=QUERY(ImportJSON("https://universalis.app/api/Primal/7024"),"SELECT Col4 LIMIT 21 LABEL Col4 ''")
and
=QUERY(ImportJSON("https://universalis.app/api/Primal/7024","/listings/pricePerUnit","noHeaders"),"SELECT * LIMIT 21")
Result:
Related