Forms

Retrieves forms owned by a specific account, including metadata and configuration details for LinkedIn Lead Gen Forms.

Table Specific Information

To use this view, the Account column must be specified in the criteria.

Select

For the Account column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. For example:

SELECT * FROM Forms WHERE Account = '512859024';
SELECT * FROM Forms WHERE Account IN ('512859024', '513009855');

When no criteria is specified, such as in this example:

SELECT * FROM Forms;

... we internally post-process the query as follows:

SELECT * FROM Forms WHERE Account IN (SELECT Id FROM Accounts);

The rest of the query is processed client-side.

Insert

To create a new form, the following fields are required: Account, Headline, LandingPage, Message, Questions, Name, Country, Language, Status.

The following fields are optional: Description, PrivacyPolicy, LegalDisclaimer, HiddenFields.

    INSERT INTO Forms (
       Account,
       Description,
       Headline,
       LandingPage,
       LegalDisclaimer,
       Name,
       PrivacyPolicy,
       Country,
       Language,
       Status,
       Message,
       Questions ) VALUES (
       'urn:li:sponsoredAccount:512859024',
       'This is a sample form used for collecting leads.',
       'Join our newsletter!',
       'https://example.com/thank-you',
       'You agree to our terms and conditions.',
       'Sample Form Name',
       'https://example.com/privacy-policy',
       'us',
       'EN',
       'ARCHIVED',
       'This is a sample message.',
       '[
               {
                   \"question\": {
                       \"localized\": {
                           \"en_US\": \"First Name\"
                       }
                   },
                   \"name\": \"firstName\",
                   \"questionDetails\": {
                       \"textQuestionDetails\": {
                       }
                   },
                   \"predefinedField\": \"FIRST_NAME\"
               },
               {
                   \"question\": {
                       \"localized\": {
                           \"en_US\": \"Last Name\"
                       }
                   },
                   \"name\": \"lastName\",
                   \"questionDetails\": {
                       \"textQuestionDetails\": {
                       }
                   },
                   \"predefinedField\": \"LAST_NAME\"
               }
           ]' );

Update

To modify an existing form, use an UPDATE statement. Note that the Id column is required in the WHERE clause.

The following columns are mutable after creation: Description, Headline, LandingPage, Message, LegalDisclaimer, Questions, Name, PrivacyPolicy, Country, Language, Status, HiddenFields.

    UPDATE Forms
    SET
       Description = 'New campaign form description.',
       Headline = 'Try our newest product!',
       LandingPage = 'https://example.com/new-landing',
       Message = 'Thank you for your interest! We will contact you soon.',
       LegalDisclaimer = 'By submitting this form you agree to our updated policies.',
       Questions = '[
               {
                   \"question\": {
                       \"localized\": {
                           \"en_US\": \"First Name\"
                       }
                   },
                   \"name\": \"firstName\",
                   \"questionDetails\": {
                       \"textQuestionDetails\": {
                       }
                   },
                   \"predefinedField\": \"FIRST_NAME\"
               },
               {
                   \"question\": {
                       \"localized\": {
                           \"en_US\": \"Last Name\"
                       }
                   },
                   \"name\": \"lastName\",
                   \"questionDetails\": {
                       \"textQuestionDetails\": {
                       }
                   },
                   \"predefinedField\": \"LAST_NAME\"
               }
           ]',
       Name = 'June 2025 LeadGen Form',
       PrivacyPolicy = 'https://example.com/privacy',
       Country = 'us',
       Language = 'EN',
       Status = 'DRAFT'
    WHERE
       Id = '13420673';

Columns