Discussions
Categories
Deleting Form Submission Data

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
Best Answer
-
Lou Patrick Principal Product Manager, Eloqua APIs & App Developer Framework Portland, ORPosts: 202 Bronze Trophy
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
Answers
-
Thanks much @Lou Patrick