ePallet ERP
ePallet ERP ETL connector for data replication
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 |
orders | products |
vendors | users |
customers | customer_groups |
- 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
- 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
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 |
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 |
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 |
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 |
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 |
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 |
Last modified 6mo ago