Power BI Connector for Marketo

Build 23.0.8839

ListStaticMemberShip

Create, delete and query query static list members for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of Static MemberShip from the target instance, filterable by Id and ListId.

SELECT * FROM ListStaticMemberShip WHERE ListId = 1014

SELECT * FROM ListStaticMemberShip WHERE ListId = 1014 AND id = 1016

Insert

To create a new Static MemberShip, specify at least the ListId and Id column.

INSERT INTO ListStaticMemberShip (ListId, Id) VALUES (1014, 1014)

Delete

To delete a ListStaticMemberShip you must specify the ID and ListId field.

DELETE FROM ListStaticMemberShip WHERE Listid = 1014 AND Id = 1014

Columns

Name Type ReadOnly Filterable Description
Id [KEY] Integer True True

Id of static MemberShip.

FirstName String True

FirtName of the member

LastName String True

LastName of the member

Email String True

Email

CreatedAt Datetime True

The date and time the membership was created.

UpdatedAt Datetime True

The date and time the membership was last updated.

ListId Integer True True

ListId.

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