How do I set up the Table API to get values in both languages

[Perry4]

I am using the Table API of ServiceNow. When the interface calls the tableAPI, I can only get the default language value of the interface account. However, I want to get both Chinese and English values. Is there anything I can do?

[Ankur Bawiskar]

Hi,

not possible; it takes language of the user you are using for API

Querying using another language is not supported in TableAPI.

Regards
Ankur

[Ankur Bawiskar]

@Perry

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

[Hitoshi Ozawa]

Hi Perry,

To get the result in different languages, would need to write a Scripted REST API. Scripted REST API can execute a script that will get the results in different languages and then the result can be merged in the response body.

https://docs.servicenow.com/bundle/rome-application-development/page/integrate/custom-web-services/c...

[Hitoshi Ozawa]

BTW, Table API will always return values in English.

The request will always be for the english table even if the display language is in another language

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0870540

I've tested this. My instance is in Japanese so if I use the REST API Explorer, the label of the