Identify CSV fields as variables in Integration Platform. Follow

Avatar
Fernando Ramos Miracle

Question

 How to have the Integration Platform identify the fields of a CSV type file as variables.

Answer

 The idea would be to have the integration "identify" each database field as a "variable". After doing so you can assign those variables as print job commands. Integration Builder does that automatically when you "convert to record set" the received data.

The Integration would have the following structure:


a. The action "Transform Text To Record Set" will be the one where the integration identifies the different fields as variables.

b. The "For Each Database Record" action is actually a group: it will run any action set in this group for each record/line in the trigger file detected.

c. As the "Print Document" action is inside the group mentioned in #b it will have access to all the variables for each database field.

After the above configuration you will be able to add those database fields to the Print Document action as follows:



The rest of database fields you can pass them to the document through the Database Override option:



*Make sure to use the "Current Record" variable to use only the information from each record. Using the "Integration input data" you would pass the entire database for each record.


Notes:

-. The "Transforms text to record set" action needs to use the %EventData% variable of source of the data (by default it's set to "Embedded Data".
-. For this same action you'll need to specify an example database with the desired structure (the one you sent me could do). That way it will be able to properly identify the future trigger files and their database fields.

Was this article helpful?

0 out of 0 found this helpful

Please sign in to leave a comment.