Profitbase Flow December 2024 update

Just in time for Christmas, we’re shipping a new version of Flow with support for even more systems and features to simplify and automate data integrations and business processes. New in this release is support for TripleTex, Visma.Net, Databricks, Azure Table Storage and Azure Files. In addition, we’ve added new features for PowerOffice Go, Microsoft Fabric, PostgreSQL and Profitbase InVision.

TripleTex

Profitbase Flow now has a built-in connector for the TripleTex REST API. The connector handles authentication, paging, faults and throttling (API quotas), simplifying data integrations with TripleTex.
Read more here: TripleTex REST API | TripleTex REST API for paginated response

Visma.Net

We now support the Visma.Net REST API to retrieve large, paginated datasets. This action simplifies working with APIs that return multiple pages of data, such as lists of customers, invoices, or accounting records. Pagination is handled automatically, allowing you to focus on the business logic instead of infrastructure. Read more here: REST API with paging

PowerOffice Go

We’re extending our PowerOffice Go REST API support to automatically handle paged result sets. This simplifies working with APIs that return multiple pages of data, such as lists of customers, invoices, or general ledger records.
Read more here: REST API request with paging

Databricks

Flow now supports the Execute SQL statement API in Databricks. This enables easy integration with Databricks for querying data and executing SQL statements on a SQL warehouse.

Azure Table Storage

The December 2024 update of Flow introduces support for Azure Table Storage which is a service that stores non-relational structured data in the cloud, providing a key/attribute store with a schemaless design. Access to Table storage data is fast and cost-effective for many types of applications, and is typically lower in cost than traditional SQL for similar volumes of data.

We support the following Azure Table Storage actions:

For each table entity – enables iterating over a list of entities
Add table entity – adds an entity to an Azure Table
Update table entity – updates an existing Azure Table entity
Delete table entity – deletes an entity from an Azure Table

Azure Files

Azure Files makes it easy to share file between cloud and on-premise servers and services. Flow now supports Azure Files through the following actions:

Get share items info – returns a list of files and folders in an Azure Files share
Read file from share as stream – reads a file from an Azure Files share
Upload file to a share – uploads a file to an Azure Files share
Delete file from a share – deletes a file from an Azure Files share

Microsoft Fabric

Create Workspace
This action enables teams and organizations to automatically provision Fabric Workspaces on-demand without having to use the Fabric portal to create them manually.
Read more here.

Load Lakehouse table
The Lakehouse in Microsoft Fabric provides a feature to efficiently load common file types to an optimized Delta table ready for analytics. The Load Lakehouse table action allows users to load a single file or a folder of files to a table.
Read more here.

PostgreSQL

We’ve extended the support for PostgreSQL with new actions to improve developer productivity for typical application development scenarios, where working with business entities are more common that working with large datasets.

Get single value
This action enables running a query that returns a single value, for example counting the number of rows in a table.

Get entity
This action enables running a query that returns a (business) entity, for example a customer object.

Get entities
This action enables running a query that returns a list of (business) entities, for example all customers.

Profitbase InVision

The December 2024 update of Flow adds support for the following new InVision integrations:

Execute InVision Dataflows from Flow – This feature makes it easier to gradually migrate business logic from InVision Dataflows to Flow.
Lookup, Distribution Keys and Auto Transaction tables now includes an option to disable caching. This feature is useful when data is always generated into a table by a script instead of coming from user input. By enabling this option, you don’t have to use the Remove InVision object from cache action for tables where data is generated from custom code.

JSON

The new Get JSON DataReader action makes it easy to write JSON data to a relational database table as rows and columns, or convert JSON into other tabular formats such as Excel or Parquet files. This feature is particularly useful when creating integrations to REST APIs (such as ERP systems), which returns JSON that can be represented as rows and columns.

Data Analysis APIs

The December 2024 update introduces the initial version of programming APIs for doing data analysis and manipulation tasks in Flow. These APIs are intended for advanced scenarios (or when you simply want to write code instead of doing drag & drop), and offers a way to manipulate data using code.
Read more here: DataTable transformer | JsonDataReader

DataTable dataTable = ... // load the data table.

dataTable.UseTransform()
    .FillMissingValues("Age", FillMethod.Average)    
    .MergeColumns(["City", "Street"], "Address", separator: ", ")
    .ForEachRow(row =>
    {
        row["Name"] = row["Name"].ToString().ToUpper();
    })
    .AddColumn("AgeInMonths", "int")
    .ComputeColumn("AgeInMonths", row =>
    {
        var age = (int)row["Age"];
        return age * 12;
    })
    .RenameColumn("dob", "DateOfBirth")
    .RemoveColumn("email");

Merry x-mas and happy new automation year!