Hi @mobedi Welcome to the community! Webhooks definitely sounds like a great idea for this. Iβm not super familiar with Azure, but we do have our native Excel integration here. You could also see if Zapier has an option to send data over as well.
@john.desborough do you have any clients that use Azure by chance?
Hi @Liz,
Thank you for the answer.
Yes, I have worked with Zapier, but this specific client has already purchased MS Power Automate and uses it for their integrations.
Iβm wondering which solution works best. If we only rely on the Webhook and Webhook does not work temporarily then we should find a workaround to compensate for the lost data, and itβs not always easy because the Webhook can fail silently.
So, either we need to have (1) A sync with the Azure Sql database, or (2) Use an intermediate source like Excel to always have the data in and then sync the Excel daily to the database.
Any suggestions are appreciated!
@Liz @mobedi - sorry no clients that use Azure
BUT i always recommend that folks connect their typeforms to either Google Sheets or Excel (Sheets is my personal pref) as well as using things like webhooks - this allows for reconciliation processes to occur where the client can review the number of records in the spreadsheet against the target integration and have the ability to manually include anything that is missing.
I constantly have to remind my clients that they are working in an ecosystem of βappsβ in many cases and not in an βintegrated suiteβ and that in any environment that is browser/server based there is a risk of data loss due to one component in the process chain dropping a record.
just my thoughts
des
