20140527 apicon sf - workshop #1 - spreadsheet to custom api
DESCRIPTION
1) Overview of APISpark (5’) 2) Google Spreadsheet wrapper (5’) 3) Hands-on lab (40’) - Sign in to APISpark - Prepare the Google Spreadsheet - Create the Data Store wrapper - Export the Custom Web APITRANSCRIPT
TURN YOUR GOOGLE SPREADSHEET
INTO A CUSTOM API
Full stack PaaS for web APIshttp://apispark.com
May 27, 2014
PRESENTERENTREPRENEUR AND WEB API EXPERT
Jérôme LOUVEL CEO of Restlet
12 years of experience in software (EU and US)
Restlet Framework creator (2005)
JAX-RS 1.0 expert in JCP (JSR-311)
Contributor to “RESTful Web Services” (O’Reilly)
Co-author of “Restlet in Action” (Manning)
Contact
Twitter : @jlouvel
Blog : blog.restlet.com
AGENDA
1) Overview of APISpark (5’)
2) Google Spreadsheet wrapper (5’)
3) Hands-on lab (40’)– Sign in to APISpark
– Prepare the Google Spreadsheet
– Create the Data Store wrapper
– Export the Custom Web API
1) OVERVIEW OF APISPARK
WEB API PROJECTTYPICAL LIFE CYCLE
Create Host Manage Use Promote
1) Do It Yourself (DIY)
long, risky, expensive but highly flexible
2) Platform as a Service (PaaS)
integrated, fast, cost effective
APISPARK PLATFORMAVAILABLE IN PUBLIC BETA
Send us your feed-back and help us making it the best PaaS for Web APIs !
COMPOSING APISPARK CELLS
Entity Store File Store
Custom API
Java iOS JS
HTTP HTTP
STRUCTURE OF WEB APIS
API Contract
Implementation
Runtime
Web API
template
Completeweb API
HTTP HTTPS
SOCIAL LOGIN
YOUR DASHBOARD
ENTITY STORE CREATION
ENTITY PROPERTIES
2) GOOGLE SPREADSHEET WRAPPER
REEXPOSING A SPREADSHEET
Entity Store
Custom API
HTTP HTTP
Google Spreadsheet
MAPPING TABLE
Google Docs APISpark
Spread sheet Entity Store
Work sheet * Entity *
Column * Entity property *
First row Entity property names
Next rows Entity instances
FEATURES
Work in both read and write modes– your data always stays in sync
Your data can be updated– directly in the Google Spreadsheet
– via the Custom Web APIs
Additional security layer– your main Google password isn’t exposed
– you control who has access to the custom API
3) HANDS-ON LAB
YOUR STEPS
1. Prepare the Google Spreadsheet
2. Configure the Entity Store Wrapper
3. Deploy the Web API
4. Invoke the Web API
Follow this detailed tutorial
– https://apispark.com/docs/tutorials/google-spreadsheet
1. PREPARE THE GOOGLE SPREADSHEET
2. CONFIGURE THE ENTITY STORE WRAPPER
ENABLE 2-STEPS AUTHENTICATION !ON YOUR GOOGLE ACCOUNT
TEST YOUR GOOGLE CREDENTIALS
IMPORT A SPREAD SHEET
UPDATE WORK SHEETS
ADD ENTITIES
DISPLAY WRAPPED ENTITIES
UPDATE MAPPING IF NECESSARY
DEPLOY YOUR ENTITY STORE
3. DEPLOY THE WEB API
DISPLAY EXPORTED CUSTOM API
DEPLOY THE CUSTOM API
4. INVOKE THE WEB API
KEEP IN TOUCH!
http://restlet.com
http://blog.restlet.com
Twitter: @jlouvel
Leading web API platform for Java