New to the forum. I searched but did not find anything existing for this specific error so here is my first post. I am trying to run a pipeline that takes a .csv file from a document table and creates new records in a second table from each entry in the .csv file. I am using Quickbase Channel->Bulk Record Sets->Import with CSV When I run the pipeline, I get the following error: Obviously this is a URL error but I don't understand why since the file/URL resides within the same app as this pipeline. Any help will be sincerely appreciated. v/r...Aaron ------------------------------Aaron Bab1692@att.com------------------------------

If you're getting the file from another record, I think you need to access it from the "File transfer handle" field and not the "Browser url" field ------------------------------gary------------------------------

Thanks Gary. I must not be understanding how the "Import with CSV" option works because I am not seeing anything about "Browser url" or "File transfer handle" in my pipeline options. Only: What is the URL of the .csv file What fields/data in the .csv file do you want to map to the Quickbase table fields I'll definitely give your suggestion a try but I can't find where you got your "File Attachment" screenshot from. ------------------------------Aaron Bab1692@att.com------------------------------

I just realized you might be misunderstanding what I want to do. Your solution looks like it will be able to grab that attachment from an existing record and put it somewhere else. What I want to do is: Read the .csv file create a new record in a 2nd table for every entry in the .csv file I don't want to move or copy the .csv file anywhere. ------------------------------Aaron Bab1692@att.com------------------------------

Your first screenshot has a redacted file attachment URL, so either you're hardcoding that URL into the pipeline or you're getting it from a previous step. Based on your response, I'm assuming you're hardcoding it. Can you confirm? If you were to query a record that has the file attachment, you would see the two fields I mentioned above. When handling files from with Quickbase in a Pipeline (whether you're transferring them from record to record, or just using them for whatever), I believe you need to use the "File transfer handle" and not the URL. ------------------------------gary------------------------------

I just tested this out and it worked. Quickbase > Look Up a Record Quickbase > Bulk > Import with CSV Step 1 finds the record with the file attachment. Then use the file handler field from step 1 as the URL in step 2. Heads up, the Look Up step was a bit janky for me. It threw an error when I just typed in the record ID (96). To get it working I had to use Jinja: {{96|int}} ------------------------------gary------------------------------

Pipeline error: Import with CSV - HTTP status code 404

12 Replies

Gary1
Qrew Cadet
2 years ago
If you're getting the file from another record, I think you need to access it from the "File transfer handle" field and not the "Browser url" field

------------------------------
gary
------------------------------
- AaronB
  Qrew Trainee
  2 years ago
  Thanks Gary. I must not be understanding how the "Import with CSV" option works because I am not seeing anything about "Browser url" or "File transfer handle" in my pipeline options. Only:
  
  What is the URL of the .csv file
  
  What fields/data in the .csv file do you want to map to the Quickbase table fields
  
  I'll definitely give your suggestion a try but I can't find where you got your "File Attachment" screenshot from.
  
  ------------------------------
  Aaron B
  ab1692@att.com
  ------------------------------
  - AaronB
    Qrew Trainee
    2 years ago
    I just realized you might be misunderstanding what I want to do.
    
    Your solution looks like it will be able to grab that attachment from an existing record and put it somewhere else.
    
    What I want to do is:
    
    Read the .csv file
    
    create a new record in a 2nd table for every entry in the .csv file
    
    I don't want to move or copy the .csv file anywhere.
    
    ------------------------------
    Aaron B
    ab1692@att.com
    ------------------------------
GregoryGebhardt
Qrew Cadet
2 years ago
If the file is in QB you should just be able to search for the record(or trigger)>Fetch the CSV>iterate over the CSV>add records.

Bulk record stuff makes my brain work too hard.

------------------------------
Greg
------------------------------
- AaronB
  Qrew Trainee
  2 years ago
  Thanks Greg.
  
  Your recommendation looks similar to Gary's earlier. Now that 2 of you have offered that working solution, I am starting to think my original logic of how the "Import with CSV" works may be flawed.
  
  I was trying to get it to work by just providing the entire file URL versus fetching a specific record containing the file and then using {{a.document.file_transfer_handle}} as the URL (which worked just fine).
  
  Thanks again for your input!
  
  ------------------------------
  Aaron B
  ab1692@att.com
  ------------------------------

Forum Discussion

Pipeline error: Import with CSV - HTTP status code 404