Bulk Export leads | Community
Skip to main content
O
OmkarKa4
Level 2
May 22, 2025
Solved

Bulk Export leads

  • May 22, 2025
  • 1 reply
  • 998 views

Hello Community,

 

I'm looking to export leads from the Marketo database. According to the documentation, there's an API that allows exporting leads created within a specific month. However, I'm wondering if there's an alternative way to retrieve all leads. My objective is to generate a file that includes the following fields: FirstName, LastName, MarketoId, and Email Address.

POST /bulk/v1/leads/export/create.json

 

Thank you.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by OmkarKa4

Hello @sanfordwhiteman ,

 

Thank you for the response!

 

Can you give a example for the same.

 

I am currently using this Request Body:

{ "fields": [ "firstName", "lastName", "id", "email" ], "format": "CSV", "columnHeaderNames": { "firstName": "First Name", "lastName": "Last Name", "id": "Marketo Id", "email": "Email Address" }, "filter": { "createdAt": { "startAt": "2024-06-01T00:00:00Z", "endAt": "2024-06-30T00:00:00Z" } } }

 

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
May 22, 2025

You can use the smartListId filter and create a Smart List that qualifies all leads.

O
OmkarKa4AuthorAccepted solution
Level 2
May 22, 2025

Hello @sanfordwhiteman ,

 

Thank you for the response!

 

Can you give a example for the same.

 

I am currently using this Request Body:

{ "fields": [ "firstName", "lastName", "id", "email" ], "format": "CSV", "columnHeaderNames": { "firstName": "First Name", "lastName": "Last Name", "id": "Marketo Id", "email": "Email Address" }, "filter": { "createdAt": { "startAt": "2024-06-01T00:00:00Z", "endAt": "2024-06-30T00:00:00Z" } } }

 

SanfordWhiteman
SanfordWhiteman
Level 10
May 22, 2025
{ "fields": [ "firstName", "lastName", "id", "email" ], "format": "CSV" "filter": { "smartListId" : 467451 } }
Terms & ConditionsAccessibility statement

Loading footer...