This article will help you learn about how Daasity replicates data from Returnly, limitations to the data we can extract and where the data is stored in the Returnly schema.
Key Topics
Click on the links below to take you to the section where you can learn more about this Integration
- Integration Overview
- Integration Availability
- API Endpoints
- Entity Relationship Diagram
- Returnly Schema
- Related Resources
Integration Overview
Returnly is a digital return-and-exchange platform for DTC brands. It allows customers to instantly shop again when making a return. Returnly pays for the new items up front and takes on the product risk, so orders ship right away, providing the ultimate shopping experience.
This document provides context on what kind of data is being gathered through this extractor, which endpoints that data is coming from, and how the extracted tables relate to each other.
Integration Availability
This integration is available for:
- Pro (V1 and V2)
NOTE: You are considered V2 if...
- You are a Growth customer
- Your account says Pro V2 in the Daasity App
Not sure? Reach out to Support@Daasity.com
API Endpoints
The Daasity Returnly extractor is built based on this Returnly API documentation. The following endpoint is used by Daasity to replicate data from Returnly:
Entity Relationship Diagram (ERD)
The Daasity Returnly extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Returnly Schema
The Daasity Returnly extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Returns
- Endpoint: Returns
- Update Method: UPSERT
- Table Name: returnly.returns
JSON Element | Database Column |
returns::id | id |
returns::rma | rma |
returns::email | |
returns::currency | currency |
returns::status | status |
returns::order_shipping_refund | order_shipping_refund |
returns::return_shipping_quote_amount | return_shipping_quote_amount |
returns::return_shipping_refund_amount | return_shipping_refund_amount |
returns::return_shipping_paid_amount | return_shipping_paid_amount |
returns::subtotal_amount | subtotal_amount |
returns::estimated_refund_amount | estimated_refund_amount |
returns::refund_amount | refund_amount |
returns::restocking_fee_amount | restocking_fee_amount |
returns::tax_amount | tax_amount |
returns::discount_amount | discount_amount |
returns::shopper_message | shopper_message |
returns::is_exchange | is_exchange |
returns::is_gift | is_gift |
returns::is_exempt_from_shipping | is_exempt_from_shipping |
returns::return_label_amount | return_label_amount |
returns::created_at | created_at |
returns::updated_at | updated_at |
returns::refunded_at | refunded_at |
Daasity: shop_id | _shop_id |
Daasity: timestamp when loaded into DB | __synced_at |
Return Line Items
- Endpoint: Returns
- Update Method: UPSERT
- Table Name: returnly.return_line_items
JSON Element | Database Column |
line::id | id |
returns::id | return_id |
line::ext_order_line_item_id | ext_order_line_item_id |
line::ext_order_id | ext_order_id |
line::ext_order_number | ext_order_number |
line::sku | sku |
line::product_id | product_id |
line::variant_id | variant_id |
line::return_cause | return_cause |
line::original_amount | original_amount |
line::discount_amount | discount_amount |
line::estimated_refund_amount | estimated_refund_amount |
line::restocking_fee_amount | restocking_fee_amount |
line::order_shipping_refund_amount | order_shipping_refund_amount |
line::return_label_cost_amount | return_label_cost_amount |
line::return_shipping_paid_amount | return_shipping_paid_amount |
line::total_refund_amount | total_refund_amount |
line::tax_amount | tax_amount |
line::units | units |
Daasity: shop_id | _shop_id |
Daasity: timestamp when loaded into DB | __synced_at |
Refunds
- Endpoint: Returns
- Update Method: UPSERT
- Table Name: returnly.refunds
JSON Element | Database Column |
refund::id | id |
returns::id | return_id |
refund::ext_order_number | ext_order_number |
refund::ext_refund_id | ext_refund_id |
refund::refund_amount | refund_amount |
refund::created_at | created_at |
refund::updated_at | updated_at |
Daasity: shop_id | _shop_id |
Daasity: timestamp when loaded into DB | __synced_at |
Refund Vouchers
- Endpoint: Returns
- Update Method: UPSERT
- Table Name: returnly.refund_vouchers
JSON Element | Database Column |
voucher::id | id |
returns::id | return_id |
voucher::status | status |
voucher::credit_issued_amount | credit_issued_amount |
voucher::credit_spent_amount | credit_spent_amount |
voucher::merchant_invoice_amount | merchant_invoice_amount |
voucher::refund_to_shopper_amount | refund_to_shopper_amount |
voucher::shopper_invoice_amount | shopper_invoice_amount |
voucher::ext_voucher_id | ext_voucher_id |
Daasity: shop_id | _shop_id |
Daasity: timestamp when loaded into DB | __synced_at |
Related Resources