Cmdlets for HubSpot

Build 24.0.9032

Feedbacksubmissions

Retrieve the available Feedbacksubmissions in HubSpot.

Table Specific Information

When contacts submit feedback to your surveys, you can use submission data in HubSpot tools to help understand how customers feel about your business.

SELECT

When selecting contacts, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 AND operators inside of them. For example:

SELECT * FROM FeedbackSubmissions WHERE [Survey Name] = 'Customer Support Survey 1' AND [Date] > '2021-08-01'
SELECT * FROM FeedbackSubmissions WHERE [Email] = '[email protected]' OR [Feedback sentiment] = 'PROMOTER'

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Contacts WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Contacts WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Contacts WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Contacts WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the object.

Archived Bool True False

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

Agent email String True True

Conversation agent's email

Agent responsible for the conversation Decimal True True

Agent responsible for the conversation which led to the feedback

Agent name String True True

Conversation agent's full name

All accessible team IDs String True True

The team IDs_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom

Business units String False True

The business units this record is assigned to.

All owner ids String True True

The value of all owner referencing properties for this object_ both default and custom.

All team ids String True True

The team ids corresponding to all owner referencing properties for this object_ both default and custom.

Chatflow ID Decimal True True

Chatflow ID of the conversation associated to the submission

Chatflow name String True True

The name of the chatflow associated to the submission

Chatflow object id Decimal True True

Chatflow object id of the conversation associated to the submission

Contact first name String True True

First name of the contact associated with the submission

Contact Id Decimal True True

The id of the contact most recently associated with this submission

Contact last name String True True

Last name of the contact associated with the submission

Conversation thread id Decimal True True

Thread id of the conversation associated to the submission

Created by user ID Decimal True True

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Object create date_time Datetime True True

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

Object last modified date_time Datetime True True

Most recent timestamp of any property update for this object. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.

Merged object IDs String True True

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Record ID Decimal True True

The unique ID for this record. This value is automatically set by HubSpot and may not be modified.

Read Only Object Bool True True

Is the object read only

Tag IDs String True True

Tag IDs assigned to this submission.

Tags String True True

Tags assigned to this submission.

Ticket id Decimal True True

ID of the ticket associated with the submission

Ticket owner avatar uri String True True

Avatar URI of the ticket associated to the feedback's owner

Ticket owner Decimal True True

User the ticket is assigned to which is associated to feedback submission

Ticket name String True True

Short summary of ticket associated with the submission

Unique creation key String True True

Unique property used for idempotent creates

Updated by user ID Decimal True True

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

User IDs of all notification followers String True True

The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications

User IDs of all notification unfollowers String True True

The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications

User IDs of all owners String True True

The user IDs of all owners of this object

Owner Assigned Date Datetime True True

The most recent date an owner was assigned to this object. This is set automatically by HubSpot and can be used for segmentation and reporting.

Owner String False True

The owner of the object.

HubSpot Team String True True

The primary team of the owner.

Industry Standard Question Type String True True

Industry standard question type for custom surveys

Sentiment String True True

This column is a custom field. Sentiment of feedback submission based on survey type

Survey ID Decimal True True

The survey id that the feedback submission is linked with

Survey Type String True True

The type of the survey

Source String True True

The channel of the survey when the feedback submission occurred

Date Datetime True True

The timestamp of the feedback submission

Rating Decimal True True

The value of the feedback submission

Feedback sentiment String True True

The sentiment of the feedback submission

Response String False True

The follow_up response of the feedback submission

Ingestion id String True True

The identifier we use when we initially capture a feedback submission

Knowledge article id Decimal True True

The id of the knowledge article this submission was for

Visitor id Decimal True True

The id of the visitor who submitted this feedback

Engagement id Decimal True True

The id of the equivalent engagement object

Submission URL String True True

The URL of the page the submission was made from

Survey Name String True True

The name of the feedback survey the submission is linked with

Form guid String True True

The form guid that the feedback submission is linked with

Email String True True

The email of the contact associated with a feedback submission

Submission Name String True True

The email of the contact associated with a feedback submission

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