SOLVED

Bulk Lead Extract

Go to solution
Highlighted
Level 2

Bulk Lead Extract

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Level 10 - Community Moderator

Re: Bulk Lead Extract

I don't see the enqueue step.

Also, for readability:

https://s3.amazonaws.com/blog-images-teknkl-com/syntax_highlighter.gif

View solution in original post

4 REPLIES 4
Highlighted
Level 10 - Community Moderator

Re: Bulk Lead Extract

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

Highlighted
Level 2

Re: Bulk Lead Extract

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:

pastedImage_8.png

Highlighted
Level 10 - Community Moderator

Re: Bulk Lead Extract

I don't see the enqueue step.

Also, for readability:

https://s3.amazonaws.com/blog-images-teknkl-com/syntax_highlighter.gif

View solution in original post

Highlighted
Level 2

Re: Bulk Lead Extract

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

Got the CSV file.