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

Alessandra Barreto 96 Reputation points
2021-08-11T20:04:42.42+00:00

Do I can use data Factory?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,724 questions
0 comments No comments
{count} votes

Accepted answer
  1. Alessandra Barreto 96 Reputation points
    2021-08-13T12:01:49.697+00:00

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

    I appreciate your help.


1 additional answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-08-12T07:40:02.057+00:00

    Hi @Alessandra Barreto ,

    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.