Skip to main content
Question

Table To Table Import - Pipelines Solution

  • August 5, 2021
  • 0 replies
  • 177 views
Hello all,

A lot of you may already know this but the migration tool cannot recreate table-to-table imports in pipelines.  When I asked the support group about this, they stated I would have to recreate the table-to-table solutions in pipelines.  That was all well and good but we have 20 apps and each one has 4 or 5 imports that run daily.   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&id=10
&usertoken=user_token



The 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. 

I've tried it and it works.  


    This topic has been closed for replies.

    Forum|alt.badge.img+17
    • EvanMartinez
    • Community Moderator
    • August 6, 2021
    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 Martinez
    Community Marketing Manager
    Quickbase
    ------------------------------
      Terms & ConditionsAccessibility statement