Dear
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 | STRING |
| PaidAmount | NUMERIC |
| InvoiceDueDate | NUMERIC |
| RequiredBy | STRING |
| 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 |
