Loopreturns

Loopreturns ETL connector for data replication

Snapshot

FeaturesDetails

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

fullnametype

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

fullnametype

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 updated