What's new with DataBlend? August 21 Release Notes.

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

• Collector: Added Pay Statement Collectors for the Pay Statement Summary and Pay Statement Details endpoints
• Collector/Data Target: Fixed an issue where "Show Full Logs" displayed warning and error log entries in white/black text instead of the expected yellow/red color coding
• Data Target: Fixed an issue where the Time Entry Data Target loaded supplemental pay entries with an amount of 0 when none were present in the source data

HubSpot

• Connector: Fixed an issue where token refresh during a collection or data target run blanked the stored refresh token, causing subsequent jobs using that credential to fail with an authentication error

Pigment

• Credential: Added a "Test Connection" button to the Pigment credential UI

Pipedrive

• Collector: Fixed an issue where the v1 Search collectors (Search Deals, Search Items, etc.) were broken due to Pipedrive removing their v1 search endpoints; updated the affected collectors to use the current v2 search API

Procore

• Collector: Fixed an issue where the Budget Details Collector failed when "All Projects" was selected because it used a single hardcoded Budget View ID across all projects; the collector now resolves the correct Budget View per project for multi-project and All Projects runs
• Collector: Fixed an issue where the Company Vendors (Show) Collector with "View as Directory" enabled timed out for large vendor lists due to making individual API calls per vendor; updated to use batched requests
• Collector: Fixed an issue where the Company Vendors (Show) Collector with "View as Directory" failed to generate a schema
• Collector: Fixed an issue where the Payment Applications (Owner Invoices) Collector returned no records; corrected the API path used to retrieve payment applications
• Collector: Added prime_contract_id as a returned column on the Payment Applications (Owner Invoices) Collector, sourced from the API path parameters
• Collector: Added requisition_id as a returned column on the Requisition (Subcontractor Invoice) Change Order Items Collector, sourced from the API path parameters
• Collector: Added a toggle to Line Items Collectors (per-project paginated collectors) to filter out inactive projects when collecting across All Projects, preventing unnecessary API calls and reducing collection time

QuickBooks Desktop

• Credential: Fixed an issue where the QuickBooks Desktop credential was not saving the associated Workflow or Collector information

Sage Intacct

• Collector: Fixed an issue where selecting certain related object fields (e.g., fields from a linked object like JOURNAL.SYMBOL) on the Query and Read by Query Collectors caused an "Object reference not set to an instance of an object" error at collection time; fields that produce this error are now hidden from the field picker
• Data Target: Fixed an issue where the Cost Type Data Target only sent the first batch of records and silently stopped, leaving subsequent batches unsent
• Data Target: Updated the Vendor Data Target to support sending empty string values to clear existing field values in Intacct

Sage Intacct REST

• Collector: Fixed an issue where boolean filter values were being serialized as strings (e.g., "true") instead of JSON booleans (true), causing filter errors on boolean fields
• Collector: Updated the Query Collector filter UI to display only operators supported by the Sage Intacct REST API, removing unsupported options that would cause API errors

Salesforce REST

• Collector: Added a ContentVersion Collector to support collecting Salesforce file attachment data (file name, content, linked record IDs) via the REST API

Salesforce SOAP

• Connector: Updated the Salesforce SOAP API connector to the latest supported API version

SharePoint

• Collector: Fixed an issue introduced in plugin v2.7.0 where collecting XLSX files failed with an error because the streamed file download returned a non-seekable stream, which EPPlus requires for processing; the download is now buffered into a seekable stream before parsing
• Credential: Updated the SharePoint app registration to support the Sites.Selected permission scope, allowing customers to grant DataBlend access to specific SharePoint sites instead of requiring the broad Sites.FullControl.All permission

Stripe

• Data Target: Fixed an issue where the Invoices Data Target errored when sending multiple records that included Metadata fields; metadata keys from one record were bleeding into subsequent records due to shared state in the form builder

Platform Updates

• Added Basic Auth support to Script Credentials, allowing scripts to authenticate against endpoints that require a username and password without manually encoding the Authorization header
  

UI Updates

• Fixed an issue where certain related object fields on Sage Intacct Query and Read by Query Collectors caused an "Object reference" error at runtime; those fields are now hidden from the field picker to prevent misconfiguration
• Increased the character limit for Encrypted Value parameters beyond the previous 4,096-character cap to support longer encrypted payloads such as private keys and certificates