Google API integration (Fusion Tables)

  • Profile Image
    docentdev
    Asked on February 10, 2014 at 03:30 PM

    Hi,

     

    We are building functionality to get a user's location and persist it in a Google Fusion Table. On clicking submit, the page should write to the table (via Google API) and refresh, while the map on the page now shows the user's location.

    One way to do this is to have the JotForm write to a google spreadsheet, then periodically sync to the fusion table using a script. This seems to be a rather messy solution. Besides, the script will not have finished writing to the table when the map refreshes in the page.

    A better way to do this is to simply call the fusion table API, which looks like this (we will need to authenticate with an oauth token, which i assume is how the spreadsheet integration works in jotform now)

    https://www.googleapis.com/fusiontables/v1/query?sql= INSERT INTO <table_id> <column_name1> , <column_name2>} VALUES <value1> , <value2>

    Question: Is there a way I can call a google API with form data?

     

  • Profile Image
    Mike_T
    Answered on February 10, 2014 at 04:09 PM

    Thank you for contacting us.

    We do not have any integration with the Google Fusion service, so that you will need a custom script for this task. For example, you can instantly receive form submission data with a Webhook, then process it using your script.

    If you need any further assistance, please let us know.

  • Profile Image
    ashay245
    Answered on November 23, 2015 at 10:50 PM

    is there an easy way for people that don't code to do this. 

  • Profile Image
    Charlie
    Answered on November 24, 2015 at 02:52 AM

    @ashay245

    I see you already have an opened thread with the same question on this thread link: http://www.jotform.com/answers/710656. My colleague is already assigned on it and will answer you directly there, please refer to that link.

    Thank you.