update_qr_replace_element_byId

This API is available in Guardium V10.1.4 and later.

REST API syntax

This API is available as a REST service with the PUT method. Call this API as follows: 
PUT https://[Guardium hostname or IP address]:8443/restAPI/update_qr_replace_element_byId

GuardAPI syntax

update_qr_replace_element_byId parameter=value

Parameters

Parameter Value type Description
columnAlias String Specify an alias for a column name. For more information, see Starting the IBM Knowledge Catalog and Guardium Data Protection integration.
isFromAllRuleElements Boolean Valid values:
  • 0 (false)
  • 1 (true)
isFromRegex Boolean Whether or not the from element is specified by using a regular expression. Valid values:
  • 0 (false)
  • 1 (true)
Default = 0
isReplaceToFunction Boolean Whether or not the replace to is the name of a function, such as user-defined function. Valid values:
  • 0 (false)
  • 1 (true)
qrReplaceElementId Long Required. The unique ID of the query rewrite action.
replaceFrom String The incoming string for a matching rule that is to be replaced. Use replaceType to indicate specifically which element of the incoming query to examine.
replaceTo String The replacement string for the matching element.

Examples

grdapi update_qr_replace_element_byId qrReplaceElementId=1 isFromAllRuleElements=false isFromRegex=false isReplaceToFunction=false replaceFrom=emp replaceTo=NEW_EMP_UPDATED