3PL Central
3PL is ETL connector for data replication
Last updated
3PL is ETL connector for data replication
Last updated
| Features | Details |
|---|---|
Sign in to Daton
Select 3PL Central from the list of Integrations
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
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
Purpose: This API is used to fetch all inventories
Source API Documentation: https://developer.3plcentral.com/#f00b82ce-9c3b-450b-b5f0-3f07eddde822
Replication: Full Replication
Replication Key: NA
Fields
Purpose: This API is used to returns all the orders.
Source API Documentation: https://developer.3plcentral.com/#b630ace1-e5ac-4d87-89fd-7139537d4222
Replication: Incremental
Replication Key: LastModifiedDate
Fields
| Name | Data Type |
|---|---|
Release Status
Released
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Client Id Client Secret User Name
Replication Type
Full Replication Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
1 hour
Inventory
Orders
receiverId
NUMERIC
receivedDate
DATETIME
receiveItemId
NUMERIC
customerIdentifier
RECORD
facilityIdentifier
RECORD
itemIdentifier
RECORD
itemDescription
STRING
qualifier
STRING
inventoryUnitOfMeasureIdentifier
RECORD
receivedQty
NUMERIC
onHandQty
NUMERIC
availableQty
NUMERIC
onHoldQty
NUMERIC
packagingUnitOfMeasureIdentifier
RECORD
primaryUnitsPerPackagingUnit
NUMERIC
availablePackaging
NUMERIC
onHandPackaging
NUMERIC
inventoryAgeDays
NUMERIC
lotNumber
NUMERIC
serialNumber
STRING
expirationDate
DATETIME
cost
NUMERIC
locationIdentifier
RECORD
palletIdentifier
RECORD
imperial
RECORD
onHold
BOOLEAN
quarantined
BOOLEAN
rowVersion
STRING
stockRowVersion
STRING
referenceNum
STRING
_links
RECORD
OrderItems
RECORD
ReferenceNum
STRING
Notes
STRING
NumUnits1
NUMERIC
TotalWeight
NUMERIC
TotalVolume
NUMERIC
BillingCode
STRING
AddFreightToCod
BOOLEAN
UpsIsResidential
BOOLEAN
MasterBillOfLadingId
STRING
InvoiceNumber
STRING
RoutingInfo
RECORD
ShipTo
RECORD
SoldTo
RECORD
BillTo
RECORD
SavedElements
RECORD
ParcelOption
RECORD
FulfillInvInfo
RECORD
OrderId
NUMERIC
Asncandidate
NUMERIC
RouteCandidate
NUMERIC
FullyAllocated
BOOLEAN
DeferNotification
BOOLEAN
IsClosed
BOOLEAN
ProcessDate
DATETIME
PickStarted
BOOLEAN
PackStarted
BOOLEAN
LoadedState
NUMERIC
RouteSent
BOOLEAN
AsnSent
BOOLEAN
ParcelLabelType
NUMERIC
CustomerIdentifier
RECORD
FacilityIdentifier
RECORD
WarehouseTransactionSourceType
STRING
TransactionEntryType
STRING
CreationDate
DATETIME
CreatedByIdentifier
RECORD
LastModifiedDate
DATETIME
LastModifiedByIdentifier
RECORD
Status
NUMERIC