Run table to table import from pipeline
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? ------------------------------...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendMike,
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
------------------------------
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
------------------------------
Or in other words, do an automation and choose 'table to table import', and skip the pipeline. LOL.
------------------------------
Mike Tamoush
------------------------------
------------------------------
Mike Tamoush
------------------------------