Discussions

Trying to import CSV field using Pipelines

  • 1.  Trying to import CSV field using Pipelines

    Posted 08-17-2021 09:23

    Hello,

    I am trying to import a CSV file from OneDrive to my QB app using Pipelines. So far, I can create new records, but I cannot update any existing records, and I need some help. 

    Here is what I have created so far:

    (A) File Created or Modified in OneDrive will tiger the Pipeline.


    (B) Import with CSV



    This works well if I want to add new records, but I want to be able to go to the CSV file and edit an already existing record and have it update in QB.

     

    I tried adding the Record ID field like this:



    But then I get this error:



    I know I am missing a step or two, but I am very new to Pipelines, and I can't figure it out. I appreciate any help you can provide.

     

    Thanks,

    Dusan



    ------------------------------
    Dusan Djordjevic
    ------------------------------