Do wildcards (*) not work in Column paths? Or am I being stupid...

qeet / IMPORTJSONAPI

Use JSONPath to selectively extract data from any JSON or GraphQL API directly into Google Sheets.

MIT License

252 stars 36 forks source link

Do wildcards (*) not work in Column paths? Or am I being stupid... #36

Open kaidejager opened 3 years ago

kaidejager commented 3 years ago

Trying to pull using this formula: =IMPORTJSONAPI("https://www.espn.com/nfl/schedule/_/year/2021/week/1?xhr=1", "content.schedule.*", "games.*.date")

But keep getting "ERROR: unexpected character in column path: '*.date'". Have tried with brackets and on a different URL earlier. I swear this used to work.

qeet commented 3 years ago

Sorry but there is no support for wildcards in column paths.