XML APIs
Summarize
Summary of XML APIs
ServiceNow’s XML APIs enable customers to process and encrypt XML payloads by iterating through XML elements and mapping them to specific table fields within their instance. These APIs are accessed via thegetAsXmlContent()method on a request or ParameterValue property, returning an iterable XMLContent object. This functionality is crucial for customers looking to securely handle XML data while integrating with ServiceNow, especially when encryption is required for sensitive fields.
Show less
Key Features
- Iterate XML Elements: Use
getIterator()orgetIterator(String xPath)on XMLContent to obtain an XMLElementIterator, which supportshasNext()andnext()methods for controlled traversal. - Field Mapping and Encryption: Call
valueFor(String tableName, String fieldName)on each XMLElement to map XML data to table fields, enabling the proxy server to determine if encryption applies based on configured encryption rules. - Dynamic Table and Field Handling: Support scenarios where table and field names are not fixed by dynamically retrieving the table from request parameters and iterating over child elements, allowing flexible encryption logic.
- Encoded Query Encryption: Recognize XML tags with a
filter="true"attribute to apply encryption specifically for encoded queries usingencodedQueryFor(tableName).
Practical Application Examples
- Known Table-Field Mapping: Encrypt specific fields such as the
descriptiontag mapped toincident.shortdescriptionby iterating over matching XML elements. - Unknown Table-Field Mapping: Iterate over all child tags within a record to map and encrypt fields dynamically, ensuring encryption applies only to fields configured in the instance.
- Encoded Query Handling: Detect and encrypt encoded query strings when the
filterattribute is set to true, securing complex query parameters.
Key Outcomes
- Enables secure processing of XML payloads by encrypting sensitive data fields before insertion into ServiceNow tables.
- Offers flexibility in handling both fixed and dynamic XML structures, supporting a wide range of integration scenarios.
- Ensures encrypted data complies with instance-level encryption configurations, enhancing data protection compliance.
- Facilitates encryption of encoded queries, protecting query parameters that may contain sensitive information.
XML APIs can be used after calling getAsXmlContent() on either the request object or a ParameterValue property.
- Call getAsXmlContent() on the request object or ParameterValue property. This returns an iterable object of the XMLContent underlying class.
- Call getIterator() or getIterator(String xPath) on the XMLContent object. This returns an XMLElementIterator object that can be used to iterate over XML elements.
- Call the hasNext() method on the XMLElementIterator object to determine whether another element is available.
- Call next() on the XMLElementIterator object to return the next XML element. You cannot call next() without first calling hasNext().
- Call valueFor(String tableName, String fieldName) on the
XML element. This method tells the proxy that the value for this element
maps to the specified field in the specified table. The proxy then checks if
the field must be encrypted.Note:To determine if you want to call valueFor(String tableName, String fieldName) on an XML element, you can use the getName() method to return the name of the element.
Mapping to a known table-field on the instance
In this example, the XML payload will be processed on the instance to insert records in the incident table. The description field will populate short_description on the incident.
<data>
<record>
<name>'Test Record 1'</name>
<description>'Test Record 1 Description'</description>
<tag>critical</tag>
</record>
<record>
<name>'Test Record 2'</name>
<description>'Test Record 2 Description'</description>
<tag>security</tag>
</record>
</data>The following encryption rule action can apply:
function sampleXmlAction1() {
var xmlContent = request.getAsXmlContent();
// This loop iterates over all description tags that match the given path
var xmlElementIterator = xmlContent.getIterator('data/record/description');
while (xmlElementIterator.hasNext()) {
var xmlElement = xmlElementIterator.next();
xmlElement.valueFor('incident', 'short_decription');
}
}This action iterates through the description tags and asks the proxy server to encrypt the values and insert them into incident.short_description on the instance.
Mapping to an unknown table-field on the instance
In this example, the rule iterates over the record tags, but does not know what tags to expect within the record tag. The only known is that the tags within the record tags match the names of the columns specified in the table URL parameter.
The rule also specifies that, if the table is incident, then the data in the description tag should be encrypted and stored in the short_description field on the instance.
function sampleXmlAction2() {
var xmlContent = request.getAsXmlContent();
var tableName = request.urlParam.table;
// This first iterator will iterate over all record elements
var xmlElementIterator = xmlContent.getIterator('data/record');
while (xmlElementIterator.hasNext()) {
encryptFieldsInRecord(xmlElementIterator.next());
}
}
function encryptFieldsInRecord(xmlElement) {
//Then, iterate over all tags representing fields in the table
var fieldIterator = xmlElement.getIteratorOverAllChildren();
while (fieldIterator.hasNext()) {
var field = fieldIterator.next();
var fieldName = childElement.getName();
//if table is incident, then description is encrypted for the short_description field
if (tableName == 'incident' && fieldName == 'description') {
field.valueFor(tableName, 'short_description');
} else {
//if table is not incident, ask the proxy to check if the given field is encrypted for the given table
field.valueFor(tableName, fieldName);
}
}
}In the encryptFieldsInRecord() function, the valueFor() method is called on a table and a field that are dynamically assigned based on the request. Even though the table and field names can change, the rule asks the proxy to check whether the field in the table must be encrypted based on the encryption configurations defined.
If the field is not configured for encryption, or if the tag does not match a field in the table, the proxy skips that tag. If the tag matches a field marked for encryption, then the Edge Encryption proxy server encrypts the value.
Using an encoded query
In this example, all tags have the filter attribute, which indicates whether the tag contains an encoded query.
<data>
<record>
<name filter="false">'Test Record 1'</name>
<description filter="false">'Test Record 1 Description'</description>
<query filter="true">category=1^name=edge</query>
</record>
<record>
<name filter="false">'Test Record 2'</name>
<description filter="false">'Test Record 2 Description'</description>
<query filter="true">category=2^severity=3</query>
</record>
</data>The following encryption rule action can apply:
function sampleXmlAction3() {
var xmlContent = request.getAsXmlContent();
var tableName = request.urlParam.table;
// This first iterator will iterate over all record elements
var xmlElementIterator = xmlContent.getIterator('data/record');
while (xmlElementIterator.hasNext()) {
encryptFieldsInRecord(xmlElementIterator.next());
}
}
function encryptFieldsInRecord(xmlElement) {
//this time we want to iterate over all tags representing fields in the table
var fieldIterator = xmlElement.getIteratorOverAllChildren();
while (fieldIterator.hasNext()) {
var field = fieldIterator.next();
var fieldname = childElement.getName();
//let's look at the filter attribute, if true, then encrypt as encoded query
if (field.getAttributeValue('filter') == 'true') {
field.encodedQueryFor(tableName);
} else {
//if it is false then check if the field should be encrypted
field.valueFor(tableName, fieldName);
}
}
}If the filter attribute value is true, the rule asks the proxy server to encrypt the values in the encoded query. If false, the rule asks the proxy to check whether the field should be encrypted.