Page Comparison

Subsidiary Lookup Criteria Syntax

• Each criteria is separated by a comma

• The maximum lookup criteria is 5.

• The minimum lookup criteria is 1.

• Each lookup criteria must have:

  • xpath “xpath”: - This is the complete source element from the XML. If the element has a parent, all parent elements must be included in the path definition.

  • nsfield “nsfield”: - the field ID of the subsidiary field where the string found in the XML element will be compared to.

• Optional parameter of the lookup criteria

  • regexp “regexp”: - enter a regular expression to clean up unwanted text in both the XML element string and the NetSuite field value being compared.

Example:

{"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]","nsfield": "taxidnum","regexp": "[^a-zA-Z0-9]"}