Calling a Rest Service and extracting the json returned

CloverDX Platform
1

Hi,

I have a file of addresses. With Addr1, Addr2, City, State, Zip

They’re a bit messy with tokens out of order, not proper abbreviations… I’d like to take each address and bump it up against google’s map api:

http://maps.googleapis.com/maps/api/geo … s=Acillies 20424 olympi fields IL 60541&sensor=false

(try it, it does really nice address fixing and standardization).

The result is JSON, and I’d like to parse out the component address pieces.

I’m guessing its possible in Clover, but I have no idea of where to start (outside of the universal data reader).

I can whip it off in Perl, but I’d like to learn how to do it in Clover.

Can anyone show me the way?

Thanks
Jay

2

Hello Jay,
CloverETL does not support JSON objects directly, but it is easy to process with JSON in Java in Reformat component (see JSON mapping support topic).