I'm receiving a .CSV file via the Pipelines 'CSV Handler'. In the second step I'm using 'Iterate over CSV Records'.
What I am trying to do is use the csv which looks like this:
I want to create a single record in a table called 'Orders' for each order, and then child records in a table called 'Warehouse Requests' for each SKU under an 'Order', which will be used to generate a warehouse pick-list.
I'm getting stumped by the first part of this. The pipeline runs and seems to loop over the records but only creates blank records for each row. I haven't even started on the next part which is to generate all of the child records for each SKU.Anyone have any ideas on what I might be doing wrong or if there's a different approach I should consider?