Automating CSV imports
Learn about the different ways to automate recurring CSV imports into Endear.
Endear supports several options for automating recurring CSV imports. Choose the method that best fits your existing infrastructure and workflows.
SFTP
Upload CSV files to a dedicated SFTP endpoint provided by Endear or give Endear access to your own SFTP server. This is a common option for systems that support scheduled file exports, such as POS platforms and ERPs. Files placed in the SFTP directory are automatically picked up and processed on a regular schedule.
Cloud storage (S3, GCS, etc.)
Connect a cloud storage bucket — such as Amazon S3 or Google Cloud Storage — to Endear. CSV files uploaded to the configured bucket are automatically detected and imported. This is a good fit if your data pipelines already output files to cloud storage.
Data warehouses (BigQuery, Snowflake, etc.)
Export data directly from your data warehouse into Endear. If your team centralizes data in BigQuery, Snowflake, or a similar platform, you can schedule queries that produce CSV-formatted exports for Endear to consume.
API
For full programmatic control, use the GraphQL Admin API to push data into Endear directly. This is the most flexible option and is ideal for custom integrations or workflows that go beyond file-based imports.
Updated about 4 hours ago