Bulk Lead Extract

Forum|Forum|7 years ago
November 13, 2018
1 reply
3228 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

Level 10

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

Level 2

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

Level 10

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