Save Calculation Flow Output to database

Saves the result of a Calculation Flow to the target table.

Example
This flow is triggered by an HTTP request and performs a complete calculation process for project data. It begins by loading project dimensions and defining lookup tables, distribution keys, and auto transactions required for the calculation. The flow then defines the output structure and iterates through each project, setting the project context and performing time and material estimations. Before saving the new results, it removes any existing records from the target table. Finally, the calculated output is saved to the database, making the data available for reporting and analysis in InVision or Power BI.

Properties

Name	Required	Description
Title	No	Custom title for the action.
Batch size	No	Number of rows to write per batch.
Timeout (seconds)	No	Number of seconds for the operation to complete.
Disabled	No	Disables the action when checked.
Description	No	Additional information or notes about the action.

Example

In the example above, the Estimate Time and Material function writes calculation results to the output object defined in the Define Calculation Flow output step. Each record is added to the Output variable using this.Output.Add(...), ensuring that all computed values are collected and later saved to the target database table.