Q:

Retrieve a subset of data using ImportJSON custom function

I'm using Trevor Lohrbeer's importjson() 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?

A:

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")

