Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our User Agreement and Privacy Policy.

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. If you continue browsing the site, you agree to the use of cookies on this website. See our Privacy Policy and User Agreement for details.

Working with api in OpenRefine

Thousand of services, from translation or text analysis to mapping or URL shortning are now available through API. However if you are not a developer to integrate the API to your workflow you won't be able to process or enrich your data. Good new, with OpenRefine this is no longer the case!

Using the Add Column by Fetching URL you can easliy query those services. We will review how to find API, to query them and parse the result in Refine with various examples and usage type.

Working with api in OpenRefine

1.
Working with API in Refine - @magdmartin 1
Working with API

2.
Working with API in Refine - @magdmartin 2
Next Meet Up
● Next Meet Up
– April 21- 6PM – 7.45PM
– May 21 - 6PM – 7.45PM
– June 18 - 6PM – 7.45PM
● Pool
– Use Case Presentation and learn how other use
Refine
– Learn a specific set of functionality
– Hack session where everybody come with a laptop
data to clean.

3.
Working with API in Refine - @magdmartin 3
Working with API in Refine
● What is Refine?
● What is an API?
● How to make API call?
● Hands On!

6.
Working with API in Refine - @magdmartin 6
What is an API?
● Each API provider is like a restaurant:
– Menu = API
– Placing an Order = Executing an API Call
– Different food on the menu = Parameters
– Food = the System's Response
● Each API have their own rules
– Need to register (or not)
– How frequently you can make a call
– GET or POST request (Refine support only GET)
– Price and Service Level Agreement
● See Mashape or ProgrammableWeb to discover API

7.
Working with API in Refine - @magdmartin 7
Example of API Provider
everythinglocation
Verify and Geocode
Address Data
● Give an address string
● Returns a validated,
parsed and geocoded
address
Timezonedb
free time zone database
for cities of the world
● Give a lat/long
● Return timezone and time

8.
Working with API in Refine - @magdmartin 8
Making API call
Everythinglocation
API address key Verify &
Geocode
Country
https://saas.loqate.com/rest/?lqtkey=[APIKEY]&p=v%2Bg&ctry=USA&addr=1111%20bayhill%20drive%20san%20bruno
Address
Documentation
I'd like the following address
cleaned, parsed and its long / lat
1111 Bayhill Drive San Bruno