Forum Discussion

Winss's avatar
Winss
Qrew Trainee
5 years ago

Pipelines to import csv file not working

I was trying to create a pipeline to import from a csv file to table in quickbase. In channel quickbase i selected Bulk record sets > then dragged import with csv. I have uploaded the file in dropbox and copied the address in browser after opening that csv file. But after running the pipeline i can only see records like : window._goch_ = {}; , window._csp_external_script_nonce = "MGnvP2RXtHOgz49G460x"</script><meta content="IE=edge etc. 
The csv file have names(text) and idno.(num). The table created also have just 2 fields name and idno.
Please guide me how to solve this. 

------------------------------
Aswin Babu
------------------------------
Pipelines
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    It sounds like Dropbox may need some sort of authentication in order to grab that file which makes sense. It is protecting your account from unauthorized access. When you login via the browser it knows you and knows you can access it, when you go to the same URL with a webhook it does not know you and denies that.

    I believe there is a dropbox channel in Pipelines, mine is not turned on though. You would probably need to use that to authenticate and then find the csv you want and do something else to take the csv and import it. 

    Another option here is to not use Pipelines and instead use the Quickbase Sync for CSV and use Dropbox. That syncs a csv with a table. That should be much easier assuming you just want to import that csv file. Not sure on the limitations there though, a Pipeline might get you more of what you want.

    https://help.quickbase.com/user-assistance/Connecting_to_a_folder_of_csv_files.html

    • Winss's avatar
      Winss
      Qrew Trainee
      5 years ago
      This worked. Thank you, Austin!

      ------------------------------
      Aswin Babu
      ------------------------------