Updated on

Marketo.Leads is a Power Query M function that makes a call to the Marketo REST API endpoint and returns all leads in the list.

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


   url as text,
   leadIds as list,
   optional options as any,
) as table


Makes a call to the Marketo REST API endpoint at url/rest/v1/leads.json. All leads in list leadIds are returned.


Pulls the details for three leads

// Output: A table with details for the supplied leads
Marketo.Leads( "", {50, 2343, 88498} )

Other functions related to Marketo.Leads are:

Contribute » | Contributors: Rick de Groot