Skip to main content

Is there a way to send bob information to an excel spreadsheet - via an integration or something?

  • Nov 14, 2023 8:39 AM UTC
  • 2 replies
  • 127 views
  • Translate All

Is there a way to set up some kind API integration to excel with the information from bob? 

For context, we have an internal ‘tracker’ on an excel spreadsheet which we use to track our ER cases and it’d be helpful to know if there is a way to send information from bob to this spreadsheet to automate updating some of the fields in that spreadsheet.

I’m thinking potentially something with webhooks but I really don’t have much experience with this and am not an excel wizz so do not know what’s really possible. 

2 replies

maksmith
  • Nov 15, 2023 1:57 PM UTC

What I usually do is create a specific report in Bob and then use the API to pull that report via its report ID into Excel. In Excel, you can use the Data tab in Excel to bring data in “From Web” and use the URL you can get from here. The Bob API page will let you fill in what you need and then generate the right link for you. You can also test it there to make sure it works.

 

You can use either your personal API key or create a service user and give that service user whatever permission group they need to see. I would recommend the latter :)

 

From then it is mostly just updating the sheet in Excel or via Power Query, but depends on how comfortable you are with that piece!

Translate

@maksmith Thank you! This is super helpful. I knew there’d be some kind of way to achieve this  -  I will have a go!

Translate