I am using Zapier to connect a website form created in WPForms to my Azure Cloud SQL database.
The connection appears to work fine as Zapier connects to both my WPForms and my Azure Cloud SQL database on the test. I was able to set the WPForms fields to match the SQL database fields without any issue so I know that the connection is working. I have also put in the SQL Database owner credentials for the access by Zapier and authorized the log in from their IP address in the SQL database.
I have tried to test the actual Zap by submitting a sample form through the website and the Zap indicates that it was successful and that it sent a new row to my database but when I review the database, there is no new row and no record of any new activity.
I was hoping someone may have an idea of why the Zap connects and records that it was successful but that nothing appears to be actually written in the database. Any suggestions would be greatly appreciated.