Get File Data

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 how to configure the get file data action? 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 is 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 how to map the imported data 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; mandatory type = file; set as input 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; defining the process variable is essential as it will store the data when the process in running, and you can use this data further in processing mandatory type = data model with attributes that will be mapped to your file structure; you will further map columns to selected data model's attributes mandatory process variable defined will be a list as your file may contain more than 1 entry 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) example of configuration 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 external file structure data model created in this case, named "teamdetails" if the file 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 the configuration panel step 4 configure the action file to process the file type process variable created i e filetoprocess filetoprocess store data as the process variable type data model, i e teamdetailsdata teamdetailsdata ("teamdetails" data model created at step1) add columns and map the file's header columns to the data model's attributes "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 the get file data action enables you to pull in tabular data from an excel/csv file and map it to a process variable this will allow you to use data coming from external files in process flows