Skip to main content
Question

Using Pipelines instead of Copy Master Detail

  • June 30, 2021
  • 0 replies
  • 330 views

Forum|alt.badge.img+9
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
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
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
------------------------------