Data not getting when search data using Text (String) from Google Sheet

[Greenway_Info]

Hi,

I am created Google Sheet and want to search records. If Type Numeric Text and search then it working OK. but searching data using by Text (String) then following error occurred.

Google Sheet

Code :

[Still-learning (1-2-3-4...)]

Search url much have gviz
Eg

Ref here

METRIC RAT AI2 - Use gviz to get and query google sheet data

Chnage the tq based on your search condition