Forum Discussion

JimLieder2's avatar
JimLieder2
Qrew Cadet
6 years ago

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:

  1. Define the table
  2. Make the request (this is where the API call is made and the 400 records are retrieved
  3. Add a Row           <- I think this is where I'm going wrong.
  4. Download .CSV   <-empty file except for headers


------------------------------
Jim Lieder
------------------------------

2 Replies

  • Sharon Faust, aka The Quick Base Junkie, made a great video here. https://youtu.be/gra6zBkeg0g

    I think your answer will be there.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JimLieder2's avatar
      JimLieder2
      Qrew Cadet
      Hi Mark, 

      I did see Sharon's YouTube video, and it's very informative and answered many questions.  Sharon's Pipeline is retrieving a record from QuickBase and then adding a new row to a .csv file and then looping back to read another record from QB.

      In my Pipeline, the API is retrieving many records at once from a RollMaster, and I'm wondering if the process of adding rows of data works differently when retrieving many records at once.

      ------------------------------
      Jim Lieder
      ------------------------------