Do I can use data Factory?
Do I can use data Factory?
Hello @KranthiPakala-MSFT . I managed to do using excel files, but I still need to do using http connector.
I appreciate your help.
Hi @alessandrabarreto-3312, Glad to know you were able to implement using Excel files.
If you face any issues while implementing HTTP connector please feel free to open a new thread as it is different than the original query of this thread and it will help other community members to find it helpful. Please let us know and we will be happy to assist.
Thank you
Welcome to Microsoft Q&A forum and thanks for reaching out.
Unfortunately Azure data factory doesn't have out of box connector for Google Forms. For available list of connectors please refer to this doc: Azure Data Factory and Azure Synapse Analytics connector overview
But as a workaround if you have a process to save Google form result to an Excel worksheet, then ADF has Excel connector which can be used to read data from the excel which has the Google form result and copy it to Azure SQL Database.
Additional info: I'm not familiar with Google forms, but if there is any API that can return Google form result then you can call that API using REST connector in ADF
Hope this helps. Do let us know if you have further query.
Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Hi @KranthiPakala-MSFT , thanks for your answer.
I have another doubt, If I have this answer in http format, can I use Data Factory?
I have the answer an Excel worksheet, but I need something that have automatic update
Thanks
Thanks for getting back. If you have an HTTP endpoint which provides the answer then you can user Azure Data Factory HTTP connector. For more info about the connector please refer to this doc : Copy data from an HTTP endpoint by using Azure Data Factory or Azure Synapse Analytics
Hope this helps. Do let us know if you have further query.
Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
10 people are following this question.