API to get city and states from zip codes

[Anonymous]

Hi,

I have a table with various Zip codes of country India, I have city and state columns but most of them are blank. Now I want an API which could get me a table which has all the Indian Zipcodes and their respective cities and states so that I canhave the full information. I am a beginner in Power Bi and never use APIs before, please help!

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for reaching out to us. 

I find a related post Lookup City and State by Zip Google Geocode Api, the accepted answer in it says you can

"Use the GeoCoding API

For example, to lookup zip 77379 use a request like this:

https://maps.googleapis.com/maps/api/geocode/json?address=77379&sensor=true&key=YOUR_GOOGLE_PLATFORM_API_KEY"

Link: https://stackoverflow.com/questions/4749706/lookup-city-and-state-by-zip-google-geocode-api

Just take a try.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.