Sql

Executes a Fusion Tables SQL statement, which can be any of - SELECT - INSERT - UPDATE - DELETE - SHOW - DESCRIBE - CREATE statement 2
3 variables	3 variables

Executes a Fusion Tables SQL statement, which can be any of

• SELECT
• INSERT
• UPDATE
• DELETE
• SHOW
• DESCRIBE
• CREATE statement

Authorization

To use this building block you will have to grant access to at least one of the following scopes:

• Manage your Fusion Tables
• View your Fusion Tables

Input

This building block consumes 3 input parameters

Name	Format	Description
sql Required	STRING	A Fusion Tables SQL statement, which can be any of SELECT INSERT UPDATE DELETE SHOW DESCRIBE CREATE
hdrs	BOOLEAN	Whether column names are included in the first row. Default is true
typed	BOOLEAN	Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true

  = Parameter name
  = Format

sql STRING Required A Fusion Tables SQL statement, which can be any of SELECT INSERT UPDATE DELETE SHOW DESCRIBE CREATE

hdrs BOOLEAN Whether column names are included in the first row. Default is true

typed BOOLEAN Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true

Output

This building block provides 3 output parameters

Name	Format	Description
columns[]	STRING
kind	STRING	The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse
rows[]	OBJECT_ARRAY

  = Parameter name
  = Format

columns[] STRING

kind STRING The kind of item this is. For responses to SQL queries, this is always fusiontables#sqlresponse

rows[] OBJECT_ARRAY