Forum Discussion
I would like to build (or better, find) a GraphQL API wrapper for jobber to let me export KPIs and events to a better dashboard. Or, to rephrase a bit, I wish Jobber did a better job at exposing a consistent interface for exporting jobs, clients, visits, etc. I found where I can batch export invoices, but somehow not visits? or Jobs? WHY?!?
Hey ActualJeff ! You can get a lot of this information in real time using Zapier to begin building out your own database using tools such as Airtable.
For the trigger events that aren't available (or if you have things like custom fields) you should use Adhesion Connect. **disclaimer - I'm the founder and developer behind Adhesion Connect
I put together a quick diagram below which is exactly how I have seen dozens of Jobber users achieve exactly what you are describing.
1) Event happens in Jobber
1.1) Data goes to Adhesion Connect (use this step if A, the event you're monitoring isn't available directly in Zapier; B, if you're using a platform other than Zapier that supports webhooks; or C, you want additional data from Jobber that isn't natively available through the Zapier integration)
2) Data is sent to your integration platform (Make, Zapier, etc.)
3) Data is then mapped to your table in Airtable where you
A flow like this is important because you want changes to update in real time and you want to avoid duplicate data. This is where event triggers for updated records are critical.
You can build what Airtable calls interfaces to visualize your data in a number of different ways.