Loopreturns
Loopreturns ETL connector for data replication
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 |
Return_list | Return_detail |
- 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.
- 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
- 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
Purpose: This endpoint is used to fetch a list of all returns that were created within a given timeframe
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 |
Purpose: This API is used to get the details of a specific return
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 |
Last modified 3mo ago