Getting Data out of Flatfile

Once your data has been uploaded, matched, and validated, there are several ways to extract your cleaned, pristine data.

Download

The simplest way to get your data out of Flatfile is to simply download it. After your data has been uploaded to a Workspace, you can open the Workspace it has been uploaded to, open the Files window, click on the file you want to download, and download your data. If you are using Portal, you can find all imported files in the Imports tab in the navigation bar on the far left of your dashboard.

REST Webhooks

Downloading each individual file can become cumbersome when you are dealing with lots of files from many different sources. You can automate the process of extracting data from Flatfile (we sometimes call this data egress) by using REST Webhooks. Webhooks for Portal 3.0 are set up on the Team page under the Webhook tab, and Webhooks for Portal 2.0 are set up in your config when implementing Flatfile. REST Webhooks can be configured to send you alerts when files enter certain stages of the data processing pipeline, or even send data to a specified endpoint when they have been completed (in Portal 2.0). To learn more about what REST Webhooks in Portal 3.0 can do, see our REST Webhooks documentation. For more information about Webhooks in Portal 2.0, click here. 

onData

Using the onData method in version 2.x of the Flatfile SDK for Portal 3.0, data can be streamed to your API in chunks as the user completes the import process, ensuring a quick retrieval of their import. For more information about how the onData method works, see our developer documentation. 

API

Lastly, you can also retrieve your data using one of our APIs. Completed batches can be retrieved for submission to your own database using our GraphQL or REST APIs to ensure the fastest delivery of your data. To see documentation on our REST API, click here. For our GraphQL documentation and playground, click here.