What's new with DataBlend? September 24th 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

• Data Target: Fixed an issue where multiple Time Entry rows spanning different days were being consolidated into a single entry in ADP instead of being submitted as separate rows
• Collector: Added an "Active Supervisors Only" toggle to the Time Entry Collector to skip terminated supervisors during employee resolution, preventing unnecessary API calls and collection errors

ADP WFN NextGen

• Collector: Added Validation Tables Collector to retrieve validation table definitions, replacing the unsupported Labor Charge Fields endpoint on NextGen
• Data Target: Added Validation Table Values Data Target to create, update, and delete entries within NextGen validation tables
• Collector: Added Pay Statement Summary and Pay Statement Details Collectors using the NextGen pay statement endpoints
• Data Target: Updated People Timecard writes to correctly relate department values to laborAllocations entries, ensuring department data is associated at the correct level in the ADP data model
• Data Target: Added Time Entry Data Target for writing time entry records to ADP WFN NextGen

BambooHR

• Collector: Fixed an issue where the Custom Report Collector returned a 404 error; updated the request to use the correct endpoint format expected by the BambooHR API

Concur

• Collector: Added an Expense Tax Collector using the Concur Expense Tax v4 API endpoint
• Collector: Fixed an issue where the Expense Report Collector did not display all available Approval Status options in the collector configuration UI
• Collector: Fixed an issue where the FIS Expense Report Collector created additional unexpected columns for multi-line expense reports
• Collector: Fixed an issue where the Expense Report V4 Details Collector produced duplicate blank rows and omitted itemization allocations
• Data Target: Fixed an issue where the Bulk User Data Target sent null values for optional fields that were not mapped, causing API errors; unmapped optional fields are now omitted from the request

D365: Business Central

• Collector: Added support for a custom endpoint request, confirmed feasible via the Business Central OData API

File

• Data Target: Updated PGP-encrypted SFTP file outputs to match the embedded PGP filename to the shell filename, preventing mismatches that caused decryption failures on some receiving systems
• Collector: Fixed an issue where the SFTP Excel Collector failed with an error when the source Excel file was empty; empty files now complete with zero records and a warning instead of erroring

Paycor

• Collector: Updated existing Paycor Collectors and added new endpoint support, including Employees, Employee Earnings, Employee Deductions, Employee Direct Deposits, Employee Taxes, Employee Time Off Accruals, and Employee Pay Stubs
• Data Target: Added Payroll Data Targets for submitting employee payroll inputs to Paycor, including Employee Earnings, Employee Deductions, and Employee Direct Deposits

Plex

• Collector: Tuned Plex Collector request pacing and retry behavior to reduce the frequency of hitting Plex API rate limits during large collections

Popdock

• Connector: Fixed an issue where navigating away from an edit page and back discarded unsaved changes when switching between editor tabs

Procore

• Collector: Added Standard Cost Codes Collector with parameterization support
• Data Target: Added Standard Cost Codes Data Target supporting Create and Update operations
• Collector: Added Company Segment Items Collector and Data Target supporting Create, Update, and Delete operations
• Collector: Added Timecard Entries Collector using the Procore Timecard Entries endpoint with full parameterization
• Collector: Added Budget Changes Collector and Budget Change Adjustment Line Items Collector with project and date parameterization
• Collector: Added project_id as a returned column on the Budgets Collector, sourced from the API path parameter
• Connector: Fixed an issue where attachment downloads broke the secure-access redirect flow, causing downloads to fail for attachments hosted behind Procore's signed URL access control

Rillet

• Connector: Updated the Rillet connector to support API V4, adding access to new endpoints and updated data models; resolved Data Target request-model gaps identified during V4 CSV template development

Sage Intacct

• Data Target: Added additional fields to the Order Entry Transaction Data Target including support for extended transaction line attributes
• Data Target: Added tax entry support (VAT/GST) and custom fields to the Charge Card Transaction Data Target, resolving BL01001973 errors in tax-enabled companies
• Data Target: Fixed an issue where multi-row Charge Card Transactions were split into one transaction per row when the Matching Field was left blank; transactions are now correctly grouped and submitted as a single multi-line entry

Salesforce REST

• Connector: Updated the Salesforce REST plugin to API version v66

SharePoint

• Collector: Added the ability to specify a target sheet name when collecting Excel files via the Download Files Collector, allowing collection from a named sheet rather than always defaulting to the first sheet

Snowflake

• Credential: Investigated and resolved an issue where Snowflake PAT (Programmatic Access Token) credentials failed to refresh tokens during collection, causing jobs to error after the initial token expired; updated token refresh handling to correctly reuse PAT credentials without requiring an OAuth flow

Stripe

• Collector: Added Payment Methods Collector and Setup Intents Collector using the respective Stripe API endpoints

Existing Workflow Updates

• Renamed the "Purge Query Execution Results" workflow step type to a clearer label to reduce confusion about the step's purpose

UI Updates

• Renamed "History" to "Jobs" throughout the application for clearer terminology when referencing past and current job executions
• Significantly improved Data Table Editor performance for large tables by reducing unnecessary re-renders and optimizing cell update handling
• Added HubSpot and Concur Data Target field metadata to the Data Target Metadata API, enabling query result validation and field suggestions in the UI for these connectors

Platform Updates

• Fixed an issue where deleting a Schema that had a Stream with associated metadata errored instead of completing successfully; the metadata is now cleaned up as part of the delete operation