Mercado Libre

Mercado Libre 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

Client ID Client Secret

Replication Type

Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

1 hour

Tables/APIs supported

  • orders

Note

While authenticating in Daton please use the seller credentials with Admin level permissions to pull the data

Integrate Mercado Libre with Daton

  1. Sign in to Daton

  2. Select Mercado Libre 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 Client ID and Client Secret in the next step. Follow this link to create these details

  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

Mercado Libre Data

orders

Purpose: This API is used to fetch details of all orders for the given client

Source API Documentation: https://developers.mercadolibre.com.ar/en_us/order-management

Replication: Key Based Incremental

Replication Key: date_last_updated

Fields

NameData Type

payments

RECORD

fulfilled

BOOLEAN

expiration_date

TIMESTAMP

shipping

RECORD

date_closed

TIMESTAMP

id

NUMERIC

order_items

RECORD

date_last_updated

TIMESTAMP

last_updated

TIMESTAMP

coupon

RECORD

date_created

TIMESTAMP

tags

STRING

buyer

RECORD

seller

RECORD

total_amount

NUMERIC

paid_amount

NUMERIC

mediations

RECORD

currency_id

STRING

status

STRING

cancel_detail

RECORD

context

RECORD

Last updated

Change request #551: Template