Sql Get

Executes a SQL statement which can be any of - SELECT - SHOW - DESCRIBE 2
3 variables	3 variables

Executes a SQL statement which can be any of

• SELECT
• SHOW
• DESCRIBE

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 SQL statement which can be any of SELECT SHOW DESCRIBE
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 SQL statement which can be any of SELECT SHOW DESCRIBE

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