Forum Discussion

StephenMadison's avatar
StephenMadison
Qrew Cadet
4 years ago

Table To Table Import - Pipelines Solution

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.  


  • 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
    ------------------------------
    • SethBienek's avatar
      SethBienek
      Qrew Member

      Hi Evan,

      Is the feature you described available in Pipelines yet?  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's avatar
      AJCampani
      Qrew Cadet
      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
      ------------------------------
    • LesKimbler's avatar
      LesKimbler
      Qrew Cadet

      Is this feature available yet? I have several Automations that have begun failing since the support went away, that are devastating to the work process.
      I have multiple Automations that their entire job is to run Table to Table imports, but everytime I have tried to Migrate them, they fail to migrate.
      I honestly hate pipelines because it is too complicated and convoluted to even try to figure out. But right now I'm having to run all these Daily Imports by hand because automations was taken away.



      ------------------------------
      Les Kimbler
      ------------------------------