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

1. Sign in to Daton

2. Select Byrd from the list of Integrations

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 Dear Account ID and Application Secret. These can be created on the API setup page inside DEAR Inventory application: https://inventory.dearsystems.com/ExternalAPI.

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

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

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
Email	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