Has anyone tried integrating Google Spreadsheets with Podio?

[Simon B]

Hi,

I want to use Google Spreadsheets as a free corporate dashboard that
pulls it's data from Podio apps. I've been trying to authenticate
against Podio's oAuth2 interface using the UrlFetchServices classes
(OAuthConfig, UrlFetchApp, HTTPResponse etc.) in App Script.

I'm a little stuck!

Has anybody else out there attempted this before?

Simon

[kv]

Hi Simon,

Did you make progress on this? I am about to attempt this. I assumed (incorrectly) that this would be well-documented. If you have any pointers or suggestions, I'd greatly appreciate it!\

Kv

[Drew Hawken]

I will be trying this as well Simon and Kv, if either of you have made any headway I would appreciate it.

[Friedger Müffke]

With the new changes announced at Google I/O it would be even more interesting to see some pro looking into it.

I fail with an "Unexpected error" if I run this code in a standalone app

function getApps(){

    var txt = UrlFetchApp.fetch("http://api.podio.com/app/v2/", podioOAuth_()).getContentText();

    Logger.log(txt);

}

function podioOAuth_() {

 var oAuthConfig = UrlFetchApp.addOAuthService("podio");

 oAuthConfig.setRequestTokenUrl('https://podio.com/oauth/authorize');

 oAuthConfig.setAuthorizationUrl('https://podio.com/oauth/token?grant_type=authorization_code');

 oAuthConfig.setAccessTokenUrl('https://podio.com/oauth/authorize?response_type=token');

 oAuthConfig.setConsumerKey('MY_CLIENT_ID');

 oAuthConfig.setConsumerSecret('MY_CLIENT_SECRET');

 return {oAuthServiceName:"podio", oAuthUseToken:'always'};

}

  

Any insight?

Cheers

Friedger