XML APIs
Summarize
Summary of XML APIs
XML APIs in ServiceNow allow you to process and encrypt XML payload data by iterating over XML elements retrieved viagetAsXmlContent()from a request or parameter. These APIs enable granular control over how XML data maps to table fields and whether those values should be encrypted before insertion into the instance.
Show less
Key Features
- XMLContent Object: Obtained by calling
getAsXmlContent(), it provides methods to get iterators over XML elements. - XMLElementIterator: Used to traverse XML elements using methods like
hasNext()andnext(). - XMLElement Methods:
valueFor(String tableName, String fieldName)maps an XML element’s value to a specific table field and triggers encryption if configured.encodedQueryFor(String tableName)encrypts values that represent encoded queries when indicated by a filter attribute.getName()andgetAttributeValue(String name)help inspect element names and attributes to guide encryption logic.
Practical Usage Scenarios
- Mapping Known Table-Fields: Iterate over specific XML element paths (e.g.,
data/record/description) and callvalueFor()to encrypt and map values directly to known fields likeincident.shortdescription. - Mapping Unknown Table-Fields Dynamically: When the XML structure varies or is not fully known, iterate over all child elements of a record, dynamically determine field names, and call
valueFor()based on the table name and field name received in the request. The proxy inspects encryption configurations to decide if encryption is needed. - Handling Encoded Queries: If XML tags contain a
filterattribute set totrue, useencodedQueryFor()to encrypt encoded query strings. Otherwise, usevalueFor()for normal field encryption.
Key Outcomes
- Enables secure processing of XML payloads by integrating encryption logic directly into XML element iteration.
- Supports both static and dynamic mapping of XML data to ServiceNow tables and fields, accommodating varying XML structures.
- Allows selective encryption of sensitive data fields or encoded query strings based on configuration and XML attributes.
- Ensures data inserted into ServiceNow tables via XML APIs complies with encryption requirements, enhancing data security.
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.