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

Question

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!

NeilServices · Answer

Sammy,Here's the url for the API reference:https://help.quickbase.com/api-guide/index.htmlYou 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 linkSelect import from a fileChoose the table you want to import toChoose 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

Sign up

Login to the community