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

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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!
Photo of SammyS

SammyS

  • 256 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
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 
Photo of SammyS

SammyS

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