=GET( )

The GET() function performs a simple get request, passing parameters in the URL (as part of the path or as query params), and fills one ore more columns in the same row.

It's parameters are listed bellow:

Parameter	Description	Example
URL Required	The URL of the API endpoint you are calling. If you wish to pass parameters in the URL, use `{paramName}` to detonate the place of the parameter. You can supply the parameter in the parameters section of the function call.	"https://investors-exchange-iex-trading.p.rapidapi.com/stock/{symbol}/book"
Select Path Required	This is the part of the returned JSON you want to pull into the sheet. The path should be detonated in JSON dot notation. For instance, given object `{a:{b:1}}`, to pull the value of `b` use the path `a.b`. If you want to pull multiple values, comma seperate them. Each value will be presented in a new column, based in the order they were supplied.	"quote.companyName,quote.latestPrice"
API Key Required	Your RapidAPI API key.
Parameter(s) Optional	For each parameter you wish to supply to the API, you should pass two arguments to the function - the `parameterName` and `parameterValue`. If the parameters apear in the URL path like `{parameterName}`, they'll be used there. Otherwise, they'll be attached as query parameters (`?parameterName=parameterValue`).	"symbol","AAPL"