Update Files
Description
The Update Files activity allows you to modify uploaded files by inserting or updating a row at a specified index. This is useful when working with structured files like CSV or Excel, where workflow-generated data needs to be merged or written back.
It ensures that the new row adheres to the existing structure of the file (e.g., correct number of columns and data types). This activity is ideal for automation use cases like log appending, row corrections, or data patching.
Use case:
After processing input data in a workflow (e.g., transforming customer records or calculating metrics), this activity can be used to append the results into a master spreadsheet for audit, review, or reporting purposes.
Input
| Input Type | Format | Description |
|---|---|---|
| Data | Table | Row data to insert into the file. |
| File | File | The file (e.g., CSV, Excel) where the row will go. |
Output
| Output Type | Format | Description |
|---|---|---|
| File | File | The updated file with new row added. |
Configuration Fields
| Field Name | Description |
|---|---|
| Row Index Number | Required. The index at which to insert or update a row. |
| Row Data | Required. Data values for the row, must match the file’s structure. |
Sample Input
Not Applicable
Sample Configuration
| Field | Value |
|---|---|
| Row Index Number | 2 |
| Row Data | ["104", "Diana", "Engineering", "88"] |
Sample Output
| File Name | Size | Download Link |
|---|---|---|
| employees.csv | 3 KB | 🔽 Download |
The updated file contains the new row added at the specified position, preserving the original structure and content.