Marketo Bulk leads file download in chunks

[sravankunadi]

I would like to split the Marketo download file size in batches. How do we iterate through the loop untill the file is complete

[sravankunadi]

Can anyone have any inputs untill the full download is complete?

[alchemiz]

@sravankunadi,

Good day,
check this one out …

How to download a csv file that is returned by Marketo REST API call

Hi- SnapLogic community has been of immense help for our organization. As part of our initiative, we are required to make a Marketo REST API call and ingest the data into target system. Marketo documentation: Lead Database - Marketo Developers Marketo REST API ( [/bulk/v1/leads/export/{exportId}/file.json) returns a csv file. We are using the snap “REST Get” to make the Marketo REST API call. However, we are trying to figure out the best way to download the csv file that is returned by the R…

Hope this helps

Thanks,
MM

[sravankunadi]

Thanks MM

But the file is not returning the status once the complete download is complete. I provided the file end point range from 1400 t0 1405… still it takes from 1400 to 1404.

[sravankunadi]

It’s always shows the partial download file complete

[alchemiz]

Were you able to get the filesize of the exportid that you are trying to download?

Here’s the api to get the filesize you are trying to download

Base from the file size you can then use Range as part of the GET request header in a multipart request or single request

Multipart request

or do an array of request

[alchemiz]

use “range” as this is a request header, I think “content-range” is a response header

[Prasa]

Multipart request is not working. Could you please help here. Screenshot attached.

[alchemiz]

Hi @Prasa,

Good day, I’m not sure how your marketo api is setup but here’s a quick reference regarding ranges

HTTP Range Request

Regards,
MM