Set up an OAuth service¶

Tapestry uses OAuth to retrieve survey responses from Google Docs/Drive spreadsheets.

Generate a private key and certificate¶

Example:

openssl req -x509 -nodes -days 3650 -newkey rsa:2048 -sha1 \
 -subj '/C=CA/ST=BC/L=Spillimacheen/CN=YOUR.TAPESTRY.HOSTNAME' \
 -keyout oauth_rsa_key.pem -out oauth_rsa_cert.pem

• See https://developers.google.com/gdata/docs/auth/authsub?csw=1#Registered

Register and configure your domain¶

Assure Google that you control the domain name where your Tapestry installation lives.

https://accounts.google.com/ManageDomain

Set target URL path prefix to: https://YOUR.TAPESTRY.HOSTNAME/oauth/update

Your "manage domain" page should show an OAuth Consumer Key (your domain name) and an OAuth Consumer Secret (an indecipherable alphanumeric string).

Click save.

Set up a new OAuth service¶

https://YOUR.TAPESTRY.HOSTNAME/admin/oauth_services/new (Admin→OAuth Services→New)

Enter the name: Google Docs

Enter the scope:

https://docs.google.com/feeds/ https://spreadsheets.google.com/feeds/ https://docs.googleusercontent.com/

Copy the consumer key from Google

Copy the private key from the oauth_rsa_key.pem file you created above.

Test authorization¶

https://YOUR.TAPESTRY.HOSTNAME/oauth_tokens (Researcher→OAuth Tokens)

Click the Authorize button for Google Docs.