JimLieder2
6 years agoQrew Cadet
Adding rows of data to a CSV in Pipelines
I have a Pipeline that makes an API call to another application (rollmaster.com) to retrieve customer order information and download the information to a .csv file.
The Pipeline successfully makes the API call to the RollMaster Orders endpoint, and I see all the RollMaster records scrolling by as it runs , but when the .csv file is created, only the column headers are there.
I'm missing the step that maps the data retrieved to the table defined in the first step, but I'm not sure how to do that.
The Pipeline steps are:
------------------------------
Jim Lieder
------------------------------
The Pipeline successfully makes the API call to the RollMaster Orders endpoint, and I see all the RollMaster records scrolling by as it runs , but when the .csv file is created, only the column headers are there.
I'm missing the step that maps the data retrieved to the table defined in the first step, but I'm not sure how to do that.
The Pipeline steps are:
- Define the table
- Make the request (this is where the API call is made and the 400 records are retrieved
- Add a Row <- I think this is where I'm going wrong.
- Download .CSV <-empty file except for headers
------------------------------
Jim Lieder
------------------------------