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.&nbsp; 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&nbsp;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.&nbsp; 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...&nbsp;Good luck..Neil&nbsp;

sammyssammys · Answer

Thanks Neil, I'll look further into this.&nbsp; Should be a good start!

Forum Discussion

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

2 Replies

Related Content

Same reference field, different selections within the form

Creating different colors for Quickbase icons

Introducing New Quickbase Navigation (beta)

Can I use quickbase actions within the same table?

Technical limitation different between Application Manager and Administrator

Recent Discussions

Empower Hour Tomorrow!

When the Expiration Date is On or Before Today, Change the Contract Status to Expired

Rollup Help

New Forms Return and Cancel Buttons Glitch

How to handle error in Upload step in Pipeline