ePallet ERP

ePallet ERP 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	None
Replication Type	Key Based Replication
Replication Key	from, to
Suggested Replication Frequency	1 hour

Tables/APIs Supported

orders	products
vendors	users
customers	customer_groups

Integrate ePallet ERP with Daton

1. Sign in to Daton

2. Select ePallet ERP 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 ePallet's API Key for authentication

5. Post successful authentication you will be prompted to choose required tables

6. Then select all required fields

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

ePallet ERP Data

orders

Purpose: This API is used to fetch the orders associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
order_number	STRING
status	STRING
date_placed	TIMESTAMP
last_updated	TIMESTAMP
has_tracking_number	STRING
fob_company_name	STRING
fob_location_address	STRING
delivery_address	STRING
shipping_service	STRING
payment_status	STRING
is_flat_rate	BOOLEAN
total_delivered_price	NUMERIC
total_delivery_price	NUMERIC
total_payment_option_discount	STRING
total_coupons_amount	STRING
total_vendor_coupons_amount	STRING
total_off_invoice	NUMERIC
total_bill_back_deduction	NUMERIC
total_redemption_value	NUMERIC
total_tax_value	NUMERIC
total_price	NUMERIC
grand_total_price	STRING
grand_total_delivered_price	STRING
epallet_profit	NUMERIC
epallet_profit_percentage	STRING
net_to_bank	NUMERIC
customer	RECORD
vendor	RECORD
order_pallets	RECORD
fob_delivery_accessorials	STRING
shipping_delivery_accessorials	STRING
tags	RECORD

products

Purpose: This API is used to fetch the products associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
name	STRING
upc	STRING
brand_name	STRING
pack_size	STRING
vendor_name	STRING
customer_groups	STRING
last_updated_pricing_time_stamp	STRING
product_category	STRING
product_code	NUMERIC
last_updated	TIMESTAMP

vendors

Purpose: This API is used to fetch the vendors associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

id	Data Type
id	NUMERIC
image	STRING
email	STRING
contact_name	STRING
status	STRING
company_name	STRING
last_login	TIMESTAMP
company_email	STRING
title	STRING
fax	STRING
address	STRING
phone_number	STRING
company_type	STRING
billing_contact_name	STRING
billing_company_name	STRING
billing_company_email	STRING
billing_address	STRING
billing_phone_number	STRING
website	STRING
first_po_date	STRING
payment_overdue	STRING
subscription_plan	STRING
last_updated	TIMESTAMP

users

Purpose: This API is used to fetch the users associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
email	STRING
company_name	STRING
is_active	BOOLEAN
email_verified	BOOLEAN
is_customer	BOOLEAN
is_vendor	BOOLEAN
customer_groups	STRING
last_updated	TIMESTAMP

customers

Purpose: This API is used to fetch the customers associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
id	NUMERIC
date_created	TIMESTAMP
contact_name	STRING
company_name	STRING
company_email	STRING
title	STRING
fax	STRING
address	STRING
status	STRING
phone_number	STRING
customer_groups	STRING
salesperson_email	STRING
is_active	BOOLEAN
email	STRING
need_validation	BOOLEAN
billing_contact_name	STRING
billing_company_name	STRING
billing_company_email	STRING
billing_address	STRING
billing_phone_number	STRING
last_login_datetime	STRING
last_updated	TIMESTAMP

customer_groups

Purpose: This API is used to fetch the customer_groups associated with the account

Replication: Key Based Incremental

Replication Key: from, to

Fields

Name	Data Type
name	STRING
has_discount	BOOLEAN
is_free_from_taxes	BOOLEAN
available_for_registration	BOOLEAN
assigned_customer	NUMERIC
assigned_products	NUMERIC
last_updated	TIMESTAMP