ADO.NET Provider for HubSpot

Build 21.0.8137

Forms

Retrieve HubSpot forms used to collect lead information about your visitors and contacts.

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

ID of Marketing Form.

Name String False False

The title of the Form.

FormType String False False

Form Type.

The allowed values are blog_comment, captured, hubspot, flow.

FieldGroups String False False

Field Groups aggregate.

Language String False False

Language.

Cloneable Boolean False False

Cloneable.

Editable Boolean False False

Editable.

Archivable Boolean False False

Archivable.

RecaptchaEnabled Boolean False False

Recaptcha Enabled.

NotifyContactOwner Boolean False False

Notify Contact Owner.

NewContactNewEmail Boolean False False

Create new contact for new email.

PrePopulate Boolean False False

Prepopulate known values.

AllowLinkToReset Boolean False False

Allow link to reset known values.

RenderRawHtml Boolean False False

Render raw HTML.

Theme String False False

Theme.

SubmitButtonText String False False

Submit Button Text.

CssClass String False False

CSS Class.

Style String False False

Form Type.

CreatedAt Datetime False False

When the meeting was created.

UpdatedAt Datetime False False

When the meeting was last updated.

Archived Boolean True False

Determines whether the meeting is archived.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137