Dear
Dear 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 | Account ID Application Key |
Replication Type | Full Replication Key Based Incremental |
Replication Key | Datetime |
Suggested Replication Frequency | 1 hour |
Tables/APIs supported
accounts | customers |
suppliers | transactions |
products | product_availability_list |
brands | tax |
payment_terms | carriers |
locations | disassembly_lists |
finished_goods_lists | inventory_write_off_lists |
purchase_list | sale_list |
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
| Name | Data Type |
|---|---|
Code | STRING |
Status | STRING |
Name | STRING |
Type | STRING |
Description | STRING |
Class | STRING |
ForPayments | BOOLEAN |
DisplayName | STRING |
SystemAccount | STRING |
SystemAccountCode | STRING |
BankAccountId | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
Currency | STRING |
PaymentTerm | STRING |
Discount | NUMERIC |
TaxRule | STRING |
Carrier | STRING |
SalesRepresentative | STRING |
Location | STRING |
Comments | STRING |
AccountReceivable | STRING |
RevenueAccount | STRING |
PriceTier | STRING |
TaxNumber | STRING |
Status | STRING |
CreditLimit | NUMERIC |
IsOnCreditHold | BOOLEAN |
LastModifiedOn | TIMESTAMP |
Addresses | RECORD |
Contacts | RECORD |
AdditionalAttribute1 | STRING |
AdditionalAttribute2 | STRING |
AdditionalAttribute3 | STRING |
AdditionalAttribute4 | STRING |
AdditionalAttribute5 | STRING |
AdditionalAttribute6 | STRING |
AdditionalAttribute7 | STRING |
AdditionalAttribute8 | STRING |
AdditionalAttribute9 | STRING |
AdditionalAttribute10 | STRING |
Tags | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
Currency | STRING |
PaymentTerm | STRING |
TaxRule | STRING |
Discount | NUMERIC |
AccountPayable | STRING |
Status | STRING |
LastModifiedOn | TIMESTAMP |
Contacts | RECORD |
Addresses | RECORD |
TaxNumber | STRING |
Comments | STRING |
AdditionalAttribute1 | STRING |
AdditionalAttribute2 | STRING |
AdditionalAttribute3 | STRING |
AdditionalAttribute4 | STRING |
AdditionalAttribute5 | STRING |
AdditionalAttribute6 | STRING |
AdditionalAttribute7 | STRING |
AdditionalAttribute8 | STRING |
AdditionalAttribute9 | STRING |
AdditionalAttribute10 | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
TaskID | STRING |
DebitAccountCode | STRING |
CreditAccountCode | STRING |
Amount | NUMERIC |
OriginalAmount | NUMERIC |
CurrencyRate | NUMERIC |
EffectiveDate | DATETIME |
Reference | STRING |
Transaction | STRING |
Type | STRING |
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
| Name | Data Type |
|---|---|
id | STRING |
sku | STRING |
name | STRING |
category | STRING |
type | STRING |
costingmethod | STRING |
dropshipmode | STRING |
defaultlocation | STRING |
length | NUMERIC |
width | NUMERIC |
height | NUMERIC |
weight | NUMERIC |
uom | STRING |
weightunits | STRING |
dimensionsunits | STRING |
barcode | STRING |
minimumbeforereorder | NUMERIC |
reorderquantity | NUMERIC |
pricetier1 | NUMERIC |
pricetier2 | NUMERIC |
pricetier3 | NUMERIC |
pricetier4 | NUMERIC |
pricetier5 | NUMERIC |
pricetier6 | NUMERIC |
pricetier7 | NUMERIC |
pricetier8 | NUMERIC |
pricetier9 | NUMERIC |
pricetier10 | NUMERIC |
pricetiers | RECORD |
averagecost | NUMERIC |
shortdescription | STRING |
internalnote | STRING |
description | STRING |
additionalattribute1 | STRING |
additionalattribute2 | STRING |
additionalattribute3 | STRING |
additionalattribute4 | STRING |
additionalattribute5 | STRING |
additionalattribute6 | STRING |
additionalattribute7 | STRING |
additionalattribute8 | STRING |
additionalattribute9 | STRING |
additionalattribute10 | STRING |
tags | STRING |
status | STRING |
stocklocator | STRING |
cogsaccount | STRING |
revenueaccount | STRING |
expenseaccount | STRING |
inventoryaccount | STRING |
purchasetaxrule | STRING |
saletaxrule | STRING |
lastmodifiedon | TIMESTAMP |
sellable | BOOLEAN |
pickzones | STRING |
billofmaterial | BOOLEAN |
autoassembly | BOOLEAN |
autodisassembly | BOOLEAN |
quantitytoproduce | NUMERIC |
alwaysshowquantity | NUMERIC |
assemblyinstructionurl | STRING |
assemblycostestimationmethod | STRING |
billofmaterialsproducts | RECORD |
movements | RECORD |
bomtype | STRING |
cartonheight | NUMERIC |
cartonwidth | NUMERIC |
cartonlength | NUMERIC |
cartonquantity | NUMERIC |
cartoninnerquantity | NUMERIC |
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
| Name | Data Type |
|---|---|
ID | STRING |
SKU | STRING |
Name | STRING |
Barcode | STRING |
Location | STRING |
Batch | STRING |
OnHand | NUMERIC |
Allocated | NUMERIC |
Available | NUMERIC |
OnOrder | NUMERIC |
StockOnHand | NUMERIC |
InTransit | NUMERIC |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
Account | STRING |
IsActive | BOOLEAN |
TaxInclusive | BOOLEAN |
TaxPercent | NUMERIC |
IsTaxForSale | BOOLEAN |
IsTaxForPurchase | BOOLEAN |
Components | RECORD |
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
| Name | Data Type |
|---|---|
CarrierID | STRING |
Description | STRING |
TrackingURL | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
Duration | NUMERIC |
Method | STRING |
IsActive | BOOLEAN |
IsDefault | BOOLEAN |
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
| Name | Data Type |
|---|---|
ID | STRING |
Name | STRING |
IsDefault | BOOLEAN |
IsDeprecated | BOOLEAN |
FixedAssetsLocation | BOOLEAN |
IsCoMan | BOOLEAN |
IsShopFloor | BOOLEAN |
IsStaging | BOOLEAN |
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
| Name | Data Type |
|---|---|
TaskID | STRING |
DisassemblyNumber | STRING |
Status | STRING |
ProductID | STRING |
ProductCode | STRING |
ProductName | STRING |
LocationID | STRING |
Location | STRING |
WIPAccount | STRING |
CompletionDate | DATETIME |
Quantity | NUMERIC |
AssemblyInstructionURL | STRING |
PickLines | RECORD |
OrderLines | RECORD |
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
| Name | Data Type |
|---|---|
TaskID | STRING |
AssemblyNumber | STRING |
Status | STRING |
ProductID | STRING |
ProductCode | STRING |
ProductName | STRING |
NonInventory | BOOLEAN |
LocationID | STRING |
Location | STRING |
WIPAccount | STRING |
WIPDate | DATETIME |
Account | STRING |
Quantity | NUMERIC |
AssemblyInstructionURL | STRING |
CompletionDate | DATETIME |
BatchSN | STRING |
Notes | STRING |
OrderLines | RECORD |
PickLines | RECORD |
Transactions | RECORD |
CustomField1 | STRING |
CustomField2 | STRING |
CustomField3 | STRING |
CustomField4 | STRING |
CustomField5 | STRING |
CustomField6 | STRING |
CustomField7 | STRING |
CustomField8 | STRING |
CustomField9 | STRING |
CustomField10 | STRING |
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
| Name | Data Type |
|---|---|
TaskID | STRING |
InventoryWriteOffNumber | STRING |
Status | STRING |
LocationID | STRING |
Location | STRING |
Account | STRING |
EffectiveDate | DATETIME |
Notes | STRING |
Lines | RECORD |
Transactions | RECORD |
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
| Name | Data Type |
|---|---|
ID | STRING |
Customer | STRING |
CustomerID | STRING |
Contact | STRING |
Phone | STRING |
STRING | |
DefaultAccount | STRING |
SkipQuote | BOOLEAN |
BillingAddress | RECORD |
ShippingAddress | RECORD |
BaseCurrency | STRING |
CustomerCurrency | STRING |
TaxRule | STRING |
TaxCalculation | STRING |
Terms | STRING |
PriceTier | STRING |
ShipBy | DATETIME |
Location | STRING |
SaleOrderDate | DATETIME |
LastModifiedOn | TIMESTAMP |
Note | STRING |
CustomerReference | STRING |
COGSAmount | NUMERIC |
Status | STRING |
CombinedPickingStatus | STRING |
CombinedPackingStatus | STRING |
CombinedShippingStatus | STRING |
FulFilmentStatus | STRING |
CombinedInvoiceStatus | STRING |
CombinedPaymentStatus | STRING |
CombinedTrackingNumbers | STRING |
CurrencyRate | NUMERIC |
SalesRepresentative | STRING |
ServiceOnly | BOOLEAN |
Type | STRING |
SourceChannel | STRING |
Quote | RECORD |
Order | RECORD |
Fulfilments | RECORD |
Invoices | RECORD |
CreditNotes | RECORD |
ManualJournals | RECORD |
Attachments | RECORD |
InventoryMovements | RECORD |
AdditionalAttributes | RECORD |
ShippingNotes | STRING |
Carrier | STRING |
ExternalID | STRING |
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
| Name | Data Type |
|---|---|
ID | STRING |
BlindReceipt | BOOLEAN |
OrderNumber | STRING |
Status | STRING |
OrderDate | DATETIME |
InvoiceDate | DATETIME |
Supplier | STRING |
SupplierID | STRING |
InvoiceNumber | STRING |
InvoiceAmount | NUMERIC |
PaidAmount | NUMERIC |
InvoiceDueDate | DATETIME |
RequiredBy | DATETIME |
BaseCurrency | STRING |
SupplierCurrency | STRING |
OrderStatus | STRING |
StockReceivedStatus | STRING |
UnstockStatus | STRING |
InvoiceStatus | STRING |
CreditNoteStatus | STRING |
LastUpdatedDate | DATETIME |
Type | STRING |
CombinedInvoiceStatus | STRING |
CombinedPaymentStatus | STRING |
CombinedReceivingStatus | STRING |
IsServiceOnly | BOOLEAN |
BillingAddress | RECORD |
ShippingAddress | RECORD |
Order | RECORD |
StockReceived | RECORD |
PutAway | RECORD |
Invoice | RECORD |
CreditNote | RECORD |
ManualJournals | RECORD |
AdditionalAttributes | RECORD |
Attachments | RECORD |
InventoryMovements | RECORD |
Contact | STRING |
Phone | STRING |
InventoryAccount | STRING |
Approach | STRING |
TaxRule | STRING |
TaxCalculation | STRING |
Terms | STRING |
Location | STRING |
Note | STRING |
CurrencyRate | NUMERIC |
LastUpdatedDate_ts | TIMESTAMP |
Last updated