Multi-Row Writeback
Push multiple rows of spreadsheet data back to a connected database in a single batch operation using InfoBurst Enterprise.
When you need to update or insert many database records at once, writing back row by row is impractical. The Multi-Row Writeback component lets you bind a table range from your spreadsheet and send all its rows to a database in one operation, receiving a status response for every execution.
Multi-Row Writeback is available on Builder Plans and above. It requires an active InfoBurst Enterprise (IBE) connection. The component appears in the Connections panel only when IBE connectivity is enabled on your account.
Adding a Multi-Row Writeback Component
The Multi-Row Writeback component is a non-visual connection component. It runs in the background and does not appear on the canvas.
Open the Connections panel in the left sidebar.
Locate the InfoBurst section.
Click Multi-Row Writeback to add it to your project.
The component appears in the Connections panel list. Select it to open its properties in the right-hand properties panel.
Configuring the Component
The properties panel contains three sections: Login, Writeback Statement, and Usage. Complete them in order — each section depends on the one before it.
LOGIN
The Login section connects the component to your InfoBurst instance.
Select either InfoBurst Server or InfoBurst Cloud using the radio buttons at the top of the section.
If you selected InfoBurst Server, enter the InfoBurst URL (with port) — for example,
https://infoburst:8551.Enter your Username and Password.
Click Login.
After a successful connection, the status displays Connected and the Select the database connection dropdown appears. If the connection fails, the status displays Unable to connect — check your credentials and try again.
Select a database connection from the Select the database connection dropdown.
WRITEBACK STATEMENT
Once a database connection is selected, the Writeback Statement section becomes available.
Select the writeback statement you want to execute from the Select the writeback statement dropdown. The list is populated from the queries configured for the selected database connection in InfoBurst.
After selecting a statement, the Parameters & Response sub-section appears if the selected statement includes parameters.
PARAMETERS & RESPONSE
The Parameters & Response sub-section defines what data is sent to the database and where the response is written.
Parameter Table
Bind the Parameter Table field to a spreadsheet range that contains the data to write back. Structure the range as a table:
Row 1 — header row containing the parameter names, which must match the parameter names defined in the writeback statement exactly
Rows 2 onwards — data rows, one database row per spreadsheet row
The field label shows the number of columns the selected statement expects — for example, Parameter Table (3 columns).
To confirm the correct column names and order, click Copy Parameter Header Row. This copies the expected parameter names to your clipboard so you can paste them as the first row of your data range.
The order of columns in your data range must match the parameter order defined in the writeback statement. Use Copy Parameter Header Row to verify the expected names and their sequence before binding.
Response Table
Bind the Response Table field to a spreadsheet range where the writeback response will be written. Define a range in a different area from your parameter table to avoid overwriting your input data. See Reading the Response for details on the columns this table contains.
Reading the Response
After each writeback execution, the component populates the Response Table range with four columns, one row per data row that was sent:
Status
The result code returned by InfoBurst for each row
Rows Affected
The number of database rows inserted or updated
Timestamp
The time the writeback operation completed
Error Message
Any error returned by InfoBurst; empty when the operation succeeds
Bind these columns to scorecard cells, text components, or other components in your project to surface the results to end users.
Usage Settings
The Usage section controls when the writeback executes at runtime. You can enable any combination of the three options.
REFRESH ON LOAD
Enable Refresh on Load to execute the writeback automatically when the project loads. Use this when your data range is pre-populated and the writeback should run immediately on open.
REFRESH ON INTERVAL
Enable Refresh on Interval to execute the writeback on a recurring schedule. Enter the frequency in the Interval field, in seconds.
Set the interval to a value that allows the previous writeback to finish before the next one begins. Short intervals may cause requests to overlap if the database operation takes longer than expected.
REFRESH ON CELL CHANGES
Enable Refresh on Cell Changes to execute the writeback whenever specific spreadsheet values change. Use the condition builder that appears below the checkbox to define which cell or cells trigger the execution.
Last updated
Was this helpful?