Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Download Tool: JSON data returned is in Native Language not English

choward
7 - Meteor

I have an on going workflow I have been building for the last 3 months and it literally makes me want to throw alteryx out the window.

 

My client has to process hundreds of thousands of international addresses at a time, multiple times per day. These addresses are not standardized, come from different entities, and different countries. They are not formatted. I have to put them through a specific API with OSM.org for geocoding. the problem is that the display name comes back in the native language of that address. How do I ensure that the data comes back in English so I can pull the entire JSON apart and verify the data points to push it forward thru the workflow?

1 REPLY 1
DavidSkaife
13 - Pulsar

Hi @choward 

 

Having had a read through the Nominatim documentation https://nominatim.org/release-docs/latest/api/Lookup/ you can override the preferred language - add the below to the Download tool Header:

DavidSkaife_0-1673468999920.png

 

your output goes from

DavidSkaife_2-1673469081204.png

 

 

to

DavidSkaife_1-1673469048538.png

 

Labels