Error with redash to googlesheets import function

Support Usage Support
#1

Hi! I am getting all data from redash imported into googsheets directly through the API Key > Results in CSV format: using the IMPORTDATA function.

While it worked for the time - it has started error and never worked second iteration onwards. Throws the “Resource at url not found” error - snapshot below

image

Could an expert in this group help me navigate or in point where there is an issue and how to fix it ?

Thank you

#2

Does the query use parameters by chance?

#3

That’s correct! They they do have parameters

#4

I see! You can’t use IMPORTDATA with queries that use parameters. Because the Redash API doesn’t allow you to GET results for parameterized queries. You need at least a POST request. IMPORTDATA only sends GET requests so they won’t work together.

It will work again if you remove the parameter from your query.

1 Like