◷ Reading Time: 5 minutes
Following two options are available to connect your source to the Booklet.
- Connect Models
- Connect Data
Connect Models
You can connect your Decision Models to your Booklet.
Connect a Flow
You can connect pre existing Flow in your project as a data source.
Once you drag and drop Flow, project explorer window allows you to select your pre-existing flow document to connect as a data source.
Connect Data
- Connect a Database
- Connect a REST API
- Connect a JSON File
- Connect a Spreadsheet
Now you can connect your data source to the Booklet by dragging a relevant data source from Toolbox and drop in to the Booklet.
Connect a Database
If you drag and drop Database icon from Toolbox, the following window will appear to connect the database
Query Builder
Once you successfully connect your database, you can build your query here.
Once you double click on the tables, it will come to the editing space. If the editing space has any other tables before, the new selected table will create a join with others if exists. Otherwise, you can manually select the join type in the Join Editor window. the green plus icon helps you to join with other tables easily. In the right side, you can see the query is building according to the tables in the edit space.
In the bottom right, you can do some other edits for the query such as Sorting Type, Group-By, Aggregate etc.
And also, in the left bottom corner, the Preview Results button allows you to preview the results base on the query you build, Filter and Edit Parameters for the query. Once you click ok, your data source will be linked to the Booklet.
Connect a REST API
You can connect your desired REST API as a data source by providing service URL.
Connect a JSON file
You can connect your JSON file as a data source.
Connect a Spreadsheet file
You can connect your spreadsheet file to a Booklet as a data source.
Spreadsheet File Selector allows you to select your spreadsheet.
Retrieve the Data
Complete the source connection from one of the options mention above.
Now you can click on Play button in the Toolbar to retrieve the data.
Check the Source Binding
If you have a Booklet which is already connected to a source, you can either modify the source or view what the source is.
- Go to the Properties window and click on the following area to open the drop down list.
2. Select Data Source from the drop down.
3. It shows the Data Source Binding details. In this example: its a Spreadsheet.
