Forum Stats

  • 3,677,937 Users
  • 7,897 Discussions
  • 13,001 Comments

Discussions

How to retrieve forms submission via API, for more than 1000 records?

Hi,

So using the REST API, I can retrieve forms submission data for a specific form.

However, there is a max limit of 1000 records using the REST API that Eloqua provides for a form, and we have more submissions now, so we lose the older ones in our reporting.

Looking into the BULK API, I don't see any options regarding forms. I've tried the count, limit, depth, and page parameters but none are helping so far.

Does anyone know what can be done to retrieve more than 1000 rows of form submission data for a specific form, using API? (whether REST or BULK) I don't want to use the Insights automated reporting nor have to manually extract every day.

Thanks so much.

Answers

  • Hi Jeremy,

    The limitation with 1000 records is for one request / interrogation. To get all the data you need to add at the end of the HTTP request the following parameter "page=2". Once you add this, the request will bring you the next 1000 records. Depending on how many records you have, you need to add the page number.

    For example, If you have 3790 submissions in the for then you will use the parameter 4 times:

    GET /api/REST/1.0/data/form/5/formData?page=1

    GET /api/REST/1.0/data/form/5/formData?page=2

    GET /api/REST/1.0/data/form/5/formData?page=3

    GET /api/REST/1.0/data/form/5/formData?page=4

    Then you need to put together all those submissions and you have the final file.


    Kind Regards,

    Larisa Chirila

    Marketing Automation Coordinator

    https://www.logarithmicsolutions.com/

  • jeremy.n
    jeremy.n Posts: 8 Red Ribbon

    Hi Larisa,

    Thanks for the answer. This absolutely works, but my nitpicky side wanted to have everything in one shot, especially since I have the data displayed in an Excel fetching everything via the API. For other reporting purposes I can easily ask devs to use the pagination but for my Excel, this is harder to automate without maintenance.

    Nevertheless, your method certainly works.

    Thanks for chiming in!