ValidateJSONParameters
Allows the provider to validate that string parameters are valid JSON before sending the query to Couchbase.
Data Type
bool
Default Value
true
Remarks
When AllowJSONParameters and QueryPassthrough are enabled, the query parameters given to the component will be treated as raw JSON documents instead of arbitrary string values. This option controls what happens when invalid JSON is given to the component in this mode.
When this option is enabled, the component will check that all string parameters can be parsed as valid JSON. If any cannot be, an error will be raised and the query will not be run.
When this option is disabled, no check is performed and all string parameter values are substituted into the query directly. This makes executing prepared statements faster, but less safe since invalid N1QL or SQL++ may be sent to the Couchbase.