Forum Discussion

ChristineWhite's avatar
ChristineWhite
Qrew Assistant Captain
3 years ago

Using Pipelines instead of Copy Master Detail

Has anyone used pipelines instead of the Copy Master Detail feature to automate the process?  Would like to use a trigger rather than requiring users to press a button.

Thanks!!

------------------------------
Christine White
------------------------------

7 Replies

  • Well, you can call any Webhook, so you can call a QuickBase API

    The webhook setrup would look like this

    Webhook.
    Make Request
    a bunch of the top fields are left blank

    URL of the target table like this
    https://yqc.quickbase.com/db/xxxxx

    Method
    POST

    (more)

    Content Type
    Application/XML

    (strangely, the Body is entered next but when saved comes back in the sequence below)

    Headers (list)
    Name
    QUICKBASE-ACTION

    Value
    API_CopyMasterDetail

    Body
    <qdbapi>
        <destrid>0</destrid>
       <sourcerid>1</sourcerid>
       <copyfid>6</copyfid>
    </qdbapi>


    note that you will need to replace the source Record ID# of 1 with the [Record ID#] field of the trigger record from step A.  

    The aAPI paramers are here
    https://help.quickbase.com/api-guide/API_CopyMasterDetail.html

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------