Power BI Connector for Mailchimp

Build 26.0.9770

McTemplateRender

Renders a Mailchimp Transactional template created in the Mailchimp user interface with the given merge variables and returns the resulting HTML through the Transactional API.

Stored Procedure-Specific Information

To render a Mailchimp Transactional template created in the Mailchimp user interface, you must specify the McTemplateId. For example:

EXEC McTemplateRender McTemplateId = 12345, McTemplateVersion = 'published'

Input

Name Type Required Description
McTemplateId Integer True The Mailchimp Transactional template Id to render.
McTemplateVersion String False The template version to render - 'published' or 'draft'. Defaults to 'published'.

The allowed values are published, draft.

MergeVars String False Optional merge variables to inject into the template.

Result Set Columns

Name Type Description
Success String Indicates whether the operation was successful.
Html String The rendered HTML with merge variables applied.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770