Writo to data store entity - Store data output in all indeces of an array

Did you take a look at the documentation for Write to Data Store Entity? Basically you will want to add a node input in your process of type Employees. Then, add a reference to your data store entity (I typically use a constant to point to the appropriate data store entity). Then, it should insert the data correctly in the database. This node allows you to insert an array of employees as long as the node input is defined as an array. It should look something like this:

Hi Peter, 

Thank you so much for your response! I got this working succesfully, the node  is indeed inserting the array of employees accordingly.

Now i'm facing another issue which is: My employees table needs an id that comes from the contractor table. I passed this id through the output section of my first Write to data store entity to use it for my array of enmployees in the next write to data store entity assigned to my employees CDT but, the id it's being captured for only one of the employees instaces in the array.

Do you how can i solve this? Thanks in advance for the help and support

Nice! You will need to ensure that the ID is passed into all of the Employees and not just the first one. I usually do this by adding a script task between the Write to Data Store Entity for Contractors and Employees. You need to generate a list of Contractor IDs that matches the length of the Employee ID. In you script task, I'd create a custom output with the following expression. Then, save this into Employee.ContractorID.

repeat(
  length(
    pv!employee
  ),
  pv!contractor.id
)

Thanks again for your quick reply Peter,

This was exactly what i needed, now i got the contractor id flowing into into all of the employees array instances.

Thanks! Worked as expected.