Loopreturns

Loopreturns ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	V1
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	API Key
Replication Type	Full Replication Key Based Incremental
Replication Key	Date
Suggested Replication Frequency	1 hour

Tables/APIs supported

Return_list	Return_detail

Integrate Loopreturns with Daton

1. Sign in to Daton

2. Select Loopreturns from the list of Integrations

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide Loopreturns API Key. Follow this link for more information.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Loopreturns Data

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