What's new with DataBlend? November 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

New Connector

Workday REST

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:

Acumatica

  • Updated the Bill data target to group by VendorRef
  • Fixed an issue with the Bill data target grouping

ADP

  • Fixed an issue updating multiple workers email and home phone numbers
  • Added Time Off Requests Collector
  • Fixed an issue where the Pay data input data target was missing optional fields

Concur

  • Fixed an issue with the Concur Batch Collector was stuck in a loop when no data was present

Database

  • Fixed an issue where large datasets (over 600 MB) were downloading blank

HubSpot

  • Added Archive action to the Line Items data target

  • Added Payment Object to the data target

  • Updated the logs to include more information when an object already exists or if you’re attempting to update a deleted object

Oracle Fusion

  • Added a retry to the Oracle Fusion Reports collector

Procore

  • Added Data Target to Reactivate an Inactive Company User

  • Updated the ID fields for the plugin from Integer to Long

  • Fixed an issue with the Direct Cost line data target

Sage Intacct 

  • Added taxscheduleid to the Order Entry Data Target

  • Fixed an issue were the Contract Line data target was not updating the data

  • Added All Accounts option to the Intacct List Account Balances collector

  • Enabled location ID and department ID field for comma separated parameters for the List Account Balances & List Account

  • Balances by Dimension Collectors

  • Fixed an issue where the Intacct List Account Balances by Dimensions Collector was not Pulling Data

     

  • Fixed an issue where the Intacct Target AP bills would error when writing action with attachmentsid/supdocid included

     

  • Fixed an issue where the Intacct Estimate data target was not able to update, requiring projectid

     

  • Fixed an issue where the Project data target was not posting to Multiple Entitles 

  • Added Create Manual AP Payment Data Target

     

  • Fixed an issue were the Account Balances by Dimension collector returned no data

     

  • Fixed the List Account Balances By Dimensions collector to create an empty stream when no records are returned

     

  • Fixed an issue where the SO Document Read By Query was not showing custom fields

     

  • Added the option to pass multiple-value parameter as a comma-separated string to the Attachments Collector

     

  • Added a column to identify the dimension being collected to the 

     

  • List Dimension Restricted Data collector

     

  • Fixed an issue where attempting to update an AP Bill that is draft status with an attachment ID would error

Script

  • Added PGP libraries

     

Stripe

  • Added Collectors and Data Targets for Payment Intent endpoint
  • Reverted to the previous SDK version 

Agent

  • Fixed an issue caused by updating the time zones resulting in an "Unknown" error among agents

PopDock

  • Collector: Added Parameter options

File

  • Added the ability to decrypt encrypted files from the SFTP/File Collector

Square

  • Fixed an issue where the customer and invoice collectors were not paging correctly
  • Added the option for customer custom fields 

Woo Commerce

  • Fixed an issue where using dates to collect orders resulted in an error

Xero

  • Expanded the scopes of the app to include access to the Files endpoint

Existing Workflow Updates

  • Updated Notification Emails to use local time zones and not UTC

UI Updates

  • Fixed an issue where Aliased Schema Columns were showing (Unknown Column) in Column Name when using Join
  • Updated the Automation widget to show the job being triggered
    Updated the Data Table Editor so members can view it
  • Added the option to quickly add an Identifier as a Select Item in the 'classic' UI Query Builder
  • Improved the process for adding email addresses for Notifications and DQRs
  • Improved the Schedule editor for Collectors, Data Targets, and Workflows