ODBC Driver for Mailchimp

Build 24.0.9060

AddOrRemoveMemberTags

Add or remove tags from a list member. If a tag that does not exist is passed in and set as 'active', a new tag will be created.

Stored Procedure Specific Information

You can send the Tags either by directly specifying the array or by using the TEMP table.

Using TEMP table


Insert into TagsAggregate#TEMP(Name, Status) Values('TestName11', 'inactive');
Insert into TagsAggregate#TEMP(Name, Status) Values('TestName7', 'active');
exec AddOrRemoveMemberTags TagsAggregate = 'TagsAggregate#TEMP', listid = '123', MemberId = 'test';

Directly providing the array


exec AddOrRemoveMemberTags TagsAggregate = '[{"name": "TestName11","status": "inactive"},{"name": "TestName7","status": "active"}]', listid = '123', MemberId = 'test';

Input

Name Type Required Description
ListId String True The unique ID for the list.
MemberId String True The MD5 hash of the lowercase version of the list member's email address.
TagsAggregate String True A list of tags assigned to the list member.
IsSyncing String False When is_syncing is true, automations based on the tags in the request will not fire.

Result Set Columns

Name Type Description
Success String Whether the operation was successful.

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