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. 1.
    Sign in to Daton
  2. 2.
    Select Mercado Libre from the list of Integrations
  3. 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. 4.
    Provide Client ID and Client Secret in the next step. Follow this link to create these details
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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
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