plug_execute_query {plug} | R Documentation |
Execute a custom SQL query on the Plug database
Description
This function executes a user-defined SQL query on the Plug database, with safe query construction
using glue_sql
.
Usage
plug_execute_query(
sql_template,
endpoint = "https://plug.der.pe.gov.br/MadrixApi/executeQuery",
verbosity = 0,
...
)
Arguments
sql_template |
A SQL query template with placeholders for variables. |
endpoint |
The endpoint URL for executing queries. |
verbosity |
The verbosity level of the API request (0 = none, 1 = minimal, 2 = detailed). |
... |
Named arguments to replace placeholders in the SQL template. |
Value
A tibble containing the query results.
Examples
## Not run:
data <- plug_execute_query(sql_template = "SELECT TOP 1 * FROM Contratos_VIEW")
## End(Not run)
[Package plug version 0.1.0 Index]