Forum Discussion
- MarkShnier__YouQrew 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
------------------------------- JenHamilton_TyeQrew Trainee
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__YouQrew Legend
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.
- ChristineWhiteQrew Assistant CaptainThank you! Will review this video: Using Pipelines with Quick Base APIs https://university.quickbase.com/empower-2020/546088
------------------------------
Christine White
------------------------------- MarkShnier__YouQrew LegendThx 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
------------------------------