How to find latitude and longitude of Addresses using Uipath

Help
,
1

I have some Addresses in Excel sheet.Address.xlsx (8.5 KB) I want to extract longitude and latitude for those. There is a website known as GeoCodio which is used to extract longitude and latitude manually.

Screenshot (134)
Screenshot (134)1906×947 80 KB

But I want to extract this latitude and longitude using Uipath. And these are the steps I follow to extract Latitude and longitude from “geocodio” website. First I will click on “New Upload” here
Screenshot (136)
Screenshot (136)1918×965 106 KB

Next I will select “Drop your spreadsheet here” and I will drop my excel spreadsheet. Select “Continue” button and after that select “preview”, check the location and confirm that it looks good if it is correct. The last step is finalizing, and its done. Now go to past uploads and download the excel file. So, this excel sheet contains Latitude and Longitude values .In this way, we can get the latitude and longitude values. Now this process I want to do using Uipath.I know that we can use Screen scraping for that,but I want any other method to do this.Can anyone please suggest me some idea on this.

2

@Kavyasri

I see the website is for US and Candian address, As your address is an Indian address will those work?

Also instead of going by GUI steps it’s better to create API key and check the documentation of API calls

That will be faster and background solution

Hope this helps you

Thanks

1 Like
3

Actually I will take US addresses only… For understanding purpose, I gave the Indian address in the excel sheet here. Your suggestion looks good. Can you please share any sample workflow on that

4

@Kavyasri

I didn’t work earlier with the geocodio site and i don’t have access to the api also,

Also i believe it is a paid website, maybe you need to purchase the credits to access there api

So check that

Thank you

5

okay. Today I created new account in that website, its free of cost for first 2500 Addresses per day actually…

6

@Kavyasri

Okay then create the API key and using the documentation, you can make the API call

For API call refer below

Hope this helps you

Thanks

1 Like
7

ok…Thank you

8

Other than this geocodio, Is there any other method to extract Longitude and latitude of an address using Uipath?

9

@Kavyasri

Maybe you can try with maps.google.com

Once you pass the address, the url of the maps.google.com will turns to latitudes and longitude

check below for your reference

image
image2038×748 417 KB

so that you can parse the value

Just giving you a idea

Hope this may helps you

Thanks

1 Like
10

Hi @Kavyasri,
Refer below link , convert to uipath custom activity

https://www.nuget.org/packages/GoogleMaps.LocationServices

Regards,
Arivu

11

Thanks for the reply… this link is not working. Getting like this

Screenshot (138)
Screenshot (138)1896×950 66 KB

12

@Kavyasri, please check now.

13

thank you, its working now