BULK Lead Extract - Retrieve Data File returns blank

[Anonymous]

Hello, need some direction with Retrieve Data file as I'm not seeing any data in the results file:

here is what I'm trying to bulk extract from Leads:

{

   "fields": [

      "firstName",

      "lastName",

      "email"

   ],

   "format": "CSV",

   "columnHeaderNames": {

      "firstName": "First Name",

      "lastName": "Last Name",

      "email": "Email Address"

   },

   "filter": {

      "createdAt": {

         "startAt": "2017-10-01T00:00:00Z",

         "endAt": "2017-10-31T00:00:00Z"

      }

   }

}

The Status is Completed and there is data for the startAt and endAt dates queried above....

Yet the Retrieve API job returns a blank. using content-type=application/json after trying application/x-www-form-urlencoded - made no difference..got no results. What am I missing here.

Any pointers will be helpful

thanks in advance!

[Kenny_Elkington]

Do you have an example of the call that you're submitting which is returning empty?

[Anonymous]

Got it to work!

The exportId was listed as optional in the documentation so I was passing it as a parameter rather than inserting it in the GET  /bulk/v1/leads/export/{exportId}/file.json

Once I inserted it in the URL where it says {exportId} ...I got the data file!

[SanfordWhiteman]

Yeah, it's always a path segment.  Not sure where you're seeing it as optional?

[Anonymous]

here​ .....

[SanfordWhiteman]

(empty) isn't the same as optional. It means it's not a constant. All the other methods also have (empty) ​for the ​exportId.

[Anonymous]

yep - learnt that the hard way

Since exportId is not a constant - Is it possible to pass the exportId as a variable instead?

Example: once the exportId is generated and while it is still valid, I store it in a variable called vExportId and pass this in the URL like .....bulk/v1/leads/export/"&$(vExportId)&"/enqueue.json

Is this doable?.

[SanfordWhiteman]

Example: once the exportId is generated and while it is still valid, I store it in a variable called vExportId and pass this in the URL like .....bulk/v1/leads/export/"&$(vExportId)&"/enqueue.json

Of course! That's the way I would expect to build URLs based on dynamic responses from Marketo. Of course vExportId only has meaning in your client app, but when you interpolate it into the URL, your app will substitute the stored value.

[Anonymous]

very good to know! I will try that

thanks for your responses. Appreciate it!

[Anonymous]

Sorry for out of context question. But can somebody let me know, how can I create bulk lead export job. Please help me out with this. Thanks in advance.

Thanks,

Vamsi