Dear
Dear 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 | Account ID
Application Key |
Replication Type | Full Replication
Key Based Incremental |
Replication Key | Datetime |
Suggested Replication Frequency | 1 hour |
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 |
- 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
- 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 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 |
Purpose: This API is used to fetch all customers data
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 |
Purpose: This API is used to fetch all suppliers data
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 |
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 |
Purpose: This API is used to fetch all products
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 |
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 |
Purpose: This API is used to fetch all brands
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
ID | STRING |
Name | STRING |
Purpose: This API is used to fetch all tax related data
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 |
Purpose: This API is used to fetch all carrier related information
Replication: Full Replication
Replication Key: NA
Fields
Name | Data Type |
---|---|
CarrierID | STRING |
Description | STRING |
TrackingURL | STRING |
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 |
Purpose: This API is used to fetch all locations
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 |
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 |
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 |
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 |
Purpose: This API is used to fetch all sales list
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 |