Data present in Square but not polled by Zapier

Hi ​@KateBee 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

Check your Zap Runs history for activity: https://zapier.com/app/history/

Hi ​@Troy Tessalone , I really appreciate your help. Here are some screenshots, I hope they’re of good enough resolution? In case my explanation of what’s happened isn’t clear, I’ll summarise again:

1. Zap was successfully set-up and running: whenever a new payment was made in Square, a database in Notion had this added to it
2. I edited a field in Notion that must have caused an issue with the Zap without my realising (I added or updated a property such that it was a multi-select field - “Source Detail” in the screenshots below, which I want to be left blank when the payment is added to Notion in any case).
3. Not realising this, I went off to a show March 1-2 and processed Square payments all weekend
4. Upon my return March 3rd, I checked Notion, saw there were no Square payments all from this time period, then saw the Zap runs were all paused. I think “paused” was the term, at any rate in the Zap histories I don’t see any errors or mention of a pause, I just see that the first step - finding the new Square payments - was on March 1st, and second  step - sending a database item to Notion - occurred on March 3rd when I updated the problematic Notion field from multi-select to single select, and replayed all these paused Zaps.
5. After replaying all, I noticed that Notion only got updated with payments from March 1st morning, and all payments from March 1st afternoon and all of March 2nd were missing from Notion. Re-ran the Zap, checking for any errors (there weren’t) and just got the message “we couldn’t find any new payments”. This is clearly wrong as there were a bunch. Moreover these missing Square payments are detectable by Zapier when I go into Edit/Test mode and get it to pull new data - the new records Zapier pulls for testing include some from March 2nd. Even today, if I run the Zap it tells me there’s no new payments.
6. The Zap has been running successfully on new payments after March 2nd, so it’s just payments from this block of time that is missing and I’m failing to see any reason why.

Thanks for any help in figuring this out!

Hi ​@Troy Tessalone Thanks so much for getting in touch. I’ll put screenshots below (hopefully resolution is good enough?), but also wanted to summarise the issue more clearly:

1. I created a Zap that polls for new Square payments and then updates a Notion database with some of the fields.
2. After creating the original Zap which worked well, I must have tweaked one of the fields in the Notion database and set the field property type to ‘multi-select’ instead of ‘single select’.
3. I went off to a market on March 1-2 and processed multiple payments with Square. Upon return March 3, none of these payments appeared in Notion as the Zap had been paused due to an error. I cannot find a trace of the pausing of the run in the Zap histories, nor mention of why it was paused, but I do see that the Square payments were found on March 1 and then pushed to Notion on March 3 after I edited that field property in Notion and replayed the Zap.
4. Then I noticed that only half the payments from March 1 actually show up in Notion after replaying the Zap. No payments from later in the day on March 1 nor any from March 2. There are no error messages to this effect in Zapier, and when I re-run the Zap (done multiple times now), I just see a message to say that the Zap found no new payments. However there are plenty of new payments from that time period that don’t show up in the run history.
5. I notice that if I edit the Zap and pull recent data for testing, it does manage to pull data from March 2. It’s just flying under the radar when the Zap is published and running.
6. I’ve had successful runs of the Zap since March 3, with no pausing or error messages.

Thanks for any insights into this error for which I canot see any explanation!

I think the issue was probably that the error ratio went too high and it automatically stopped running. This would explain the data loss. I’m not on an enterprise plan to be able to override the ratio, and Square isn’t a supported app for data transfers, so I’ll just imprt a CSV file into Notion instead. None of the other checks/solutions throw anything up.

Thanks for the clues to help me figure this one out!

That’s fantastic, ​@KateBee! Big shoutout to Troy for guiding you in the right direction!

If you ever need more help, don’t hesitate to ask the Community—we’re always here for you! 🤗