Subsidiary Lookup Criteria Syntax Each criteria is separated by a comma. The minimum lookup criteria is 1. The maximum lookup criteria is 8. Each lookup criteria must have: “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”: - 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”: - enter a regular expression to clean up unwanted text in both the XML element string and the NetSuite field value being compared. “operator”: - enter the search operator to be used. If blank, “is” operator will be used.
Example: {"xpath": "//cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]","nsfield": "taxidnum","regexp": "[^a-zA-Z0-9]",”operator”: “contains”} |