The highly skilled product team at DataBlend releases new connectors and updates monthly. It's our way of keeping the product fresh and up-to-date with the latest connectors and improvements. Below is a brief outline of the newest release. See our release notes: https://lp.datablend.com/knowledge/release-notes-1
Existing Connector Updates
There is a reason why DataBlend is trusted by the top finance and accounting departments at over 1200 companies. Our impressive product team is committed to updating and improving our growing number of connectors, enabling users to have fast, reliable, and secure integrations between their everyday applications in the Office of Finance.
With this brand-new DataBlend release, we've updated the following connectors:
ADP WFN Classic
- Data Target: Fixed an issue where the Onboarding Data Target rejected hires with a non-US legal address because the
applicantOnboarding.countryCode (Worked-In Country) field could not be sent; the field is now supported
- Data Target: Fixed an issue where the Labor Charge Code Data Target errored with "Value cannot be null (Parameter 'source')" when Show Full Log was enabled and ADP returned no messages in its response
Bloomerang
- Collector: Fixed an issue where the Transaction Collector was missing several fields from the collected output; updated the schema to include all available transaction fields
Concur
- Data Target: Fixed multiple data-handling issues with the Bulk User Data Target in Update and Replace modes, including incorrect field serialization and records being skipped or incorrectly processed
Database
- Data Target: Added automatic batching for large-volume writes, allowing the Database Data Target to split large record sets into configurable batch sizes to prevent timeouts and memory pressure on the database server
Dynamics 365 CRM
- Collector: Added an option to return display labels (formatted values) for lookup, choice, and two-option fields alongside their raw values, making collected data more readable without requiring post-processing
Email
- Collector: Added the ability to receive the full raw file/encoding of an inbound email via the SFTP Email Ingestion Collector, enabling processing of the complete email content including headers and attachments
File
- Collector: Fixed an issue where collecting multiple files in a single run reported an incorrect "Records Collected vs. Total" count in the job log
Procore
- Data Target: Fixed an issue where attachment columns on Procore Data Targets sent the column's text value as the file body instead of fetching and uploading the actual file; real file attachments can now be sent correctly
- Data Target: Fixed an issue where the Direct Cost Data Target had mismatched line item columns between DirectCostItem and DirectCostLineItem modes, causing fields to be silently dropped when the mode was switched
- Data Target: Added Prime Contract Line Item Data Target supporting Create and Update operations
QuickBooks Online
- Connector: Added QuickBooks Online Data Target field metadata to the Data Target Metadata API, enabling query result validation and field suggestions in the UI for QuickBooks Online Data Targets
Sage Intacct
- Collector: Fixed an issue where the Order Entry PDF and Invoice PDF Collectors held all PDFs in memory simultaneously and logged no progress during large runs; PDFs are now streamed and released one at a time with per-record progress logging
- Data Target: Added additional fields to the Purchasing Transactions Data Target to improve coverage of the Intacct purchasing API
- Data Target: Added
shipbydate and needbydate fields to the Order Entry Transaction Data Target
- Data Target: Added custom field support to the User Data Target Create operation
- Data Target: Added additional fields to the Items Data Target to improve coverage of the Intacct items API
SharePoint
- Data Target: Fixed an issue where the Upload Files Data Target failed on every file once the destination folder exceeded 2 GiB, caused by an Int32 overflow when reading the folder size; updated to use Int64 to handle large folders correctly
- Connector: Added SharePoint Data Target field metadata to the Data Target Metadata API, enabling query result validation and field suggestions in the UI for SharePoint Data Targets
Stripe
- Connector: Added Stripe Data Target field metadata to the Data Target Metadata API, enabling query result validation and field suggestions in the UI for Stripe Data Targets
WooCommerce
- Collector: Fixed an issue where the Products Collector was returning customer data instead of product data due to an incorrect API endpoint being called
Existing Workflow Updates
- Fixed an issue where the Data Quality Report (DQR) delivery settings configured on a Workflow step were ignored, causing DQR emails to always use the report's default delivery settings instead of the step-level overrides
UI Updates
- Added SharePoint, Stripe, and QuickBooks Online Data Target field metadata to the Data Target Metadata API, surfacing field suggestions in the Query editor's Data Target Fields drawer for these connectors.