Get File Data action enables you to pull in tabular data from an Excel/CSV file and map it to a process variables. This will allow you to use data coming from external files in process flows.
You can proceed with the action configuration byย manually creating the structure of the file (header) that will be uploaded.
You need to map the file structure created to a process variable which will give you the possibility to use the data in other actions in process flows.
Go to the Process Designers section and open a new or an existing process. Actions configuration can be performed once they are dragged and dropped on canvas.ย
Video on how to configure Get File Data, availableย here.
Step 1:ย Drag the Get File Data action from Toolbar and drop it on canvas; click on the action to open the Properties Panel.
Step 2:ย You can edit the Action Name.
Step 3:ย Click on Mapping Configuration (Not configured) card to go to the action configurations steps.
Step 4:ย ย Get File Data configuration
Step 1:ย File to Process:ย select the process variable that will fetch your file details when kicking off the process flow. You can select the file type variable from selector (if created upfront) or you can click on "+Create new variable" to create a file type variable;
Step 2:ย Store data as:ย select a process variable that will be storing the data at runtime, data that is pulled from the uploaded file.ย You can select the process variable from selector (if created upfront) or you can click on "+Create new variable" to create a data model type variable;
Step 3:ย Add column:ย start building the structure of your file by pressing "Add column". In "Column Name" add the name of the corresponding column in the file that will be processed; in "Map Data" add the attribute that will be mapped to the column (attributes of data model selected in Step 1).
Step 1:ย Based on the file that will be used in processing, the first step is to create a data model with attributes following the external file's structure:
If the file that is intended to be imported has duplicate column names only the first one will be imported.
Step 2:ย Create the process variables needed for this action:
Step 3:ย In process designer, drag and drop a Get file data action on canvas and open configuration panel.
Step 4:ย Configure the action:
"Column name" in the configuration panel must match the name of the columns in your external file in order to have a correct action configuration.
Step 5:ย Save, Validate and Run the process. Upload your file:
Run the process. In Instances you can check now the output of the action, data being available in a JSON format. ย You can now use this process variable further in other actions within actions. This is how Get file data actionย enables you to pull in tabular data from an Excel/CSV file and map it to a process variables. This will allow you to use data coming from external files in process flows.
๏ปฟ