SOLVED

Bulk Lead Extract

Go to solution
Tayyab_Ali
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
SanfordWhiteman
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
SanfordWhiteman
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.

Tayyab_Ali
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

SanfordWhiteman
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

Tayyab_Ali
Level 2

Re: Bulk Lead Extract

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

Got the CSV file.