read_transformations
Retrieve and manage SQL-based data transformations in CData Sync, including listing configurations, getting details, and counting ELT processes.
Instructions
Access data transformations that run SQL in the destination (ELT pattern).
RETURNS:
list: Array of transformation objects
get: Detailed transformation configuration
count: Total number of transformations
COMMON ERRORS:
"Transformation not found" - Check name spelling
"Access denied" - Verify permissions
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | No | Operation to perform | list |
| transformationName | No | Transformation name for 'get' action. Case-sensitive. | |
| filter | No | OData filter expression. SUPPORTED: eq, ne, gt, lt, ge, le, and, or Example: "Connection eq 'DataWarehouse' or TransformationTriggerMode eq 'AfterJob'" | |
| select | No | Properties to include | |
| top | No | Maximum results | |
| skip | No | Results to skip | |
| workspaceId | No | Workspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces. |