RunSQL: Gets data from SQL database

In Displayr/flipAPI: Web APIs tools

Gets data from SQL database

Description

Connects to SQL database and returns the result of a query

Usage

RunSQL(
  query,
  data_provider,
  server,
  database,
  user,
  password = "",
  max_records = 100,
  port = 1433,
  warehouse = ""
)

Arguments

query	SQL query to generate data returned
data_provider	Type of database. One of "MySQL", "Postgres", "Redshift", "Oracle", "Snowflake", "SQL Server".
server	Host name or IP where data base is hosted
database	Name of database
user	User name of data base account
password	Password of data base account
max_records	Maximum number of rows returned in 'query'
port	Port number to connect to data base
warehouse	Data base warehouse (only for snowflake database)

Displayr/flipAPI documentation built on April 17, 2024, 9:42 a.m.