bramwell2010 bramwell2010 - 1 month ago 10
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:

=importjson("http://www.pgatour.com/data/r/stats/current/102.json","This","AndThis")


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

Answer

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

=QUERY(importjson("http://www.pgatour.com/data/r/stats/current/102.json"),"select Col5, Col22, Col23, Col24, Col27, Col28, Col29, Col30")