← Back to Topic
Editing: Magento → NetSuite (v12 → v13)
Extractors
Magento2 Rest REST API
Endpoint: /rest/V1/orders
Columns: entity_id, customer_email, status, total_paid, items
Magento2 Rest REST API
Endpoint: /rest/V1/customers
Columns: id, email, firstname, lastname
Transformers
Column Mappings
order.entity_id→orderId
customer.email→customerEmail
order.total_paid→amount
order.status→fulfillmentStatus
Interim DB Preview (4 columns, 3 rows)
| orderId | customerEmail | amount | fulfillmentStatus |
|---|---|---|---|
| 10042 | alice@acme.com | 149.97 | processing |
| 10043 | bob@widgets.co | 89.5 | complete |
| 10044 | carol@example.com | 245 | pending |
Preview showing 3 of 1,247 rows.
Loaders
Netsuite Rest REST API
Endpoint: /services/rest/record/v1/salesorder
Mode: Upsert (match on orderId)