Dear

Dear ETL connector for data replication

Snapshot

FeaturesDetails

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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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

NameData 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