# Integrate.io: English ETL & Reverse ETL ## ETL & Reverse ETL - [English / ETL & Reverse ETL / Knowledge Base (419 pages)](https://www.integrate.io/docs/_llms/en/etl-and-reverse-etl/knowledge-base.md): Documentation for English / ETL & Reverse ETL / Knowledge Base. ### Home - [ETL & Reverse ETL Documentation](https://www.integrate.io/docs/etl.md): Build visual data pipelines with Integrate.io ETL. Connect 150+ sources and destinations, transform data with built-in components, and schedule automated jobs. ### API Reference #### Clusters - [List Clusters](https://www.integrate.io/docs/api-reference/clusters/list-clusters.md): Returns a list of clusters associated with the authenticated account. - [Create Cluster](https://www.integrate.io/docs/api-reference/clusters/create-cluster.md): Creates a new cluster. A cluster is a group of machines (nodes) allocated exclusively to your account. You will need an active cluster to run jobs. - [Get Cluster Information](https://www.integrate.io/docs/api-reference/clusters/get-cluster-information.md): Returns details for the specified cluster, including its status. - [Update Cluster](https://www.integrate.io/docs/api-reference/clusters/update-cluster.md): Updates the specified cluster's settings, such as name, description, or node count. - [Terminate Cluster](https://www.integrate.io/docs/api-reference/clusters/terminate-cluster.md): Terminates the specified cluster, releasing its resources. Use this when all jobs on the cluster are completed. - [Search Clusters](https://www.integrate.io/docs/api-reference/clusters/search-clusters.md): Search clusters by name or description. - [Watch Cluster](https://www.integrate.io/docs/api-reference/clusters/watch-cluster.md): Subscribe to notifications for the specified cluster. #### Jobs - [List Jobs](https://www.integrate.io/docs/api-reference/jobs/list-jobs.md): Returns a list of jobs associated with the authenticated account. - [Run Job](https://www.integrate.io/docs/api-reference/jobs/run-job.md): Creates and runs a new job. You must specify the cluster to run on and the package whose workflow the job should perform. You can also pass static and dynamic variables. - [Get Job Information](https://www.integrate.io/docs/api-reference/jobs/get-job-information.md): Returns details for the specified job, including status, progress, and outputs. - [Terminate Job](https://www.integrate.io/docs/api-reference/jobs/terminate-job.md): Terminates the specified job, stopping its execution and releasing resources. - [List Job Children](https://www.integrate.io/docs/api-reference/jobs/list-job-children.md): Returns child jobs of the specified job. - [Get Job Execution Variables](https://www.integrate.io/docs/api-reference/jobs/get-job-execution-variables.md): Returns the execution variables for the specified job. - [Preview Job Output](https://www.integrate.io/docs/api-reference/jobs/preview-job-output.md): Returns a preview of the specified job output. - [Search Jobs](https://www.integrate.io/docs/api-reference/jobs/search-jobs.md): Search jobs by various criteria. - [Watch Job](https://www.integrate.io/docs/api-reference/jobs/watch-job.md): Subscribe to notifications for the specified job. #### Packages - [List Packages](https://www.integrate.io/docs/api-reference/packages/list-packages.md): Returns the list of packages in the account. - [Create Package](https://www.integrate.io/docs/api-reference/packages/create-package.md): Creates a new data flow package. - [Get Package Information](https://www.integrate.io/docs/api-reference/packages/get-package-information.md): Returns details for the specified package. - [Update Package](https://www.integrate.io/docs/api-reference/packages/update-package.md): Updates the specified package. - [Delete Package](https://www.integrate.io/docs/api-reference/packages/delete-package.md): Deletes the specified package. - [Export Package as JSON](https://www.integrate.io/docs/api-reference/packages/export-package-as-json.md): Exports the specified package definition as JSON. - [Search Packages](https://www.integrate.io/docs/api-reference/packages/search-packages.md): Search packages by name or description. #### Package Validations - [List Package Validations](https://www.integrate.io/docs/api-reference/package-validations/list-package-validations.md): Returns a list of validations for the specified package. - [Run Package Validation](https://www.integrate.io/docs/api-reference/package-validations/run-package-validation.md): Initiates an asynchronous validation of the specified package. - [Run Package Validation (Synchronous)](https://www.integrate.io/docs/api-reference/package-validations/run-package-validation-synchronous.md): Runs a synchronous validation of the specified package and waits for the result. - [Get Package Validation Information](https://www.integrate.io/docs/api-reference/package-validations/get-package-validation-information.md): Returns the status and result of a specific package validation. #### Schedules - [List Schedules](https://www.integrate.io/docs/api-reference/schedules/list-schedules.md): Returns all schedules in the account. - [Create Schedule](https://www.integrate.io/docs/api-reference/schedules/create-schedule.md): Creates a new schedule to run packages periodically. - [Get Schedule Information](https://www.integrate.io/docs/api-reference/schedules/get-schedule-information.md): Returns details for the specified schedule. - [Update Schedule](https://www.integrate.io/docs/api-reference/schedules/update-schedule.md): Updates the specified schedule. - [Delete Schedule](https://www.integrate.io/docs/api-reference/schedules/delete-schedule.md): Deletes the specified schedule. - [Run Schedule](https://www.integrate.io/docs/api-reference/schedules/run-schedule.md): Manually triggers the specified schedule to run immediately. - [Search Schedules](https://www.integrate.io/docs/api-reference/schedules/search-schedules.md): Searches the account's schedules by name or description. - [Watch Schedule](https://www.integrate.io/docs/api-reference/schedules/watch-schedule.md): Subscribe to notifications for the specified schedule. #### Deliveries - [List Deliveries](https://www.integrate.io/docs/api-reference/deliveries/list-deliveries.md): Returns all deliveries in the account. - [Create Delivery](https://www.integrate.io/docs/api-reference/deliveries/create-delivery.md): Creates a new data delivery blueprint. - [Get Delivery Information](https://www.integrate.io/docs/api-reference/deliveries/get-delivery-information.md): Returns details for the specified delivery blueprint. - [Delete Delivery](https://www.integrate.io/docs/api-reference/deliveries/delete-delivery.md): Deletes the specified delivery blueprint. #### Connections - [List Connection Types](https://www.integrate.io/docs/api-reference/connections/list-connection-types.md): Returns the list of available connection types. - [List Connections](https://www.integrate.io/docs/api-reference/connections/list-connections.md): Returns all connections in the account. - [Create Connection](https://www.integrate.io/docs/api-reference/connections/create-connection.md): Creates a new connection to a data source or destination. - [Get Connection Information](https://www.integrate.io/docs/api-reference/connections/get-connection-information.md): Returns details for the specified connection. - [Update Connection](https://www.integrate.io/docs/api-reference/connections/update-connection.md): Updates the specified connection's settings. - [Delete Connection](https://www.integrate.io/docs/api-reference/connections/delete-connection.md): Deletes the specified connection. - [Test Connection](https://www.integrate.io/docs/api-reference/connections/test-connection.md): Tests the specified existing connection to verify it can connect. - [Validate Connection](https://www.integrate.io/docs/api-reference/connections/validate-connection.md): Validates the specified connection's configuration. - [Test New Connection](https://www.integrate.io/docs/api-reference/connections/test-new-connection.md): Tests a new connection before creating it. - [Import Connection Schema](https://www.integrate.io/docs/api-reference/connections/import-connection-schema.md): Retrieves the schema (tables, columns) from the specified connection. - [List Salesforce Objects](https://www.integrate.io/docs/api-reference/connections/list-salesforce-objects.md): Returns the Salesforce objects available through the specified connection. - [List Salesforce Fields](https://www.integrate.io/docs/api-reference/connections/list-salesforce-fields.md): Returns the fields available on the specified Salesforce object. - [List Google Analytics Accounts](https://www.integrate.io/docs/api-reference/connections/list-google-analytics-accounts.md): Returns the Google Analytics accounts available through the specified connection. - [List Google AdWords Customers](https://www.integrate.io/docs/api-reference/connections/list-google-adwords-customers.md): Returns the Google AdWords customers available through the specified connection. - [List Facebook Ads Insights Accounts](https://www.integrate.io/docs/api-reference/connections/list-facebook-ads-insights-accounts.md): Returns the Facebook Ads Insights accounts available through the specified connection. - [List Facebook Ads Insights Fields](https://www.integrate.io/docs/api-reference/connections/list-facebook-ads-insights-fields.md): Returns the Facebook Ads Insights fields available through the specified connection. - [List Bing Ads Accounts](https://www.integrate.io/docs/api-reference/connections/list-bing-ads-accounts.md): Returns the Bing Ads accounts available through the specified connection. - [List Bing Ads Columns](https://www.integrate.io/docs/api-reference/connections/list-bing-ads-columns.md): Returns the Bing Ads columns available through the specified connection. #### Connection Groups - [List Connection Groups](https://www.integrate.io/docs/api-reference/connection-groups/list-connection-groups.md): Returns all connection groups in the account. Each group includes the database and cloud storage connections assigned to it. - [Create Connection Group](https://www.integrate.io/docs/api-reference/connection-groups/create-connection-group.md): Creates a new connection group. Pass an optional `connections` array to assign existing database and cloud storage connections to the group on creation. All referenced connections must belong to the same account. - [Search Connection Groups](https://www.integrate.io/docs/api-reference/connection-groups/search-connection-groups.md): Searches connection groups in the account by name or description. - [Get Connection Group](https://www.integrate.io/docs/api-reference/connection-groups/get-connection-group.md): Returns the specified connection group, including the connections assigned to it. - [Update Connection Group](https://www.integrate.io/docs/api-reference/connection-groups/update-connection-group.md): Updates a connection group's name or description. Pass a `connections` array to replace the group's assigned connections. Connections not listed in the request are detached from the group; new ones are attached. Connections must belong to the same account as the group. - [Delete Connection Group](https://www.integrate.io/docs/api-reference/connection-groups/delete-connection-group.md): Deletes the specified connection group. Connections previously assigned to it become ungrouped; the connections themselves are not deleted. #### Accounts - [List Accounts](https://www.integrate.io/docs/api-reference/accounts/list-accounts.md): Returns accounts the authenticated user has access to. - [Create Account](https://www.integrate.io/docs/api-reference/accounts/create-account.md): Creates a new Integrate.io account. - [Get Current Account](https://www.integrate.io/docs/api-reference/accounts/get-current-account.md): Returns the current account information. - [Update Account](https://www.integrate.io/docs/api-reference/accounts/update-account.md): Updates the current account's settings. - [Delete Account](https://www.integrate.io/docs/api-reference/accounts/delete-account.md): Deletes the current account. #### Members - [List Account Members](https://www.integrate.io/docs/api-reference/members/list-account-members.md): Returns all members of the current account. - [Add Account Member](https://www.integrate.io/docs/api-reference/members/add-account-member.md): Invites a new member to the current account with the specified role. - [Get Account Member Information](https://www.integrate.io/docs/api-reference/members/get-account-member-information.md): Returns details for the specified account member. - [Update Account Member Role](https://www.integrate.io/docs/api-reference/members/update-account-member-role.md): Updates the role assigned to the specified account member. - [Remove Account Member](https://www.integrate.io/docs/api-reference/members/remove-account-member.md): Removes the specified member from the account. #### Users - [Get Authenticated User Information](https://www.integrate.io/docs/api-reference/users/get-authenticated-user-information.md): Returns information about the currently authenticated user. - [Update Authenticated User](https://www.integrate.io/docs/api-reference/users/update-authenticated-user.md): Updates the currently authenticated user's information. - [Regenerate Authenticated User Tokens](https://www.integrate.io/docs/api-reference/users/regenerate-authenticated-user-tokens.md): Regenerates the API key for the authenticated user. - [Reset User Password](https://www.integrate.io/docs/api-reference/users/reset-user-password.md): Sends a password reset email to the specified address. #### Public Keys - [List User Public Keys](https://www.integrate.io/docs/api-reference/public-keys/list-user-public-keys.md): Returns the SSH public keys belonging to the authenticated user. - [Create Public Key](https://www.integrate.io/docs/api-reference/public-keys/create-public-key.md): Adds a new SSH public key for the authenticated user. - [Get Public Key Information](https://www.integrate.io/docs/api-reference/public-keys/get-public-key-information.md): Returns details for the specified SSH public key. - [Delete Public Key](https://www.integrate.io/docs/api-reference/public-keys/delete-public-key.md): Deletes the specified SSH public key. #### Notifications - [List User Notifications](https://www.integrate.io/docs/api-reference/notifications/list-user-notifications.md): Returns the authenticated user's notifications. - [Mark Notifications as Read](https://www.integrate.io/docs/api-reference/notifications/mark-notifications-as-read.md): Marks one or all notifications as read. #### Hooks - [List Hook Types](https://www.integrate.io/docs/api-reference/hooks/list-hook-types.md): Returns available webhook event types. - [List Hooks](https://www.integrate.io/docs/api-reference/hooks/list-hooks.md): Returns all webhooks in the account. - [Create Hook](https://www.integrate.io/docs/api-reference/hooks/create-hook.md): Creates a new webhook for event notifications. - [Get Hook Information](https://www.integrate.io/docs/api-reference/hooks/get-hook-information.md): Returns details for the specified webhook. - [Update Hook](https://www.integrate.io/docs/api-reference/hooks/update-hook.md): Updates the specified webhook's settings. - [Delete Hook](https://www.integrate.io/docs/api-reference/hooks/delete-hook.md): Deletes the specified webhook. - [Ping Hook](https://www.integrate.io/docs/api-reference/hooks/ping-hook.md): Sends a test ping to the specified webhook. - [Reset Hook Salt](https://www.integrate.io/docs/api-reference/hooks/reset-hook-salt.md): Resets the signing salt for the specified webhook. - [Search Hooks](https://www.integrate.io/docs/api-reference/hooks/search-hooks.md): Searches the account's webhooks. #### System - [List Available Regions](https://www.integrate.io/docs/api-reference/system/list-available-regions.md): Returns the regions available to Integrate.io. - [List Available Account Regions](https://www.integrate.io/docs/api-reference/system/list-available-account-regions.md): Returns the regions available to the current account. - [List Supported Stacks](https://www.integrate.io/docs/api-reference/system/list-supported-stacks.md): Returns the Hadoop stacks supported for clusters. - [List System Variables](https://www.integrate.io/docs/api-reference/system/list-system-variables.md): Returns the system variables available in expressions. - [List Supported Time Zones](https://www.integrate.io/docs/api-reference/system/list-supported-time-zones.md): Returns the time zones supported for scheduling. - [List Product Updates](https://www.integrate.io/docs/api-reference/system/list-product-updates.md): Returns recent Integrate.io product updates. - [Get Rate Limit Status](https://www.integrate.io/docs/api-reference/system/get-rate-limit-status.md): Returns current rate limit status. This call does not count against your rate limit. - [Help](https://www.integrate.io/docs/api-reference/system/help.md): Returns API help information and available endpoints. #### Billing - [Get Account Payment Method](https://www.integrate.io/docs/api-reference/billing/get-account-payment-method.md): Returns the payment method on file for the current account. - [Get Subscription Information](https://www.integrate.io/docs/api-reference/billing/get-subscription-information.md): Returns the current account's subscription details. - [List Invoices](https://www.integrate.io/docs/api-reference/billing/list-invoices.md): Returns the invoices for the current account. - [Get Invoice Information](https://www.integrate.io/docs/api-reference/billing/get-invoice-information.md): Returns details for the specified invoice. ### MCP #### Get started - [ETL: MCP Server Overview & Connect](https://www.integrate.io/docs/etl/integrateio-mcp-server.md): Connect AI agents like Claude and ChatGPT to your Integrate.io ETL account through the Model Context Protocol server to inspect pipelines. #### Tool reference - [ETL: MCP Reading & Inspecting Tools](https://www.integrate.io/docs/etl/mcp-tools-reading.md): Reference for the read-only Integrate.io MCP tools that inspect connections, packages, runs, schemas, and data quality. - [ETL: Building & Editing Packages with MCP Tools](https://www.integrate.io/docs/etl/creating-packages-with-mcp-tools.md): Use the Integrate.io MCP server to let Claude, Cursor, or the MCP Inspector author, edit, and clean up ETL packages without opening the web UI. - [ETL: MCP Jobs & Schedules Tools](https://www.integrate.io/docs/etl/mcp-tools-jobs-schedules.md): Reference for the Integrate.io MCP tools that inspect runs, manage schedules, and run, cancel, or retry jobs. ## OpenAPI Specs - [integrateio-openapi](/docs/integrateio-openapi.yaml)