Dear
Dear ETL connector for data replication
Snapshot
Tables/APIs supported
Integrate Dear with Daton
Sign in to Daton
Select Byrd 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
Provide Dear Account ID and Application Secret. These can be created on the API setup page inside DEAR Inventory application: https://inventory.dearsystems.com/ExternalAPI.
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
Workflow
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
Dear Data
accounts
Purpose: This API is used to fetch all accounts data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/chart-of-accounts/chart-of-accounts/get
Replication: Full Replication
Replication Key: NA
Fields
customers
Purpose: This API is used to fetch all customers data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/customer/customer/get
Replication: Key Based Incremental
Replication Key: ModifiedSince
Fields
suppliers
Purpose: This API is used to fetch all suppliers data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/supplier/supplier/get
Replication: Key Based Incremental
Replication Key: ModifiedSince
Fields
transactions
Purpose: This API is used to fetch all transaction related data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/transactions/transactions/get
Replication: Key Based Incremental
Replication Key: FromDate, ToDate
Fields
products
Purpose: This API is used to fetch all products
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/product/product/get
Replication: Key Based Incremental
Replication Key: ModifiedSince
Fields
product_availability_list
Purpose: This API is used to fetch data related to product availability
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/product/product-availability/get
Replication: Full Replication
Replication Key: NA
Fields
brands
Purpose: This API is used to fetch all brands
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/brand/brand/get
Replication: Full Replication
Replication Key: NA
Fields
tax
Purpose: This API is used to fetch all tax related data
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/tax/tax/get
Replication: Full Replication
Replication Key: NA
Fields
carriers
Purpose: This API is used to fetch all carrier related information
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/carrier/carrier/get
Replication: Full Replication
Replication Key: NA
Fields
payment_terms
Purpose: This API is used to fetch all payment terms of the account
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/payment-term/payment-term/get
Replication: Full Replication
Replication Key: NA
Fields
locations
Purpose: This API is used to fetch all locations
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/location/location/get
Replication: Full Replication
Replication Key: NA
Fields
disassembly_lists
Purpose: This API is used to fetch all disassembly lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/disassembly/disassembly-list/get
Replication: Full Replication
Replication Key: NA
Fields
finished_goods_lists
Purpose: This API is used to fetch all finished goods lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/finished-goods/finished-goods-list/get
Replication: Full Replication
Replication Key: NA
Fields
inventory_write_off_lists
Purpose: This API is used to fetch the list of inventory write offs
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/inventory-write-off/inventory-write-off-list/get
Replication: Full Replication
Replication Key: NA
Fields
sale_list
Purpose: This API is used to fetch all sales list
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/sale/sale-list/get
Replication: Key Based Incremental
Replication Key: UpdatedSince
Fields
purchase_list
Purpose: This API is used to fetch all purchase lists
Source API Documentation: https://dearinventory.docs.apiary.io/#reference/purchase/purchase-list/get
Replication: Key Based Incremental
Replication Key: UpdatedSince
Fields
Last updated