question

AlessandraBarreto-3312 avatar image
0 Votes"
AlessandraBarreto-3312 asked KranthiPakala-MSFT commented

How can I copy a google form result to Sql Azure database?

Do I can use data Factory?

azure-data-factoryazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlessandraBarreto-3312 avatar image
0 Votes"
AlessandraBarreto-3312 answered KranthiPakala-MSFT commented

Hello @KranthiPakala-MSFT . I managed to do using excel files, but I still need to do using http connector.

I appreciate your help.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

1 Vote 1 ·
KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @alessandrabarreto-3312,

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.



· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

Hi @alessandrabarreto-3312,

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.


0 Votes 0 ·

Hi @alessandrabarreto-3312,

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.

0 Votes 0 ·