Discussions

 View Only
  • 1.  Run table to table import from pipeline

    Posted 09-11-2020 18:05
    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
    ------------------------------


  • 2.  RE: Run table to table import from pipeline

    Posted 09-12-2020 08:13
    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
    ------------------------------



  • 3.  RE: Run table to table import from pipeline

    Posted 09-14-2020 20:27
    Or in other words, do an automation and choose 'table to table import', and skip the pipeline. LOL.

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