Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Loopreturns connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Loopreturns connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Loopreturns connector:
- Return list
- Return detail
Return list
Purpose: This endpoint is used to fetch a list of all returns that were created within a given timeframe
Source API Documentation: https://docs.loopreturns.com/reference/detailed-returns-list
Replication: Key-Based Incremental
Fields
Fullname |
Type |
|---|---|
id |
STRING |
state |
STRING |
created_at |
TIMESTAMP |
updated_at |
TIMESTAMP |
total |
STRING |
order_id |
STRING |
order_name |
STRING |
provider_order_id |
STRING |
order_number |
STRING |
customer |
STRING |
multi_currency |
BOOLEAN |
currency |
STRING |
return_product_total |
STRING |
return_discount_total |
STRING |
return_tax_total |
STRING |
return_total |
STRING |
return_credit_total |
STRING |
exchange_product_total |
STRING |
exchange_discount_total |
STRING |
exchange_tax_total |
STRING |
exchange_total |
STRING |
exchange_credit_total |
STRING |
gift_card |
STRING |
handling_fee |
STRING |
refund |
STRING |
upsell |
STRING |
line_items |
RECORD |
carrier |
STRING |
tracking_number |
STRING |
label_status |
STRING |
status_page_url |
STRING |
label_updated_at |
TIMESTAMP |
destination_id |
NUMERIC |
package_reference |
STRING |
outcome |
STRING |
label_url |
STRING |
label_rate |
NUMERIC |
exchanges |
RECORD |
gift_card_order_name |
STRING |
gift_card_order_id |
NUMERIC |
| edited_at | TIMESTAMP |
Return detail
Purpose: This API is used to get the details of a specific return
Source API Documentation: https://docs.loopreturns.com/reference/return-details
Replication: Key-Based Incremental
Fields
Fullname |
Type |
|---|---|
id |
NUMERIC |
created_at |
DATETIME |
order_id |
NUMERIC |
order_name |
STRING |
order_number |
NUMERIC |
state |
STRING |
currency |
STRING |
exchange |
STRING |
gift_card |
STRING |
refund |
STRING |
return_total |
STRING |
line_items |
RECORD |
customer_email |
STRING |
carrier |
STRING |
label_status |
STRING |
label_updated_at |
STRING |
tracking_number |
STRING |
destination_id |
NUMERIC |
status_page_url |
STRING |
package_reference |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
label_url |
STRING |
label_rate |
NUMERIC |
outcome |
STRING |
created_at_st |
STRING |
exchange_order_name |
STRING |
exchange_order_id |
STRING |
gift_card_order_name |
STRING |
| gift_card_order_id | NUMERIC |