Discussions

 View Only
  • 1.  Looking to import data into my Quickbase Application from a different source

    Posted 07-09-2018 20:15
    Hi,

    I'm fairly new to Quickbase and wanted to see how possible it would be to import data from a separate database into a Quickbase table, possibly through an API.  From what I've read, Quickbase offers their own API functionality, but from what I understand it's either:

    A. API for importing data from one __QB table or QB application to another (I believe it's called API_RunImport).

    B. API for exporting data from Quickbase to another source (I might be mistaken on this, just remember reading it at some point).

    Regardless, I haven't been able to quite find any guide or further information on importing data into Quickbase from a third party source.  If you have any information/links that could point me in the right direction that would be great.

    Thank you!


  • 2.  RE: Looking to import data into my Quickbase Application from a different source

    Posted 07-09-2018 20:34
    Sammy,
    Here's the url for the API reference:
    https://help.quickbase.com/api-guide/index.html

    You can use this api call to import most data:
    https://help.quickbase.com/api-guide/index.html#importfromcsv.html%3FTocPath%3DQuick%2520Base%2520AP...

    If you need to import file attachments you need this call:
    https://help.quickbase.com/api-guide/index.html#uploadfile.html%3FTocPath%3DQuick%2520Base%2520API%2...


    Also you can import data (and create columns in a table) using the import function that comes with native quickbase functionality..
    Click on the table you want to import data into..
    Click on the import/export link
    Select import from a file
    Choose the table you want to import to
    Choose the file (on you computer) that you want to import.

    To export data all you need to do is create a report with the data you want to export.
    Run the report.
    Click on the more button.
    Click Save as spreadsheet..



    This should get you started... 
    Good luck..
    Neil 


  • 3.  RE: Looking to import data into my Quickbase Application from a different source

    Posted 07-17-2018 17:51
    Thanks Neil, I'll look further into this.  Should be a good start!