Looking to import data into my Quickbase Application from a different source

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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!
Photo of SammyS


  • 256 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Here's the url for the API reference:

You can use this api call to import most data:

If you need to import file attachments you need this call:

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..
Photo of SammyS


  • 256 Points 250 badge 2x thumb
Thanks Neil, I'll look further into this.  Should be a good start!