Integration: Returnly

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

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 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