Discussions

I;m using de GETARR function, but the result is in the root. Which arguments should I use? For example: [ 0: { "Name": "First" }, 1: { "Name": "Second" } ] What should be the 2nd argument of the GETARR function? When I use =GETARR("https://names.p.rapidapi.com/stock/get-names","","Name", "MY-API_KEY") I get the error: "arrPath argument must select an array, selected a value of type string"

Hi, I try to get all the seasons that in a Google Spreadsheet but I can't manage it. Defining the arrPath which is api.seasons is no problem but I have no selectPaths. It consist out of a list starting from 0 to 15 (see below). How do I get the result in the Spreadsheet? Thx {1 item "api":{2 items "results":15 "seasons":[15 items 0:2008 1:2009 2:2010 3:2011 4:2012 5:2013 6:2014 7:2015 8:2016 9:2017 10:2018 11:2019 12:2020 13:2021 14:2022 ] } }