Marketo.Activities

Marketo.Activities is a Power Query M function that makes a call to the Marketo REST API endpoint and returns all activities in list that have occurred since a certain time.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Marketo.Activities(
   url as text,
   startTime as date,
   activityIds as list,
) as table

Description

Makes a call to the Marketo REST API endpoint at url/rest/v1/activities.json. All activities in list activityIds that have occurred since startTime are returned.

Examples

Pulls a table of “Visit Webpage” activities since November 1, 2015

// Output: A table with details of all "Visit Webpage" activities since November 1
Marketo.Activities( "https://100-AAA-999.mktorest.com/rest", #date( 2015,11,1 ), {1} )

Related functions

Other functions related to Marketo.Activities are:

• Marketo.Leads
• Marketo.Tables

Contribute » | Contributors: Rick de Groot