Integration Specifications

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.

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:

• Enterprise

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:

• Returns

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Returnly integration illustrating the different tables and keys to join across tables.

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

• Return Line Items

• Refunds

• Refund Vouchers

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