With the release of version 107, we are launching a new premium feature: Data Extract API. The new API enables you to efficiently move high volumes of solution data into your preferred data warehouse or data lake. Whether you’re using platforms like Snowflake, Google BigQuery, or Amazon Redshift, Data Extract API allows you to seamlessly integrate Appfarm data into your existing data transformation workflows.
What is Data Extract API?
Data Extract API is a set of endpoints designed to programmatically transfer solution data into data warehouses and data lakes for analysis and storage. You must set up your own processes to extract data from these endpoints, usually through ETL/ELT software.
How does it work?
The API provides object class-level export, allowing data export for specific object classes. When data export is enabled on an object-class, it will be available through a unique endpoint, making it easier to extract targeted data. Data is streamed through the API using cursor-based pagination, which handles large datasets efficiently. Access to these endpoints requires an API key generated from a service account that has explicit data export permissions.
Read more about the Data Extract API in our documentation.
Access to this feature is dependent on your subscription tier. Get in touch with your Appfarm representative to discuss how you can get access.