← Back to Topic
Editing: CSV Import (v1 → v2)
Extractors
Sftp Csv REST API
Endpoint: /incoming/products.csv
Columns: sku, name, price, category, stock
Transformers
Column Mappings
csv.sku→productCode
csv.name→productName
csv.price→unitPrice
Interim DB Preview (3 columns, 3 rows)
| productCode | productName | unitPrice |
|---|---|---|
| SKU-001 | Widget A | 12.99 |
| SKU-002 | Widget B | 24.99 |
| SKU-003 | Gadget X | 49.99 |
Preview showing 3 of 1,247 rows.
Loaders
Postgres REST API
Endpoint: products
Mode: INSERT ON CONFLICT (sku) UPDATE