Example Flow API Scripts

Note

This is a Preview feature.

Example Bash Script: Automate Ingest Setup and Full Extract via API

This example Bash script automates the full setup of the Ingest UI checklist using API calls. It sets up a source MySQL database connection and a destination SingleStore database hosted in Helios, selects a table from a sample MySQL database called classicmodels, configures a periodic schedule, adds a license key, and finally triggers a full extract.

Note: Modify source and destination database configuration, table names, schedule, and license key to suit your environment.

Example Python Script: Automate Ingest Setup and Full Extract via API

This example Python script automates the full setup of the Ingest UI checklist using API calls. It sets up a source MySQL database connection and a destination SingleStore database hosted in Helios, selects a table from a sample MySQL database called classicmodels, configures a periodic schedule, adds a license key, and finally triggers a full extract.

Note: Modify source and destination database configuration, tables, schedule, and license key to suit your environment.

Example Bash Script: Automate Sliced Data Transfer via XL Ingest APIs

This example Bash script automates sliced data transfer using XL Ingest APIs. It assumes that the source and destination database connections are already configured in Ingest. The script selects a table, configures it to skip the initial extract (schema-only transfer), triggers a full extract, applies a license key in XL Ingest, sets up table slices based on a column (orderNumber), and finally triggers a sliced data transfer.

Note: Modify table names, slice values, and license key to suit your environment.

Example Python Script: Automate Sliced Data Transfer via XL Ingest APIs

This example Python script automates sliced data transfer using XL Ingest APIs. It assumes that the source and destination database connections are already configured in Ingest. The script selects a table, configures it to skip the initial extract (schema-only transfer), triggers a full extract, applies a license key in XL Ingest, sets up table slices based on a column (orderNumber), and finally triggers a sliced data transfer.

Note: Modify table names, slice values, and license key to suit your environment.

Last modified:

Was this article helpful?