Hi, How can I send the data from a CSV file to a workflow, I have created an object schema for the CSV file but I am not able to map the CSV file to the Workfloe to call an ION API
In the workflow, access the Workflow Properties and add a Structure. The structure should mimic the schema of the object you will map to it. That said, the structure only needs to include what you will be using in the workflow. Once you have that, go back to your Document Flow and access the Workflow Activity Properties. Click on the Structure Mapping tab and map your object schema to the structure.
This may be more than you need, but the way we do it... In the connection point, we define a File Format Template for the CSV file and set the Document Verb = Process. Back in the Document Flow, after the file connector we use one or two Mappings to 1. Strip the header row (if needed) and 2. Parse and Group the data into one or more sets of header and line data. Then we use the Splitter to create separate BODs (one for each set of header and lines). The Workflow then follows the Splitter. When the Doc Flow runs, each BOD created by the Splitter spawns a separate "call" to the Workflow.
Thanks for the reply, I have to pick up a CSV file from a shared folder for that i have made the file connection point but when i put the workflow option after the file connection, It says that the workflow requires sync or process verb to work. Now as i have a CSV file and not using a BOD i need to understand how can i send it to the work flow. In the workflow i have to pass the multi line data that is there in the CSV file to an ION Api to update it in M3
Thanks for your help !!
