Bulk Lead Extract

Forum|Forum|7 years ago
November 13, 2018
1 reply
3224 views

We are creating a bulk export request for Lead. When looking at status we are always getting status "Created", so can't export file.

In documentation it's mentioned that The export job must be in "Completed" state.

Hours has been passed, but yet status is not changed.

What's the reason for this!!!!

Marketo

Best answer by SanfordWhiteman

I don't see the enqueue step.

Also, for readability:

SanfordWhiteman

New Participant

Please show (highlighting with the Advanced Editor's syntax editor so it's readable) each step you've taken, including queueing the job.

Tayyab_AliAuthor

New Participant

1st created export request using:

{host}/bulk/v1/leads/export/create.json?access_token={accessToken}

using body:

{
   "fields": [
      "firstName",
      "lastName",
      "email"
   ],
   "format": "CSV",
   "columnHeaderNames": {
      "firstName": "First Name",
      "lastName": "Last Name",
      "email": "Email Address"
   },
   "filter": {
      "createdAt": {
         "startAt": "2017-01-01T00:00:00Z",
         "endAt": "2018-01-31T00:00:00Z"
      }
   }
}

Then got the status using:

{host}/bulk/v1/leads/export/{exportId}/status.json?access_token={accessToken}

For testing we created 4 jobs.

Got all created jobs using:

{host}/bulk/v1/leads/export.json?access_token={accessToken}

Result:

SanfordWhitemanAccepted solution

New Participant

I don't see the enqueue step.

Also, for readability:

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded