Blog Posts BPMN DMN

Using Dashbuilder with Google Spreadsheets

Blog: Drools & jBPM Blog

Dashbuilder can read from JSON and CSV contents. The only requirement is to make the file accessible to the machine where Dashbuilder is running. The issues you may face are:

- uuid: my_dataset
    Authorization: Bearer {token}

For Google spreadsheets we don’t have to worry about CORS or authentication as long as the document is published on the internet. 

Steps to read a Google Spreadsheet  from Dashbuilder${sheet_id}/gviz/tq?tqx=out:csv&sheet=${sheet_name}

In our example here’s the final URL:

  sheet_id: 1XuyPTyrjMFXQ1ey6Bg9AEcrpwZ60CnLQVEs4-DEDrcc
   - uuid: sheet
   - components:
         - settings:
               type: BARCHART
                   uuid: sheet


You can edit this same example using our online editor.


Dashbuilder can easily integrate with Google Spreadsheet and other documents available on the internet. Stay tuned for more Dashbuilder tutorials and articles!

The post Using Dashbuilder with Google Spreadsheets appeared first on KIE Community.

Leave a Comment

Get the BPI Web Feed

Using the HTML code below, you can display this Business Process Incubator page content with the current filter and sorting inside your web site for FREE.

Copy/Paste this code in your website html code:

<iframe src="" frameborder="0" scrolling="auto" width="100%" height="700">

Customizing your BPI Web Feed

You can click on the Get the BPI Web Feed link on any of our page to create the best possible feed for your site. Here are a few tips to customize your BPI Web Feed.

Customizing the Content Filter
On any page, you can add filter criteria using the MORE FILTERS interface:

Customizing the Content Filter

Customizing the Content Sorting
Clicking on the sorting options will also change the way your BPI Web Feed will be ordered on your site:

Get the BPI Web Feed

Some integration examples