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]