API, symbols column and user locale

Etienne Mermillod

Hi,

Let's say a german coworker that created a sheet and is using symbols. These symbols are in german as well, while my locale is in english.

Using the API, i can't detect that the sheet was created with a different language and thus can't detect that "Grün" stands for "Green" and makes the update with the API quite difficult.

Is there any tips, or possible paramter to indicate to the API that i want to read/update the sheet in a specific locale ?

Genevieve P.

Hi @Etienne Mermillod

This will be based on the sheet owner's locale, as you've noted. You could either look up the user and observe their 'locale' setting,

or you could make a map of:

"Green": {
    "Grün",
     "Verde",
     "Vert"...
}

Cheers!

Genevieve

Etienne Mermillod

If the user create a sheet with one locale then changes to a different one the solution describbed above doesn't work.

Thus, I need to map all symbols...