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!! ----------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWell, 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
------------------------------
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
------------------------------
- Thank you! Will review this video: Using Pipelines with Quick Base APIs https://university.quickbase.com/empower-2020/546088
------------------------------
Christine White
------------------------------- MarkShnier__YouThx fo that link. In the video he is using a different type of API called RESTFul APIs.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Also found this workaround:
https://university.quickbase.com/getting-started-with-pipelines/512664
Create a template table and use to populate live table with pipelines
------------------------------
Christine White
------------------------------
I found this in a search and it's exactly what I need... but I get an error.
Output
url:https://mycompany.quickbase.com/db/b*******j
status:200
content:<?xml version="1.0" ?> <qdbapi> <action>API_CopyMasterDetail</action> <errcode>24</errcode> <errtext>Invalid Application Token</errtext> <errdetail>An Application Token must be supplied.</errdetail> </qdbapi>
Ok so how do I format the "Token URL" field? I've used tokens before by tacking it onto the end of a URL, so I tried both the QB database URL and table URL... neither work. https://mycompany.quickbase.com/db/b*******d&apptoken=app_token
- MarkShnier__You
if you are using that syntax I tjink ity would be like thjis
<qdbapi>
<destrid>0</destrid>
<sourcerid>1</sourcerid>
<copyfid>6</copyfid><apptoken><kbeoh3298oxxxxxxxxxx></apptoken>
</qdbapi>ie just insert
<apptoken><kbeoh3298oxxxxxxxxxx></apptoken>
into the body as an extra line.
Thanks that cleared the error, but new error...
Output
url: https://mycompany.quickbase.com/db/b*******j
status:200
content:<?xml version="1.0" ?> <qdbapi> <action>API_CopyMasterDetail</action> <errcode>22</errcode> <errtext>Sign-in required</errtext> <errdetail>The page you have requested can be viewed only by users who have signed in. Please sign in to proceed.</errdetail> </qdbapi>
I tried filling in the username/password fields since those are an option (which I don't really like, if the password changes the pipeline breaks.) Doesn't work :-/
