How Can I Add Row Filter Values in Bulk?

Question

In Fivetran, I can only add row filter values individually through the dashboard. How can I add them in bulk?

Environment

All connectors

Answer

Use the Fivetran REST API to add multiple row filter values in a single request:

1. Ensure you have the API credentials required to authenticate the request.
2. Prepare a PATCH request to the Update a Connection Schema Config endpoint.
3. Include all required filter values in the request body's row_filter configuration, then send the request.