#NAME?

[Illest-Maestro]

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.

[Illest-Maestro]

Resolved!