Cmdlets for HubSpot

Build 24.0.9032

変更履歴

General Changes

DateBuild
Number
Change
Type
Description
08/23/20249001HubSpotAdded
  • HubSpot V3 およびV4 スキーマのLeads およびLeadAssociations テーブルに、INSERT、UPDATE、DELETE 操作のサポートが追加されました。
  • HubSpot V3 およびV4 スキーマのLeads テーブルに、バッチINSERT、バッチUPDATE、バッチDELETE 操作のサポートが追加されました。
  • HubSpot V3 スキーマのLeadProperties、LeadPropertyGroups、LeadPipelineStages テーブルにINSERT、UPDATE、DELETE 操作のサポートが追加されました。
08/12/20248990HubSpotAdded
  • HubSpot V4 スキーマに次のビューが追加されました:Orders(バッチ操作をサポート)、OrderPropertiesHistory、およびOrderAssociations。
  • HubSpot V3 スキーマに次のビューが追加されました:Orders、OrderProperties、OrderPropertiesHistory、OrderPropertyGroups、OrderPipelines、OrderPipelineStages、およびOrderAssociations。
  • OrderPropertiesFile 接続プロパティが追加されました。
06/29/20248946HubSpotAdded
  • HubSpot V4 スキーマに次のビューが追加されました:Leads、LeadPropertiesWithHistory、およびLeadAssociations。
  • HubSpot V3 スキーマに次のビューが追加されました:Leads、LeadProperties、LeadPropertiesWithHistory、LeadPropertyGroups、LeadPipelines、LeadPipelineStages、LeadAssociations。
  • LeadPropertiesFile 接続プロパティが追加されました。
06/12/20248929HubSpotAdded
  • HubSpot V4 スキーマのContactPropertiesHistory ビューにContactId カラムが追加されました。
  • HubSpot V3 およびV4 スキーマのDealPropertiesHistory ビューにDealId カラムが追加されました。
  • HubSpot V3 およびV4 スキーマのTicketPropertiesHistory ビューにTicketId カラムが追加されました。
  • HubSpot V3 およびV4 スキーマのCompanyPropertiesHistory ビューにCompanyId カラムが追加されました。
  • HubSpot V3 およびV4 スキーマのContactPropertiesHistory ビューにContactPhone およびContactEmail カラムが追加されました。
06/10/20248927HubSpotRemoved
  • Hubspot スキーマのWorkflows テーブルから次の廃止されたフィールドが削除されました:OnlyExecOnBizDays、NurtureTimeRangeEnabled、NurtureTimeRangeStartHour、NurtureTimeRangeStopHour、ContactListIdsFailed、およびTriggerSetsAggregate。

Added
  • HubSpot V3 スキーマにWorkflows テーブルが追加されました。
06/07/20248924HubSpotAdded
  • HubSpot V3 スキーマのContactPropertiesHistory ビューにContactId カラムが追加されました。
05/29/20248915HubSpotRemoved
  • Auto AuthScheme オプションが削除されました。AuthScheme 接続プロパティのデフォルト値はOAuth になりました。
05/28/20248914HubSpotChanged
  • Communications テーブルで、3つのカラム名が変更されました。ChannelType はChannel Type、LoggedFrom はLogged From、Body はCommunication body になりました。
  • PostalEmails テーブルで、2つのカラム名が変更されました。AttachmentIds はAttached file IDs、MailBody はPostal Mail Body になりました。
05/24/20248910HubSpotRemoved
  • HubSpot スキーマからOwners ビューが削除されました。このビューは、2024年8月30日に廃止されるV2 Owners API を利用したものです。
05/22/20248908HubSpotRemoved
  • HubSpot スキーマからEcommerceSettings テーブルおよびEcommerceSyncErrors ビューが削除されました。これらは現在廃止されたEcommerce Bridge API に関連するためです。
  • HubSpot スキーマからEcommerce Bridge API に関連する次のストアドプロシージャが削除されました:GetEcommerceTriggerURI、SetEcommerceTriggerURI、SendSyncMessages、CheckObjectSyncStatus、およびImportEcommercePages。
05/09/20248895GeneralChanged
  • 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
05/06/20248892HubSpotChanged
  • 次のテーブルでId カラムのRead Only 値がFalse からTrue 変更されました:Contacts、Leads Companies、Tickets Deals、Quotes、Products、LineItems、FeedbackSubmissions、Tasks、Emails、Meetings、Calls、Notes、Goals、PostalMails、Communications、およびユーザーのHubSpot アカウントのカスタムオブジェクトに対応するすべてのテーブル。
04/23/20248879HubSpotAdded
  • v3 スキーマの{fromObject}to{toObject}Associations テーブルにType カラムが追加されました。
  • v4 スキーマの{object}Associations テーブルにTypeLabel カラムが追加されました。
03/29/20248854HubSpotAdded
  • HubSpot スキーマにEnrollments ビューが追加されました。
  • HubSpot V3 スキーマにPerformanceWorkflows ビューが追加されました。
03/15/20248840GeneralAdded
  • Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
02/27/20248823HubSpotAdded
  • Added CUD support for PostalEmails and Communications tables.
  • Added PostalEmailProperties and CommunicationProperties tables, which are used to retrieve all HubSpot and user defined properties for the two objects.
02/26/20248822HubSpotAdded
  • Added the HasUniqueValue column in the following tables: CompanyProperties, ContactProperties, DealProperties and TicketProperties.
  • Added server-side support for AssociatedContactId and Status columns in Threads table.
  • Added a new associations, ProductsToDealsAssociations.
02/02/20248798HubSpotAdded
  • Adding CompanyPropertiesHistory, ContactPropertiesHistory, DealPropertiesHistory, and TicketPropertiesHistory as four new tables to the HubSpotV3 schema.
01/22/20248787HubSpotAdded
  • Adding two new tables PostalEmails and Communications.

Removed
  • Removed Archived column from the following tables: EngagementsTasks, EngagementsEmails, EngagementsMeetings, EngagementsCalls and EngagementsNotes
11/29/20238733GeneralChanged
  • The ROUND function doesn't accept the negative precision values anymore.

Changed
  • The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
  • The return type of the ABS function will be consistent with the parameter value type.
11/28/20238732GeneralAdded
  • Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
11/13/20238717HubSpotAdded
  • Added QuotePropertiesFile, ProductPropertiesFile, LineItemPropertiesFile, FeedbackSubmissionPropertiesFile, TaskPropertiesFile, EmailPropertiesFile, MeetingPropertiesFile, CallPropertiesFile, NotePropertiesFile, GoalPropertiesFile connection properties, used to specify the properties to dynamically retrieve from API, either through a file or a comma-separated list of string values.
  • Added QuoteProperties, ProductProperties, LineItemProperties, FeedbackSubmissionProperties, TaskProperties, EmailProperties, MeetingProperties, CallProperties, NoteProperties tables in schema HubSpotV3 and ProductProperties, LineItemProperties tables in schema HubSpot, used to retrieve the properties of the object from the APi.
10/16/20238689HubSpotAdded
  • Added SelectedExternalOptionsAggregate as a column in the Forms table for the HubSpot schema. This field includes information on the default lifecycle stage which categorizes your contacts and companies while providing context about where they are in your sales and marketing processes.
10/05/20238678HubSpotAdded
  • Added Goals and GoalProperties views for HubSpotV3 and HubSpotV4 schema, which are used to access Goals API endpoints.
08/17/20238629HubSpotRemoved
  • Removed columns: DeletedAt, IsArchived for tables: BlogPosts, Pages

Added
  • Added columns: ArchivedAt, ArchivedInDashboard for tables: BlogPosts, Pages
07/11/20238592HubSpotRemoved
  • Removed the Task table as a result of the Calender API deprecation.
06/29/20238580PowerShell CmdletsRemoved
  • Removed support for .NET 2.0
06/20/20238571GeneralAdded
  • Added the new sys_lastresultinfo system table.
06/08/20238559HubSpotAdded
  • Added new HubSpotV4 schema, used to access v4 endpoints.
  • Added CompanyPropertiesHistory, ContactPropertiesHistory, DealPropertiesHistory, TicketPropertieshistory as part of HubSpotV4 schema.
  • Added Category column for the Associations tables.
  • Added support for SELECT, INSERT, DELETE support for v4 endpoints of Associations tables.

Changed
  • Changed the endpoint for getting Associations data from v4 to v3 for Associations tables.

Removed
  • Removed CompanyPropertiesHistory, ContactPropertiesHistory, DealPropertiesHistory, TicketPropertieshistory from HubSpotV3 schema. These tables can be accessed through HubSpotV4 schema.
04/25/20238515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
03/01/20238460HubSpotAdded
  • Added Threads as a table to the HubSpotV3 schema. Threads is used to retrieve a group of related messages in the inbox. It requires conversations.read and conversations.write as scopes.
  • Added ThreadMessages as a view to the HubSpotV3 schema. ThreadMessages is used to retrieve the message history of a thread. It requires conversations.read as scope and ThreadId to be specified.
01/11/20238411HubSpotAdded
  • Added Files as a view to the HubSpotV3 schema. Files is used to search through files in the file manager. The view does not display hidden or archived files, and requires files or files.ui_hidden.read as a scope.
  • Added Folders as a view to the HubSpotV3 schema. Folder is used to search for folders. The view does not contain hidden or archived folders, and requires files or files.ui_hidden.read as a scope.
  • Added DownloadFile as a stored procedure to the HubSpotV3 schema. DownloadFile can be used to download a public or private file from HubSpot.
12/14/20228383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
12/11/20228380HubSpotAdded
  • Added SELECT support for the Associations V4 API and retrieving multiple associations (HubSpot and User-defined, one to many and many to one) between all object types in the HubSpotV3 schema.
  • Added two new columns to all Associations tables TypeId and TypeName.
  • Added two new columns to the AssociationsTypes view, Label and Category.
09/30/20228308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
09/26/20228304HubSpotAdded
  • Added the AssociationsTypes table in the HubSpotV3 schema, which can be used to retrieve all available association types between a pair of CRM objects to be used in INSERT statements and similar.
  • Added Id and Object Type filters for all Associations type tables in the HubSpotV3 schema (supports ExpandAssociations=true and ExpandAssociations=false).
09/15/20228293HubSpotChanged
  • In the EmailCampaigns table, the data type for 'Id' was changed from 'long' to 'string'.
  • In the EmailCampaignEvents view, the data type for 'CampaignId' was chagned from 'long' to 'string'.
  • In the ContactFormSubmissions view, the data type for 'PageId' was changed from 'string' to 'long'.
  • In the DealStages view, the data type for DealId was changed from 'string' to 'long'.
08/31/20228278HubSpotAdded
  • Added binary and encoded content output support for CreateSchema (HubSpot and HubSpotV3 schema). Added FileStream as an input and FileData as an output.

Changed
  • For the HubSpot schema, the UploadFile stored procedure will use /filemanager/api/v3/files/upload as its destination endpoint. Hidden files can no longer be created, and a new 'Access' input must be set.
  • For the HubSpotV3 schema, the UploadFile stored procedure will use /files/v3/files as its destination endpoint.
08/19/20228266HubSpotAdded
  • Added binary input support for UploadFile (HubSpot and HubSpotV3 schema). Added Content as an input.
07/28/20228244HubSpotRemoved
  • Support for the API key has been removed since Hubspot will sunset the API key on 11/30/2022.
04/26/20228151HubSpotChanged
  • Changed the default schema to HubSpotV3.
02/10/20228076HubSpotChanged
  • Changed the data type from integer to long for a number of mostly primary key columns due to the sizes of returned values potentially overflowing the maximum size for integer.
  • Impacted columns include: ContactLists.ListSize, CrmAssociations.DefinitionId, Engagements.PortalId, Engagements.OwnerId, Engagements.DurationMilliseconds, Engagements.CreatedBy, Engagements.ModifiedBy, LineItems.Id, MarketingEmails.MaxRssEntries, Products.Id, SocialMediaMessages.Clicks, SocialMediaMessages.CreatedBy, SocialMediaMessages.UpdatedBy, Workflows.ContactListIdsCompleted, Workflows.ContactListIdsEnrolled, Workflows.ContactListIdsFailed, Workflows.ContactListIdsSucceeded, Contacts.VID, ContactsInList.VID, AnalyticsBreakdowns.Contacts, AnalyticsBreakdowns.Customers, AnalyticsBreakdowns.Leads, AnalyticsBreakdowns.MarketingQualifiedLeads, AnalyticsBreakdowns.Opportunities, AnalyticsBreakdowns.RawViews, AnalyticsBreakdowns.SalesQualifiedLeads, AnalyticsBreakdowns.Subscribers, AnalyticsBreakdowns.Visitors, AnalyticsBreakdowns.Visits, AnalyticsContents.Contacts, AnalyticsContents.CtaViews, AnalyticsContents.Entrances, AnalyticsContents.Exits, AnalyticsContents.Leads, AnalyticsContents.PageBounces, AnalyticsContents.PageTime, AnalyticsContents.RawViews, AnalyticsContents.Submissions, AnalyticsEventCompletions.Completions, AnalyticsForms.Completions, AnalyticsForms.FormViews, AnalyticsForms.Installs, AnalyticsForms.Interactions, AnalyticsForms.Submissions, AnalyticsForms.Visibles, AnalyticsSessions.Desktop, AnalyticsSessions.DirectTraffic, AnalyticsSessions.EmailMarketing, AnalyticsSessions.Mobile, AnalyticsSessions.OrganicSearch, AnalyticsSessions.OtherCampaigns, AnalyticsSessions.Others, AnalyticsSessions.PaidSearch, AnalyticsSessions.Referrals, AnalyticsSessions.SocialMedia, AnalyticsSocialAssists.RawViews, AnalyticsViews.Id, AnalyticsViews.CreatorId, AnalyticsViews.UpdaterId, BlogAuthors.UserId, Blogs.PostsPerListingPage, Blogs.PostsPerRSSFeed, ContactFormSubmissions.ContactVID, ContactFormSubmissions.PortalId, ContactIdentityProfiles.ContactVID, ContactPropertiesHistory.VID, EcommerceSyncErrors.PortalId, EngagementScheduledTasks.PortalId, Files.Size, Owners.OwnerId, Tasks.PortalId
01/24/20228059HubSpotAdded
  • Added support for 6 new tables with full CRUD Support:
    • EngagementsCalls
    • EngagementsTasks
    • EngagementsNotes
    • EngagementsMeetings
    • EngagementsCalls
    • Forms
12/13/20218017HubSpotChanged
  • Updated the default scopes to conform to HubSpot API's changes. Note that you can control what scopes to use by using the connection properties OAuthRequiredScopes and OAuthOptionalScopes. More information can be found here: https://developers.hubspot.com/docs/api/oauth/contacts-scope-migration
12/01/20218005HubSpotAdded
  • Added extra columns for Dimension, Hierarchy and OLAPType to sys_tablecolumns for OLAP properties.
10/13/20217956HubSpotAdded
  • Added the hidden connection property ShowListMemberships, which defaults to true. If set to false, current list memberships will not be fetched for the contact.
09/02/20217915GeneralAdded
  • Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
08/23/20217905HubSpotChanged
  • You can now update the "Additional email addresses" column from the Contacts table.
08/07/20217889GeneralChanged
  • Added the KeySeq column to the sys_foreignkeys table.
08/06/20217888GeneralChanged
  • Added the new sys_primarykeys system table.
08/03/20217885HubSpotAdded
  • Added support for the table FeedbackSubmissions. It is similar to Companies, Contacts, Deals etc.
07/23/20217874GeneralChanged
  • Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
  • As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
05/11/20217801HubSpotChanged
  • We have made some improvements to attempt to automatically handle instances where the url would be exceeded due to selecting too many columns in the HubSpotV3 schema. In HubSpot, we must request individual fields when retrieving data via url parameters. This may result in an exception stating that the url length is exceeded when too many fields are selected in cases where you have a lot of custom fields. To handle this, we will instead automatically split the query up into smaller requests and perform a join on the table in the background to retrieve all the selected columns.
05/06/20217796HubSpotAdded
  • Added support for the DeleteFile store procedure. It may be used to delete a file and its related objects.
04/25/20217785GeneralAdded
  • Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
04/23/20217783GeneralChanged
  • Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
04/16/20217776GeneralAdded
  • Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
04/16/20217776GeneralChanged
  • Reduced the length to 255 for varchar primary key and foreign key columns.

Changed
  • Updated index naming convention to avoid duplicates.
04/16/20217776GeneralChanged
  • Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
04/16/20217776PowerShell CmdletsAdded
  • Added support for PowerShell 7.
12/11/20207650HubSpotAdded
  • Added support to expose the custom object associations tables for custom objects with available associations to other object types. The custom object associations tables are exposed in the format {CustomObjectPluralLabel}Associations.
  • The standard object association tables will now return the ids for the associated custom object type records. For example, a query to the ContactAssociations table will also include the Ids of the associated custom object records if any apart from the standard ones.
  • Added the ExpandAssociations connection property (default=false). If true, the driver will expose one associations table for each association between two HubSpot object types (ex. CompaniesToContactsAssociations, ContactsToDealsAssociations, DealsToLineitemsAssociations, etc.). Each of these tables will return the Id pairs of the associated records from the two object types.
  • Added support for Insert and Delete operations to the CustomObjectAssociations which can be used to add and remove associations between a custom object type and other object types (custom or standard objects).
  • Removed the ProductAssociations table as the Products object doesn't currently support any associations apart from LineItems. LineItems includes the Product Id as a foreign key to the Products table.
10/26/20207604HubSpotAdded
  • Added UploadFile stored procedure which uses the HubSpot V3 API and allows you to upload files to the Hubspot file manager.
10/22/20207600HubSpotAdded
  • Support for Creating, Updating and Deleting Custom Hubspot Objects (tables) and Properties (columns) via the stored procedures: CreateCustomObject, CreateCustomProperty, UpdateCustomObject, UpdateCustomProperty, DeleteCustomObject, DeleteCustomProperty.
  • Support to expose as tables the dynamically retrieved Custom Objects.
  • Added views: CustomObjects, CustomObjectProperties, CustomObjectAssociations, which provide detailed information on the available Custom Objects.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9032