IMPORTDATA function get html result

when using importdata function to import data from redash to google sheet
i got result like that

It looks like you have cloudflare in front of your Redash instance. So the network request from google is never reaching Redash. This is something you’ll need to configure with cloudflare as it’s unrelated to Redash.

what about if the query am trying to read have parameters ? is it have another technique to read directly in Google sheet or still not supported yet ?

That would only work if a cached result is already available. There is no synchronous API for fetching query results in Redash. It simply isn’t feasible due to the unknown time required to execute your query.