bramwell2010 bramwell2010 - 1 year ago 217
JSON Question

Retrieve a subset of data using ImportJSON custom function

I'm using Trevor Lohrbeer's

custom function to import some data from this JSON source into a Google Sheet.

I don't want all of the information provided; I specifically only want columns E, V, W, X, AA, AB, AC, AD.

I tried a few things before realizing I have no idea what I'm doing with this parameter:


How can I modify this function to retrieve only the items mentioned above?

Answer Source

You can do this easily using the QUERY function, post-filtering the results of the importjson() call.:

=QUERY(importjson(""),"select Col5, Col22, Col23, Col24, Col27, Col28, Col29, Col30")
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download