Additional quesstion - would also love to know how to make the filterExpression able to call a cell reference. I tried concatenate, but wasn't able to get it to work. I'd like to have a column of defaultProfileURL values that I can then pull in the other values.
I should note it worked briefly, but now it doesn't seem to want to recognize the project that I just authorized.
Illest-Maestro
commented
5 years ago
The script briefly worked, but now I'm getting all of my results as #NAME?
JSON Url: https://phantombuster.s3.amazonaws.com/12AdE4Q3Tac/fJQhupwYkySafMnF3qf07w/search.json
Function:
=getjson(URLCellReference,{{firstName}},-1)
Additional quesstion - would also love to know how to make the filterExpression able to call a cell reference. I tried concatenate, but wasn't able to get it to work. I'd like to have a column of defaultProfileURL values that I can then pull in the other values.
I should note it worked briefly, but now it doesn't seem to want to recognize the project that I just authorized.