cartodb@0.4.12
Functions
addRow
addRow(table, rowData) ⇒ Operation
Add rows to a table
Param | Type | Description |
---|---|---|
table | String | Table name |
rowData | object | data to add in the row |
Example: Add rows to a table
addRow('users', { name: 'Alice', age: 25, city: 'New York' })
sql
sql(sqlQuery) ⇒ Operation
Execute an SQL statement
Param | Type | Description |
---|---|---|
sqlQuery | object | Payload data for the message |
Example: A basic radius search query
sql("SELECT * FROM table WHERE ST_DWithin(geom,ST_Point(-73,40),1000)");