Cmdlets for HubSpot

Build 24.0.9032

WebAnalytics

The Web Analytics endpoint allows developers to find and filter events associated with a CRM object of any type.

View Specific Information

SELECT

EventType, or ObjectType and either ObjectId or ObjectProperty must be specified.
When selecting WebAnalytics, they can only be filtered by the EventType, ObjectType, ObjectId, ObjectProperty, OccurredAfter, OccurredBefore and Sort. For example:

SELECT * FROM WebAnalytics WHERE ObjectId = '74924128' AND ObjectType = 'contact'
SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND OccurredAfter = '07/02/2020 09:45:50.829'
SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND OccurredBefore = '07/02/2020 09:45:50.829'
SELECT * FROM WebAnalytics WHERE ObjectId = '101' AND ObjectType = 'contact' AND  Sort = 'occurredAt'

Columns

Name Type References Filterable Description
Id [KEY] String False Id of the event.
ObjectId String False Id of the object.
ObjectType String False Type of the selected object.
EventType String False Type of the event.
OccurredAt Datetime False Time when the event occurred.
Properties String False Additional properties.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 詳細については、WHERE 句のセクションを参照してください。

Name Type Description
ObjectProperty String If the id of the selected object not present_ then the objectProperty parameter is required. A particular property to match on is identified by an objectProperty._propname___propvalue_ query parameter. To find contacts by their email property you have to specify the value of the ObjectProperty in this format _ 'propertyName_propertyValue'
OccurredAfter Datetime The starting time as an ISO 8601 timestamp.
OccurredBefore Datetime The ending time as an ISO 8601 timestamp.
Sort String Selects the sort field and order. Defaults to ascending_ prefix with _ for descending order. 'occurredAt' is the only field supported for sorting.

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