Discussions
The plugin does not work anymore
Unfortunately it seems that the plugin does not exist anymore.
I was using it quiet often, however I can't find it anymore in the google workspace marketspace and the function getarr does not work anymore.
Does anyone know what happened?
thank you for you help
Posted by PP Hekking 23 days ago
GETARR and API-FOOTBALL
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
]
}
}
Posted by Danny Mijnendonckx over 1 year ago
Getting Arrays - Result in the root
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"
Posted by Martijn almost 2 years ago