Pipelines CSV Handler

Question

I'm receiving a .CSV file via the Pipelines 'CSV Handler'.&nbsp; &nbsp; In the second step I'm using 'Iterate over CSV Records'.&nbsp;&nbsp;
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.&nbsp; &nbsp;The pipeline runs and seems to loop over the records but only creates blank records for each row.&nbsp; &nbsp;&nbsp;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?------------------------------Jeff Peterson------------------------------

markshnier__you · Answer

Is the file format regular CSV? &nbsp;I had a problem where I inadvertently was testing with a CSV UTF -8 file.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

jeffpeterson1 · Answer

Yes, definitely just a standard .csv.&nbsp; I'm completely stumped on this one.&nbsp; I found a way to do this with Zapier but it creates an "Order" for each row in the .csv.&nbsp; &nbsp;Still stuck on this problem.------------------------------Jeff Peterson------------------------------

johncrosland · Answer

I assume that Orders has a one-to-many relationship with Warehouse Requests. It seems like you're going to want to have two Pipelines. You're going to want to bring the Date Created or some other standard field into Warehouse Requests from Orders

One which reads this data into the Warehouse Requests table because it is actually what each line represents.

Second One that is triggered On A New Event with Warehouse Requests. Use the standard field that you brought into Warehouse Requests as the filter to decide whether or not to create an Order. If you need to create the Order, then create it.

I hope that this helps.

------------------------------
John Crosland
------------------------------

Forum Discussion

Pipelines CSV Handler

Related Content

Three Words of Advice on Pipelines

Issue with Accessing Nested Array(JSON handler) in Quickbase Pipeline

Pipeline Not Triggering

Three Words of Advice on Building Pipelines - Brittany Scheid

AI Smart Builder for Creating Apps and Streamlining Pipelines