Forum Discussion

Ifuloseulose's avatar
Ifuloseulose
Qrew Member
21 days ago

How do I run a Table to Table Import?

Hi all. I have a webhook for Table A, and I want it to run a Table to Table Import into Table B whenever records are added to Table A. Here are the details of the webhook:

Enpoint URL - https://amzl.quickbase.com/db/*********?a=api_runimport

Body - <qdbapi>
<usertoken>%user.token.************%</usertoken>
<id>12</id>
</qdbapi>

I'm still new to QuickBase so I'm never 100% sure with what I'm doing but I'm guessing the "12" is referring to the ID of the import. 

webhook
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    21 days ago

    Quickbase is on a path to deprecate Webhooks in favor of pipelines, 

     

    Preferences.



    ENDPOINT: https://ssy.quickbase.com/db/xxxxxx
    MESSAGEHEADER: QUICKBASE-ACTION
    then the next box is the API like API_RunImport

    <qdbapi>
       <usertoken>bxv4tx_dp4x_z3u3efssezw4dt75mprb8kjfv2</usertoken>
       <id>10</id>
    </qdbapi>

     

    The number is the ID of the import which you can get in the URL when you're editing the save table to table import.

     

    The number is the ID of the import which you can get in the URL when you're editing the save table to table import.

    I'm not really sure you need the user token.

    today is a ski day for me, but I'm working tomorrow so if you get stuck, feel free to post back and one way the other, we can get it working. Is this intended to work for multiple entries which are entered one by one into table A, or are you importing records into Table a or grid editing with some multi record  record operation?