Table To Table Import - Pipelines Solution

Question

Hello all,A lot of you may already know this but the migration tool cannot recreate table-to-table imports in pipelines.&nbsp; When I asked the support group about this, they stated I would have to recreate the table-to-table solutions in pipelines.&nbsp; That was all well and good but we have 20 apps and each one has 4 or 5 imports that run daily.&nbsp; &nbsp;But after looking around a little I've found a simple solution.Schedule a Pipeline in the WebHook Channel: Make Request, and run the Quick Base API Call "API_RunImport" with the URL:https://target_domain/db/target_dbid?a=API_RunImport&amp;id=10&amp;usertoken=user_tokenThe dbid is the db when you're in the edit section of the table to table import you want to use, and the id is on the same URL line.&nbsp;I've tried it and it works.&nbsp;&nbsp;

evanmartinez · Answer

Hi Stephen,Thank you for sharing your technique for using the webhooks channel to kick off the process. I also just wanted to let you and others looking at Pipelines and support for Table to Table imports know that we still have plans to extend Pipelines and the automation migration tool to cover the use case of Table to Table imports in the next few months. The plan would be to create a way for Pipelines to call on existing Table to Table imports much like the webhook you are using but all in the Quickbase channel in Pipelines. We don't have a specific release targeted yet but the goal is for Q4 of 2021 for the migration tool and Pipelines so if there are automations that call table to table imports that you aren't able to easily transition today that is something we are working on.------------------------------Evan MartinezCommunity Marketing ManagerQuickbase------------------------------

markshnier__you · Answer

@AJ CampaniI do this all the time.&nbsp; Please post your setup for the Pipeline step.Here are my cheat notes. The URL is this and then Method is POST.

https://mycompany.quickbase.com/db/xxxxxxxxxx?a=API_RunImport&amp;id=11Method = POSTnothing else is required unless you need an app token.

------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

sethbienek · Answer

Hi Evan,Is the feature you described available in Pipelines yet?&nbsp; I don't see it, and I have a ton of Table-to-Table imports I'd like to move over to Pipelines, and rebuilding them as bulk upsert pipelines has been prohibitively time consuming so far.------------------------------Seth Bienek------------------------------

ajcampani · Answer

I'm interested in this feature as well; I tried Stephen's suggestion but I get a bad request error when the pipeline runs.------------------------------AJ Campani------------------------------

ajcampani · Answer

As always, many thanks Mark - I'm not sure what I was doing wrong initially, but I retyped the url as you suggested and it worked!------------------------------AJ Campani------------------------------

Forum Discussion

Table To Table Import - Pipelines Solution

7 Replies

Related Content

Building an Importer - Pipeline

Import Pipeline Workflow

Unlocking more Quickbase Power with QBL and Solution APIs

report solution

Pipeline Make Request - Return Make Request JSON Output into fields

Recent Discussions

Can I use quickbase actions within the same table?

Question about relationships

Reports & Charts - Managing Client-Specific Name Visibility

Summary Table Question

Google Search is back