Using Form Builder
This action creates an entity list in the current context from the content of a provided CSV file. You can find the number of loaded entities in the
This creates an entity that can be used ONLY in the current context. This does not create a Plant an App Entity.
Typical Use Cases
- Load values from a CSV file provided by a user in a File Upload form field and then use Execute Actions on Entity List to run the same actions on each item in the uploaded file.
- Use in
Automationto Load values from a CSV file already on the server and then use Execute Actions on Entity List to run the same actions on each item in the file.
Don't use it to
- Take actions on the provided CSV file such as renaming it. Use File Management actions instead.
- Serialize data to create a CSV file. Use the
Serialize to CSVaction instead.
|Execute Actions on Entity List||Execute a list of actions on each item in the specified context entity. Use this to process the items loaded in the Entity created.|
|Extend Entity||Extends an entity with new properties.|
Input Parameter Reference
The parameters unique to this action are listed below. Review the common parameters for all actions here.
|File Path||Path to the CSV file. If using on a form and one or more ||Yes||Yes|
|Field Separator||Use semicolon if you open CSV Files with Excel and your Region Format is set to other than English (United States). Left unselected, this will default to comma. You can use the expression setting (||No||No|
|Entity Name||Provide a name for the entity being created. This name can be used in the Execute Actions on Entity List action to reference the items in the entity using ||Yes||Yes|
|Use first row as column names||Use the first row of the CSV file as column names. If this option is not checked the entity will be assigned 0 based index column names as ||No||No|
|On Error||Specify a list of actions to run on error. Otherwise, an error message is returned which will contain the underlying error if debug mode is on.||Yes||None Specified||No|