hopar
1
Hi, Im currently trying google api to change data from google sheet.
however when I use urlfetch, I can’t use any languae other than english to run the code.
it runs well if I run it on the browser.
I tried using querystring to evade the errors but it seems like its not working as well.
would there be any insights to encode a foreign language in urlfetch?
$(urlfetch https://sscript.google.com/macros/s/GOOGLE_STRING/exec?ID=$(querystring $(user))&Nickname=$(querystring$(touser))&Prize=$(querystring(상품))&use=true)
Emily
2
Hey @hopar!
I think your issue is the lack of spaces in your $(querystring)
s, here’s a fix I think should help:
$(urlfetch https://script.google.com/macros/s/LONG_RANDOM_GOOGLE_STRING/exec?ID=$(querystring $(user))&Nickname=$(querystring $(touser))&Prize=$(querystring 상품)&use=true)
Let me know if that’s enough to fix your problem, otherwise we’ll try something else.
hopar
3
Thank you so much! its working now. Im quite new to this and it helped me a lot.
1 Like
system
Closed
4
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.