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. 1.
    Sign in to Daton
  2. 2.
    Select Byrd from the list of Integrations
  3. 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. 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. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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