DeepL translator API

[katieG]

Hi!

I'm new to using APIs with Alteryx and am trying to do a test using the DeepL translation API.

I have an excel file where column A is my English language.

My goal is to take these rows of English phrases and output other languages by using the DeepL API. 

I have my DeepL authentication key and think I set up the preliminary workflow properly but then I'm lost...

How do I connect my excel file? How do "tell" DeepL what I need? 

Appreciate any help!

[dougperez · Accepted solution]

Hello @katieG 

I did a macro to help you with this, see the workflow attached.

I read the documentation of the API and created the URL based on which field is mapped and which language is selected, feel free to use!

[katieG · Accepted solution]

WOW. Okay... NOW I understand how APIs are working. 😀Thank you so much!!! It's clear you spent a lot of time reading the API documentation to configure the macro perfectly. Can't thank you enough.

[Co]

Hello,

Thanks for the macro.

Working well except for greek characters.

Do you know how can I handle such kind of translation with you macro ?

Thank you