# Calling a Rest Service and extracting the json returned

**URL:** <https://forum.cloverdx.com/t/calling-a-rest-service-and-extracting-the-json-returned/836>\
**Category:** CloverDX Platform\
**Created:** [April 8, 2011, 12:00am UTC](https://forum.cloverdx.com/t/calling-a-rest-service-and-extracting-the-json-returned/836 "2011-04-08T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jstrauss](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@jstrauss](https://forum.cloverdx.com/u/jstrauss)\
**Post date:** [April 8, 2011, 12:00am UTC](https://forum.cloverdx.com/t/calling-a-rest-service-and-extracting-the-json-returned/836/1 "2011-04-08T00:00:00Z")

</div>

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](http://maps.googleapis.com/maps/api/geocode/json?address=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

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [April 8, 2011, 11:30am UTC](https://forum.cloverdx.com/t/calling-a-rest-service-and-extracting-the-json-returned/836/2 "2011-04-08T11:30:10Z")

</div>

Hello Jay,  
CloverETL does not support JSON objects directly, but it is easy to process with [JSON in Java](http://www.json.org/java/index.html) in Reformat component (see [JSON mapping support](http://forum.cloveretl.org/viewtopic.php?f=4&t=3803) topic).
