CData Python Connector for HubSpot

Build 25.0.9454

Forms

Retrieves forms used in HubSpot for lead capture and contact data collection.

SELECT

When selecting Forms, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators is: =.

SELECT * FROM Forms WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'

INSERT


INSERT INTO Forms (Name, FormType, CreatedAt, language)
VALUES ('Test Form Name', 'hubspot', current_timestamp(), 'en')

UPDATE


UPDATE Forms SET Archivable = true, Editable = true, Cloneable = true, SubmitButtonText = 'Updated!'
WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'

DELETE


DELETE FROM Forms WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] String True True

Unique identifier of the marketing form.

Name String False False

The title of the form as it appears in HubSpot.

FormType String False True

The category of the form, such as blog_comment, captured, hubspot, or flow.

FieldGroups String False False

An aggregate of field groups included in the form.

Language String False False

The language the form is set to use.

Cloneable Bool False False

Indicates whether the form can be cloned to create a duplicate.

Editable Bool False False

Specifies whether the form can be edited.

Archivable Bool False False

Determines whether the form can be archived.

RecaptchaEnabled Bool False False

Indicates whether reCAPTCHA is enabled for the form to prevent spam submissions.

NotifyContactOwner Bool False False

If true, notifies the contact owner when the form is submitted.

NewContactNewEmail Bool False False

If true, creates a new contact record for a new email address submitted via the form.

PrePopulate Bool False False

Indicates whether known values should be pre-populated in the form fields.

AllowLinkToReset Bool False False

Allows users to reset known field values via a link.

RenderRawHtml Bool False False

If true, renders the form using raw HTML.

Theme String False False

The theme applied to the form for styling.

SubmitButtonText String False False

Text displayed on the form's submit button.

CssClass String False False

The CSS class used for styling the form.

Style String False False

The display style of the form, such as pop-up or embedded.

CreatedAt Datetime False False

The timestamp when the form was created.

UpdatedAt Datetime False False

The timestamp when the form was last updated.

Archived Bool True False

Indicates whether the form has been archived.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454