Updated on

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


   url as text,
   startTime as date,
   activityIds as list,
) as table


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.


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( "", #date( 2015,11,1 ), {1} )

Other functions related to Marketo.Activities are:

Contribute » | Contributors: Rick de Groot