User-Defined Database Validations using Body

Use the following steps if Body was chosen above.

How to

  1. Optionally, specify an XPath to validate only a portion of the response identified by the XPath. For example, if the response of the the database action is XML, then you can run XPath on it to return a value and then validate whether that value (returned by XPath) is as expected.
  2. Specify the Response Type from among: XML, SOAP, JSON, PHP, HTML, or Text.
  3. Specify the Match type from among:
    1. Exact Match – Matches exactly
    2. RegEx – Matches regular expression
    3. Glob – Matches glob expression
    4. Script – The script is expected to succeed
    For example, the user-defined validation below is on the action’s body and is set to Exact Match. The value shown being validated below is: column_int,column_varchar,column_numeric,column_double,column_boolean,column_binary,column_date,column_time,column_timestamp1,Oracle 11g,123456.780,123456.78,true,MHgwMTAyMDMwNDA1MDYwNzA4,2013-06-25,01:02:03,2013-06-25 01:01:01 -07002,"PostgreSQL ""9.3""",234567.890,234567.89,true,MHgwMjAzMDQwNTA2MDcwODA5,2013-06-25,02:02:02,2013-06-25 02:02:02 -07003,SQL Server 2012,345678.900,345678.9,false,MHgwMzA0MDUwNjA3MDgwOTEw,2013-06-25,03:03:03,2013-06-25 03:03:03 -07004,\N,\N,\N,\N,\N,\N,\N,\N Note: If you've extracted a property using the Property Sets tab or want to click any existing Global, System, of Custom Property, click the Property icon to use the Property Chooser. Take note that scope must be set if you're validating something outside of the current scope.

  4. Specify the Failure Action for the validation.