The default page size for some endpoints (/activities, /campaigns, /companies, /contacts, /leads, /lists) in Marketo is 300 records. To avoid this limitation, the bulk functionality can be used. Marketo connector supports two versions of bulk - Bulk v1 and Bulk v2. Bulk v1 is SAP Open Connectors Bulk Endpoints whereas Bulk v2 is Native Bulk Endpoints.
SAP Open Connectors Bulk Endpoints
If you are using the bulk endpoints provided by SAP Open Connectors, we suggest the maximum number of records that can be requested in a query be 10,000, to help you avoid running into API rate limits. For example:
select * from leads limit 10000Native Bulk Endpoints
If you are using native bulk endpoints, you may want to include the to/from dates in the query. This filters the records by the date range specified. If the to/from dates aren't specified data will be retrieved for Now minus 31 days. Marketo also has a file size limit of 500MB/day.
