Bulk Export leads

[ok82]

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.

[SanfordWhiteman]

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

[ok82 · Accepted solution]

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 · Accepted solution]

{
   "fields": [
      "firstName",
      "lastName",
      "id",
      "email"
   ],
   "format": "CSV"
   "filter": {
      "smartListId" : 467451
   }
}