Deleting Form Submission Data

Nagaprabhu K

Hello,

I'm trying to use API service to delete form submission data. The challenge is I need to search the data on a date range based "submittedAt" key. I tried the above endpoints, this is bringing all the submission data from the form id.

API/Rest/2.0/data/form/123?q="submittedAt='1579508452'"

API/Rest/2.0/data/form/123?search=submittedAt='1579508452'

referring to this document https://docs.oracle.com/en/cloud/saas/marketing/eloqua-develop/Developers/RESTAPI/Tutorials/search_parameter.htm

I can get all the submissions and process the "submittedAt" field in the backend. The problem here is I have a huge data of submissions in the form. So trying to filter the data via API and delete the same.

Please let me know your thoughts.

Thanks!

Naga

Lou Patrick

Hi Naga,

To filter by a timeframe with this endpoint you need to use the "endAt" and "startAt" query parameters, both should be expressed in Unix time. This endpoint does not use the "search" query parameter. You will see these query parameters detailed within the Retrieve processed form data for a single form endpoint documentation.

Example: GET /API/Rest/2.0/data/form/123?startAt=1579508452&endAt=1579508453

Thanks,

Lou

Nagaprabhu K

Thanks much @Lou Patrick