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 1000 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: Added PTO Balances Data Target supporting Time Off Balance modifications and Time Off Requests
- Collector: Added associateOID field to the Time Off Balances Collector schema so results can be tied to individual employees
ADP WFN NextGen
- Collector: Added Onboarding Collector
- Collector: Added General Ledger Document Collector supporting the /payroll/v1/general-ledger/documents endpoint
- Collector: Added all supported API parameters to the Worker Collector UI
- Collector: Added associateOID field to the Time Off Balances Collector schema so results can be tied to individual employees
- Data Target: Added Onboarding Data Target
Concur
- Collector: Added toggle to include V4 Attendees data when collecting Expense Reports
Database
- Data Target: Fixed an issue where insert and update operations failed when the primary key column was of type
uniqueidentifier
Microsoft Graph
- Collector: Added OneDrive file collection support
Procore
- Credential: Fixed an issue where testing a credential with an expired access token returned "Invalid token" instead of automatically refreshing the token and retrying
- Collector: Fixed an issue where the Requisitions Collector Status filter did not return records when filtering by "Approved"
- Collector: Fixed an issue where the Company Vendors (Show) Collector did not support passing Vendor ID or View as parameters
- Collector: Added parameterization to the Prime Contracts and Prime Contracts Line Items Collectors (multi-select Projects, Contract ID)
- Collector: Added parameterization to the Project WBS Codes Collector (multi-select Projects)
- Collector: Added parameterization to the Requisitions (Subcontract) Invoices Collector (multi-select Projects, Commitment ID, date fields)
- Collector: Added Requisition (Subcontractor Invoice) Contract Items Collector
- Collector: Added Requisition (Subcontractor Invoice) Contract Detail Items Collector
- Data Target: Fixed an issue where the Requisitions Data Target was not updating fields despite reporting a successful completion
Sage Intacct
- Data Target: Added DEFAULT_CONVERSIONTYPE field to the Item Data Target
- Data Target: Fixed an issue where Batch By fields disappeared after saving on the Checking Account Reconciliation Data Target
- Data Target: Added Post Contract Revenue Schedule Data Target
Sage Intacct REST
- Collector: Fixed an issue where the Vendor Collector errored when "Show Private" was toggled on, as
showPrivate is not valid as a filter parameter
- Collector: Added missing objects (e.g., order-entry/document, order-entry/document-line) to the Query Collector Object dropdown
- Data Target: Fixed an issue where the AP Advance Data Target was incorrectly batching records instead of sending each individually when no Batch By was configured
- Data Target: Fixed an issue where the AP Advance Data Target log did not display a record count; updated all REST Data Targets to include standard log fields
- Data Target: Renamed "Matching Fields" to "Batch By" on REST Data Targets for consistency with Intacct XML targets
Workday
- Credential: Added a Test button to the Workday credential UI
Existing Workflow Updates
- Updated the Intacct to BlackLine YTD P&L by Parent Wizard workflow to add a "Most Recent Month Start Date" parameter and simplify the GL Activity query join logic
UI Updates
- Improved Query Builder performance for large queries by reducing DOM node count; accordion panels for WITH queries and Columns no longer render unnecessary form elements when collapsed
- Removed the "Formatted Date" display from the parameters modal for Date parameters to reduce confusion
- Improved File Collector field usability: added help text and tooltips to Match Limit, Archive Path, File Definition, and Skip Rows fields; added option to include a timestamp in Archive Path; changed Skip Rows to a numeric input
- Fixed an issue where the "Records Collected" count on the Collection Items tab remained 0 after re-running a collection until the page was manually refreshed
- Added copy/paste support for selected rows in the Data Table Editor; selected rows now take precedence over selected cells when using Ctrl+C
- Added tooltip to the NetSuite Bulk Import Data Target "Batch Size" field with guidance on recommended values by record complexity
- Renamed "Matching Fields" to "Batch By" on Sage Intacct REST Data Targets for consistency with the XML API targets