Marketo.Leads

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

Syntax

Marketo.Leads(
   url as text,
   leadIds as list,
   optional options as any,
) as table

Description

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

Examples

Pulls the details for three leads

// Output: A table with details for the supplied leads
Marketo.Leads( "https://100-AAA-999.mktorest.com/rest", {50, 2343, 88498} )

Other functions related to Marketo.Leads are:

Contribute » | Contributors: Rick de Groot