Mercado Libre
Mercado Libre 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 | Client ID
Client Secret |
Replication Type | Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | 1 hour |
- orders
- shipments
- inventory_items
- seller_promotions
While authenticating in Daton please use the seller credentials with Admin level permissions to pull the data

- 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.
- 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 API is used to fetch details of all orders for the given client
Replication: Key Based Incremental
Replication Key: date_last_updated
Fields
Name | Data 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 |
Purpose: This API is used to fetch details of all shipment related info about orders in the seller's account
Replication: Key Based Incremental from Orders table
Replication Key: date_last_updated
Fields
Name | Data Type |
---|---|
snapshot_packing | RECORD |
receiver_id | NUMERIC |
base_cost | NUMERIC |
status_history | RECORD |
type | STRING |
sender_id | NUMERIC |
mode | STRING |
order_cost | NUMERIC |
service_id | NUMERIC |
shipping_items | RECORD |
tracking_number | STRING |
cost_components | RECORD |
id | NUMERIC |
tracking_method | STRING |
last_updated | TIMESTAMP |
date_created | TIMESTAMP |
date_first_printed | TIMESTAMP |
created_by | STRING |
shipping_option | RECORD |
sender_address | RECORD |
site_id | STRING |
market_place | STRING |
receiver_address | RECORD |
order_id | NUMERIC |
status | STRING |
logistic_type | STRING |
Purpose: This API is used to fetch details of all inventory items for the seller
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
site_id | STRING |
title | STRING |
seller_id | NUMERIC |
category_id | STRING |
official_store_id | NUMERIC |
price | NUMERIC |
base_price | NUMERIC |
currency_id | STRING |
initial_quantity | NUMERIC |
available_quantity | NUMERIC |
sold_quantity | NUMERIC |
sale_terms | RECORD |
buying_mode | STRING |
listing_type_id | STRING |
start_time | TIMESTAMP |
stop_time | TIMESTAMP |
end_time | TIMESTAMP |
expiration_time | TIMESTAMP |
condition | STRING |
permalink | STRING |
thumbnail_id | STRING |
thumbnail | STRING |
secure_thumbnail | STRING |
pictures | RECORD |
accepts_mercadopago | BOOLEAN |
shipping | RECORD |
international_delivery_mode | STRING |
seller_address | RECORD |
geolocation | RECORD |
attributes | RECORD |
listing_source | STRING |
variations | RECORD |
status | STRING |
tags | STRING |
warranty | STRING |
domain_id | STRING |
automatic_relist | BOOLEAN |
date_created | TIMESTAMP |
last_updated | TIMESTAMP |
health | NUMERIC |
catalog_listing | BOOLEAN |
channels | STRING |
Purpose: This API is used to fetch details of all seller promotions that are available in the logged in seller account
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
id | STRING |
type | STRING |
status | STRING |
start_date | TIMESTAMP |
finish_date | TIMESTAMP |
deadline_date | TIMESTAMP |
name | STRING |
benefits | RECORD |
Last modified 1mo ago