CODEWITHSUNDEEP
jsongoogle-apps-scriptgoogle-sheetscustom-function
bramwell2010
bramwell2010

Reputation: 175

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?

Upvotes: 0

Views: 2518

Answers (1)

Aurielle Perlmann
Aurielle Perlmann

Reputation: 5509

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

Upvotes: 3

Related Questions