Lazada

Lazada ETL connector for data replication

Snapshot

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

Integrate Lazada with Daton

  1. Signin to Daton

  2. Select Lazada from Integrations page

  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 your Lazada client Id and client Secret (if you don't provide,Daton will use it's keys)

  5. After providing the keys, select the seller country , provide seller Email and Password to authorize Daton to periodically extract data from Lazada.

  6. Post successful authentication you will be prompted to choose from the list of available tables

  7. Then select all required fields for each table

  8. 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

Lazada Data

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

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

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

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