Forum Discussion

ChristineWhite's avatar
ChristineWhite
Qrew Assistant Captain
4 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
------------------------------
  • 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
    ------------------------------
    • JenHamilton_Tye's avatar
      JenHamilton_Tye
      Qrew 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__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew 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.

      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Thx 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
        ------------------------------