API search + textbox (not sure if this is a complicated problem)

Need help APIs
1

here is my situation in a very granular format.

What do I have on my application?

I have a search bar for address, a button, GOOGLE MAP and Energy and Water Data API from NYC Open Data website.

image
image935×803 174 KB

What do I want to accomplish?

Energy and Water Data API has water consumption data for various addresses in New York City.
I want to be able to search an address in my search bar and then,

  1. GOOGLE MAP LOCATES THAT ADDRESS
  2. TEXTBOX BELOW THE MAP SHOWS ME THE WATER CONSUMPTION VALUE BELOW THE MAP

Why am I having a trouble?

I am not too sure how I need to modify the textbox (or something else) so that it receives the address data from the search bar, go through the JSON list of Energy and Water Data, finds the address and return the water consumption data that matches with the address - or is that even possible?

here is the link for the Energy and Water data API
https://dev.socrata.com/foundry/data.cityofnewyork.us/qb3v-bbre

thank you very much

2

Do you have the ability to add a collaborator? iI have set up a test in my app and it works just curious if it will work for you. You can PM me if you like.