Box CSV Triggers
Box CSV triggers include:
- New/updated CSV file in folder
- New line in CSV file
New/updated CSV file in folder
Triggers when a new CSV file is added to a specified folder and processes CSV lines in batches. Trigger will not pick up newly uploaded versions of the same file. Checks selected folder for CSV files every 5 minutes. CSV rows are delivered in batches of 100 by default, maximum is 50000.
| Field name | Description |
|---|
| When first started, this recipe should pick up events from. | When you start recipe for the first time, it picks up files created from specified time. Defaults to fetching files created an hour ago if left blank. Once recipe has been run or tested, value cannot be changed. Learn more |
| Folder | Monitor for new CSV files in this folder. Select from the pick list or enter folder ID. |
| Include sub-folders? | If Yes, trigger will pick up new CSV files in sub-folders as well. |
| Sample CSV file / Field names | Select a CSV file for Workato to understand the data columns in your files. Otherwise, toggle to provide column names manually. |
| Column delimiter | The character used to separate column values within each CSV row. |
| Contains header row? | Set to Yes if the first CSV row is a header row, containing column names. Workato will then not process the first row as CSV data. |
| Batch size | Number of CSV rows per batch. Instead of reading rows one by one, Workato reads a batch of CSV rows at a time to increase throughput. Modify batch size to optimize throughput. Learn more about batch processing |
| Expected encoding | Expected encoding of the CSV files. |
Output fields
| Field name | Description |
|---|
| ID | ID of the file. |
| Name | File name. |
| Type | Type of this object, which in this case is file. |
| Description | Description of file. |
| Size | Size of file. |
| Shared link | |
| - URL | Shared link URL for viewing file. |
| - Download URL | Shared link URL for downloading file. |
| Created at | Date/time file is created. |
| Modified at | Date/time file is modified. |
| Trashed at | Date/time file is trashed. |
| Purged at | Date/time file is purged. |
| Content created at | Date/time file content is created. |
| Content modified at | Date/time file content is modified. |
| Sequence ID | Position of this object in the folder hierarchy. |
| Etag | Entity tag of this object. |
| Sha 1 | SHA-1 hash value of this object. |
| Parent | Includes details about the file's parent folder. |
| - ID | ID of parent folder. |
| - Name | Name of parent folder. |
| - Type | Object type, which in this case is folder. |
| - Sequence ID | Position of this object in the folder hierarchy. |
| - Etag | Entity tag of this object. |
| Path | File path. |
| Path collection | Includes details of all paths this file belongs to. |
| - Total count | Number of file paths. |
| - Entries | File path entries. |
| -- ID | ID of file path. |
| -- Name | File path. |
| -- Type | Type of file path. |
| -- Sequence ID | Position of this object in the folder hierarchy. |
| -- Etag | Entity tag of this object. |
| -- List size | Number of items in this Entries list. |
| Created by | Includes details about user who created this file. |
| - ID | ID of user. |
| - Name | Name of user. |
| - Type | Type of user. |
| - Login | Login email of user. |
| Modified by | Includes details about user who modified this file. |
| - ID | ID of user. |
| - Name | Name of user. |
| - Type | Type of user. |
| - Login | Login email of user. |
| Owned by | Includes details about user who owned this file. |
| - ID | ID of user. |
| - Name | Name of user. |
| - Type | Type of user. |
| - Login | Login email of user. |
| Item status | Status of this file, for example, active. |
| First | Whether this is the first batch of CSV rows. |
| Last | Whether this is the last batch of CSV rows. |
| Rows | This is a List data pill, representing the list of CSV rows. |
| - Columns | Include all data pills representing CSV columns and CSV data. |
| - Row | The row number of this row. |
| - List size | Total number of rows. |
New line in CSV file
| Field name | Description |
|---|
| File | Use the drop-down menu to choose Select from list or Use file ID. |
| Column separator | Use the drop-down menu to select the separator you plan to use for columns, for example, comma. |
| Add column names manually | Use the drop-down menu to choose Select from option list or Use custom value. |
Output fields
| Field name | Description |
|---|
| Line number | The line number of the line currently being processed. Header lines are not processed, so the first line has the value 1. |
| Columns | If you selected Use custom value and configured datapill, this is an object type datapill. Columns of the selected CSV file are available as datapills here. If you selected Select from option list and configured the column name, the output will show the configured column name. |