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
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
Qrew Legend
Qrew Legendif 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 :-/