However, there are certain forms that I have that when queried with 2. endpoint, the returned number of form submissions doesn't tally with the number of submissions that I get by manually counting them on the same date with 1. endpoint.
Is there anyway I can get an accurate number of submissions given a specific date, without having to retrieve all the records from 1. endpoint and count them by myself?
2. Next, I use GET form-integrations/v1/submissions/forms/ce3xxx and I'm able to see that the return response shows 3 form submissions on 27th May 2020.
I'd be happy to jump in here! Taking a look at the submissions, the reason we're seeing this is due to one of the submissions coming from a filtered IP. This is identified by the label seen on the submission here.
This form submission came from an excluded IP address. It has been filtered from your form analytics
Form Submission data is separate to our Analytical data, therefore, we expect to see a discrepancy in the results when fetching from the Forms Submission endpoint to the Analytical endpoint.
To elaborate on the above, for analytical reporting purposes, any submission that comes from a Filtered IP will not be reflected in any reporting within HubSpot. You can read more about this IP Filtering here.