`sicarv4.custom.validate`

Validate read-only SQL on the device before saving it. Does not store the query. Same policy as sicarv4.custom.query.


Adapter	`sicarv4`
Operation	`db.query`
SQL policy	`read`

Parameters

Name	Kind	Required	Notes
`sql`	`sql`	Yes	Read-only SQL only (SELECT / SHOW TABLES / DESCRIBE / SHOW COLUMNS)

Example

curl -s -X POST "$API/v1/devices/$DEVICE_ID/functions/sicarv4.custom.validate" \
  -H "Authorization: Bearer $ORQUESTR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"input":{"sql":"SELECT art_id, clave, descripcion FROM articulo LIMIT 10"}}'

Getting started

Functions

Adapters

sicarv4.custom.validate

`sicarv4.custom.validate`

Parameters

Example

​sicarv4.custom.validate

​Parameters

​Example

`sicarv4.custom.validate`

Parameters

Example