In FuseBase portals, you can add not only content created in our editor but also data from other services, such as HubSpot, Asana, etc.
This can be done using the Dynamic Table block. In the future, we will expand the capabilities of other blocks (cards, custom widgets, etc.) to display data from external services.
Connecting Third-Party Services to the Portal #
1) Open the portal customizer and navigate to the page where you need to display external data.
2) Click Add a new block and select Dynamic Table.
3) Next, you need to select the service from which you want to display data in the table. To do this, click on Data source and select Add new data source.
4) Then, choose and authorize the required service. In our case, this will be HubSpot.
5) Next, you can choose the type of data to display in the table. Each service may have its own data types. For example, in HubSpot, you can display tickets, tasks, contacts, and more. Let’s select Company List as an example.
Configuring Table Columns #
By default, we display the main column types in the table, such as Company Name, Tasks, URL, etc.
However, you can choose which columns to display and which to hide. To do this, expand the Table Fields section, where you can see the currently added columns.
It is important to note that when using external data sources, each column must be mapped to a corresponding parameter from the external service.
For example, the Company Name column should be linked to the Company parameter in HubSpot, while Phone Number should be mapped to the Phone parameter in HubSpot.
Let’s try creating a new column Date Created and mapping it to the Created Date parameter in HubSpot.
1) Click on Add Field.
2) Enter the column name (Date Created).
3) In the Map to field, select the corresponding parameter in HubSpot. In this case, choose CreatedAt.
4) In the Field Type section, you can select the column type. Currently, several options are available, such as Text, Email, Numbers, and more. In our case, we only need a date, so we will select the Date type.
If you don’t need a specific column, you can delete it through the column menu.
Filtering Data #
Filters allow you to fine-tune which data should be displayed to your clients. For example, you can show only tasks with a specific label or companies from a certain industry.
Let’s filter our table to display only companies that were added after 2023.
1) Click on Add Condition.
2) Select the HubSpot parameter to filter by. In our case, choose Createddate.
3) Choose the operator: Greater than ( > ) (since we want to show companies created after a certain year).
4) In the Value field, enter 2023 (to display only companies added after 2023).
You can add multiple filters to refine your data further. If a filter is no longer needed, you can disable or delete it through the menu.
