NightDev Community
Ask on Discord

encoding foreign language in urlfetch

Asked May 1, 2023·2 replies·Last activity 3 years ago·Open in Discord ↗
Archived from the original community forum
Things may have changed since it was written. Still stuck? Ask the community on Discord.
Ask on Discord
Civil BatOriginal post

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)

2 replies

Polar Cat

Hey @Civil Bat!

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.

Civil Bat

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