Bulk Lead Extract

[Tayyab_Ali]

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!!!!

[SanfordWhiteman]

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

[Tayyab_Ali]

1st created export request using:

https://{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:

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

For testing we created 4 jobs.

Got all created jobs using:

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

Result:

[SanfordWhiteman · Accepted solution]

I don't see the enqueue step.

Also, for readability:

[Tayyab_Ali]

Enqueue step was missing. En-queued the created jobs, now status is changed.

Got the CSV file.