Drupal Knowledge Base Feed

Abstract

There is a need to extract KB data to feed Drupal versions of How-To and Status pages. There are a number of fields which are dependent and/or required for each use case, and that is generally enforced on the ServiceNow side (see Update Sets tagged with Requirement 567).

Feed URLs

Feed ID	URL
System Status (prod instance)	https://yale.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true
How-To (test instance)	https://yale.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic!%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true
System Status (test instance)	https://yaletest.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true
How-To (test instance)	https://yaletest.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic!%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true
System Status (dev instance)	https://yaledevelopment.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true
How-To (test instance)	https://yaledevelopment.service-now.com/kb_knowledge_list.do?sysparm_query=workflow_state%3Dpublished%5etopic!%3DNews%5eroles%3Dpublic%5Eu_publish_to_web_%3Dtrue&XML&useUnloadFormat=true

Accounts/Data

test data was created to validated the code changes and XML exports
user account s_sn_drupal (local, non-AD) was created to authenticate Drupal (see: /wiki/spaces/SN/pages/50469376)

Specification

https://docs.google.com/spreadsheet/ccc?key=0AokhQhmfxtzrdGY4Mi01dHRGQmFjaEtvTTNmbnNsa2c#gid=2

Field Mappings

How-To

Spec Name	XPath
Title	`//kb_knowledge/short_description`
Unique ID	`//kb_knowledge/number`
Body	`//kb_knowledge/text`
Summary	`//kb_knowledge/intro_text`
Author	`//kb_knowledge/author@display_value`
Last updated	`//kb_knowledge/sys_updated_on`
Site wide tag	`//kb_knowledge/u_web_taxonomy_txt`
Category (primary)	`//kb_knowledge/u_primary_web_category`
Category (secondary)	`//kb_knowledge/u_secondary_web_category`

Status/News

Spec Name	XPath
Title	`//kb_knowledge/short_description`
Unique ID	`//kb_knowledge/number`
Body	`//kb_knowledge/text`
Summary	`//kb_knowledge/intro_text`
Audience	`//kb_knowledge/u_audience`
Category	`//kb_knowledge/u_web_category`
Event Date	`//kb_knowledge/u_event_date`
Expiration Date	`//kb_knowledge/valid_to`
Last updated	`//kb_knowledge/sys_updated_on`