Earlier this month, @rando and I sat down and figured out how to pipe data from stripe into our CRM, LittleGreenLight.
After a bunch more poking and prodding the stripe and LGL APIs (wtf when did they introduce Invoices?), I’ve come up with this script:
I’ll be installing it on unicorn and setting it to run in a daily cron. When it runs, it creates a number of entries in the “Integration Queue” in LGL which allow for manual approval of the data. At some point we can turn off the manual approval step and let this sucker run forever.
The step after this is to setup a system where we all check LGL frequently and use the Gift Acknowledgement flags to send a thank-you e-mail to people and track who has responded to which donation.
The LGL API is frikkin weird as hell and I might be doing it wrong, but this works for now. Its goofy because you don’t actually do CRUD operations like “create this gift” “update this person’s list of donations”; instead, you POST a bunch of data to a URL, then configure some maps that translate those POST parameters into LGL fields, then review that your fields match up for each record and approve it.
But thank god it isn’t SOAP.