How do I fetch data for app users offline / nightly?

Question

I want to build a Salesforce Marketing Cloud HubExchange app. The app will schedule a task periodically to process recent event tracking data for each user in the installed base.

How do I access event data for a specific user? What tokens or FuelSDK::Client parameters (I am using the Ruby FuelSDK, ideally) do I need to set?

I think I need to refresh the token from the JWT, but the FuelSDK::Client seems to want a JWT, not an oauth token.

Is there a code example or description for this process?

Relevant links:

• https://github.com/ExactTarget/FuelSDK-Ruby
• https://code.exacttarget.com/app-development/marketing-cloud-apps/single-sign-on.html
• Refresh Token request returning Unauthorized
• ExactTarget ClientID and ClientSecret for HubExchange App
• How do I contextualize the Fuel SDK to retrieve event data for a specific user?

Answer 1

My current solution is painful and complex, but I have nothing better. Not sure why this isn't well-trod ground, but... here goes.

• Build a database table to user store token data.

• Use my fork of FuekSDK-Ruby that supports a callback when the client chooses to refresh the token, and another when the refresh fails.

• Initialize the database data from data in the JWT passed by the user.

• Create the FuelSDK client with callback (and cache it, so you don't keep remaking them) and make it retry a few times if it ever has problems because someone else refreshed first.

See the attached gist for an implementation: https://gist.github.com/ses4j/6b38cd7bb391e8f41912

Answer 2

The Fuel Ruby SDK will create a client using:

myClient = FuelSDK::Client.new {'client' => { 'id' => CLIENTID, 'secret' => SECRET }}

The jwt is optional if you have it, for distributed apps - you would need to store the access token, and the refresh token in a data store to allow your app to grab the data it needs without a user login required during the update.