ActiveCampaign
| • | Added support for custom objects |
| • | Added support for custom fields in the Accounts, Contacts, and Deals objects |
| • | Added the new EmailActivities object |
| • | Added the new ListId field in the Contacts object. You can use this field in filters to retrieve contacts from a specific list |
| • | Improved performance for the ContactLists object: data is now loaded to and from this object much faster |
| • | Improved support for the Contacts object: native filtering is used for the >, >=, <, and <= conditions on the CreatedDate and UpdatedDate fields |
Amazon Redshift
| • | Added support for new Amazon S3 Regions |
BigCommerce
| • | Added the CustomerMetafields object |
| • | Added the ProductImageContents object for working with the binary content of product images in BigCommerce |
FreshBooks
| • | Added the following objects: Account, AdjustmentJournalEntry, AdjustmentJournalEntryLine, ChartOfAccountsReport, CreditNote, CreditNoteLine, Estimate, EstimateLine, and JournalEntriesByAccountReport |
| • | Added the following report objects: AccountAgingReport, BalanceSheetReport, CashFlowReport, CashFlowSummaryReport, ChartOfAccountsReport, ExpenseDetailsReport, GeneralLedgerReport, GeneralLedgerSummaryReport, InvoicesReport, InvoiceDetailsReport, JournalEntriesByAccountReport, ManualJournalEntryReport, ManualJournalEntrySummaryReport, PaymentsCollectedReport, ProfitAndLossReport, TaxSummaryReport, and TrialBalanceReport |
Freshdesk
| • | Added support for INSERT, UPDATE, and DELETE DML operations for the TicketFields object |
HubSpot
| • | Added support for HubSpot reports |
| • | Added the Sensitive Data connection string parameter for accessing Sensitive Data fields |
| • | Added the following objects: Appointments, Courses, FormSubmissions, FeedbackSubmissions, Leads, Listings, Services, and Subscriptions |
Jira
| • | Added support for additional Jira objects |
| • | Added support for custom objects for issues |
| • | Added the Issues Custom Fields Merge Behavior option specifying how Jira's custom fields from different projects are combined into one Issues object |
MailChimp
| • | Added the following objects: CartLines, Carts, Customers, OrderLines, Orders, ProductVariants, Products, PromoCodes, PromoRules, and Stores |
Marketo
| • | Improved support for the Leads object: native filtering by the CreatedAt field is now supported in the Bulk Extract mode |
NetSuite
| • | Added support for NetSuite API v2 |
| • | Added support for the NetSuite 2024.2 release of API v1 |
| • | Added support for OAuth authentication through the NetSuite Connection Manager |
Oracle
| • | Added support for the JSON data type in Oracle Database 21c, 23ai, and 26ai |
| • | Added support for the BOOLEAN data type in Oracle Database 23ai and 26ai |
Pipedrive
| • | Added the Projects object for Pipedrive API v1 |
| • | Added the following objects for the Pipedrive API v2: Activities, DealFollowers, OrganizationFollowers, Organizations, PersonFollowers, Persons, ProductFollowers, and UserFollowers |
| • | Added the following fields to the Data object: ActiveFlag, AddTime, AssignedToUserId, BusyFlag, CalendarSyncIncludeContext, ChangeSource, ChangeSourceAgent, CompanyId, ConferenceMeetingClient, ConferenceMeetingId, ConferenceMeetingUrl, DealDropboxBcc, Done, DueDate, DueTime, Duration, FieldKey, GoogleCalendarEtag, GoogleCalendarEventId, GoogleCalendarId, IsBulkUpdateFlag, ItemId, LastNotificationTime, LastNotificationUserId, LeadId, Location, LocationLocality, LocationRoute, LocationStreetNumber, LocationSubpremise, LocationSublocality, LogTime, MarkedAsDoneTime, NewValue, Note, NotificationLanguageId, OldValue, OrganizationId, PersonDropboxBcc, PersonId, ProjectId, PublicDescription, RecMasterActivityId, RecRule, RecRuleExtension, ReferenceId, ReferenceType, Series, SourceTimezone, Subject, Type, UpdateTime, and UserId |
PostgreSQL
| • | Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone |
QuickBooks
| • | Added 50 QuickBooks report objects |
| • | Added the TaxExemptionReasonId field to objects |
Salesforce
| • | Added support for Salesforce Web Services API version 64.0 |
| • | Added support for server-to-server authentication |
Shipstation
| • | Added support for ShipStation API v2 |
Snowflake
| • | Added support for new Amazon S3 Regions |
Stripe
| • | Added the BillingMeters object |
| • | Added the read-only SubscriptionDiscounts and AllSubscriptionDiscounts objects to provide extended discount information for records in the Subscriptions and AllSubscriptions objects |
| • | Added support for Payment Plans in the Invoices object |
| • | Added fields from the new API to the Subscriptions, SubscriptionItems, AllSubscriptions, and AllSubscriptionItems objects |
| • | Added support for the UPDATE operation for the Coupons object |
| • | Added support for INSERT, UPDATE, and DELETE DML operations for the WebhookEndpoints object |
| • | Added support for selecting records by Id for the ApplicationFees and Reviews objects |
| • | Removed support for the deprecated Orders, Returns, SKUs, and UsageRecords objects, which are no longer available. Use the BillingMeters object instead of UsageRecords, and use the Products and Prices objects instead of SKUs and Orders |
| • | Changed the metadata behavior for the Subscriptions, AllSubscriptions, SubscriptionItems, and AllSubscriptionItems objects |
SugarCRM
| • | Added the RowsAndColumns, Summation, and SummationWithDetails reports |
SurveyMonkey
| • | Extended the primary key for the CollectorRecipients object to ensure uniqueness across all records. Now it includes the Id, CollectorId, and MessageId fields |
| • | Extended the primary key for the SurveyResponses object. Now it includes the Id, CollectorId, and SurveyId fields |
| • | Removed the primary key from the SurveyResponsesAnswers object, because the combination of fields isn't unique, and Null values aren't allowed |
ZenDesk
| • | Added the SectionId and AuthorId fields to the Article object |
| • | Added the CategoryId field to the Section object |
ZohoCRM
| • | Added support for Zoho CRM API v8 |
| • | Changed the behavior of the ZohoAPIVersion enum. Now it includes only two elements: Preferred, which is currently API v8, but may change, and Deprecated, which refers to API v2 |
| • | Added the BulkRead option to the connection string. When enabled, it uses the Zoho CRM Bulk Read API to query large volumes of data |
Zoho Books
| • | Added the SalesReceipts object |
| • | Added support for nested objects within the LineItems field of the Bills object |
| • | Improved selection of the BankTransactions records to include all available statuses |
| • | Improved filtering of records by the Status field |
| • | Improved support for the CustomFields and CustomFieldHash fields in the SalesOrders, Bills, CreditNotes, and CustomerPayments objects |
Zoho Inventory
| • | Added the ItemDocuments object |
| • | Added the Use Custom Fields connection string parameter to start working with custom fields |
Zoho People
| • | Added the TimesheetDetails object |
| • | Added the Suppress Extended Requests connection string parameter to save API calls when querying the Timesheets object |
|
What's New in Devart SSIS Data Flow Components 5.0