encoding foreign language in urlfetch

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)

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.

Thank you so much! its working now. Im quite new to this and it helped me a lot.

1 Like

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.