Skip to main content
Question

Run table to table import from pipeline

  • September 11, 2020
  • 0 replies
  • 49 views

Forum|alt.badge.img+14
This is a simple thing to do with automations, but I haven't figured it out with Pipelines. How can i set up a number of table to table imports to run, via pipelines?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
Mike,
Here are my cheat notes on how to run an API, n this case it hapens to be the API_RunImport.

Webhook.
Make Request
a bunch of the top fields are left blank

URL
https://mycompany.quickbase.com/db/abcabcabc (the table the API is being used on)

Method
POST

(click more)

Content Type
Application/XML

(strangely, the Body is entered next but when saved comes back in the sequence below)

Headers (list)
QUICKBASE-ACTION

Value
API_RunImport

Body
<qdbapi>
<apptoken>aaabbbccc3dffk3uydkdk2ta</apptoken>
<usertoken>aaaabbbbccckc6fkcbrzdmxjzeq9tdwkqihm</usertoken>
<id>10</id>
</qdbapi>


Note that I don't think that you need the apptoken  but you must have the usertoken.

The body part of the API can be found in the API guide, for example,
https://help.quickbase.com/api-guide/runimport.html

but you do not need the ticket parameter.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------