Lazada
Lazada ETL connector for data replication
Last updated
Lazada ETL connector for data replication
Last updated
Signin to Daton
Select Lazada from Integrations page
Provide Integration Name, Replication,Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Lazada client Id and client Secret (if you don't provide,Daton will use it's keys)
After providing the keys, select the seller country , provide seller Email and Password to authorize Daton to periodically extract data from Lazada.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
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
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Orders
Purpose: Use this API to get all the orders available. This API has list of items for a range of orders.
Source API Documentation https://open.lazada.com/doc/api.htm?spm=a2o9m.11193487.0.0.3ac413fe5Pix7F#/api?cid=8&path=/orders/get
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
MultipleOrderItems
Purpose:Use this API to get the item information of all the orders.
Source API Documentation: https://open.lazada.com/doc/api.htm?spm=a2o9m.11193487.0.0.3ac413fe5Pix7F#/api?cid=8&path=/orders/items/get
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Features
Details
Release Status
Released
Source API Version
v2
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Lazada App Id Lazada App secret Lazada Email Lazada password
Replication Type
Key based Replication
Replication Key
DATE
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
Orders
MultipleOrderItems
Name
Target Datatype
voucher_platform
NUMERIC
warehouse_code
STRING
voucher
NUMERIC
order_number
NUMERIC
voucher_seller
NUMERIC
created_at
TIMESTAMP
voucher_code
NUMERIC
gift_option
BOOLEAN
shipping_fee_discount_platform
NUMERIC
customer_last_name
STRING
updated_at
TIMESTAMP
promised_shipping_times
STRING
price
STRING
national_registration_number
NUMERIC
shipping_fee_original
NUMERIC
payment_method
STRING
customer_first_name
STRING
shipping_fee_discount_seller
NUMERIC
shipping_fee
NUMERIC
branch_number
STRING
tax_code
STRING
items_count
NUMERIC
delivery_info
STRING
statuses
STRING
address_billing
RECORD
extra_attributes
STRING
order_id
NUMERIC
gift_message
STRING
remarks
STRING
address_shipping
RECORD
Name
Target Datatype
tax_amount
NUMERIC
reason
STRING
sla_time_stamp
STRING
purchase_order_id
STRING
voucher_seller
NUMERIC
voucher_code_seller
NUMERIC
voucher_code
STRING
package_id
STRING
variation
STRING
voucher_code_platform
STRING
purchase_order_number
STRING
sku
STRING
invoice_number
STRING
order_type
STRING
cancel_return_initiator
STRING
shop_sku
STRING
stage_pay_status
STRING
tracking_code_pre
STRING
order_item_id
NUMERIC
shop_id
STRING
order_flag
STRING
name
STRING
order_id
NUMERIC
status
STRING
paid_price
NUMERIC
product_main_image
STRING
voucher_platform
NUMERIC
product_detail_url
STRING
promised_shipping_time
STRING
warehouse_code
STRING
shipping_type
STRING
created_at
STRING
updated_at
STRING
currency
STRING
shipping_provider_type
STRING
shipping_fee_original
NUMERIC
is_digital
NUMERIC
item_price
NUMERIC
shipping_service_cost
NUMERIC
tracking_code
STRING
shipping_amount
NUMERIC
reason_detail
STRING
return_status
STRING
shipment_provider
STRING
voucher_amount
NUMERIC
digital_delivery_info
STRING
extra_attributes
STRING