Mercado Libre

Mercado Libre 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
Client ID
Client Secret
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1 hour
Tables/APIs supported
orders
shipments
inventory_items
seller_promotions
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
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
shipments
Purpose: This API is used to fetch details of all shipment related info about orders in the seller's account
Source API Documentation: https://developers.mercadolibre.com.ar/en_us/shipping​
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
inventory_items
Purpose: This API is used to fetch details of all inventory items for the seller
Source API Documentation: https://developers.mercadolibre.com.mx/es_ar/stock-de-fulfillment​
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
seller_promotions
Purpose: This API is used to fetch details of all seller promotions that are available in the logged in seller account
Source API Documentation: https://developers.mercadolibre.com.mx/es_ar/central-de-promociones​
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

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

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

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

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

Name	Data Type
id	STRING
type	STRING
status	STRING
start_date	TIMESTAMP
finish_date	TIMESTAMP
deadline_date	TIMESTAMP
name	STRING
benefits	RECORD

Release Notes

Shopify

Last modified 1mo ago