Skip to main content
Question

How do I run a Table to Table Import?

  • December 25, 2024
  • 0 replies
  • 133 views

Forum|alt.badge.img+1

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. 

MarkShnierYou
Forum|alt.badge.img+24

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?