Versions Compared

Old Version 6

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

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

Environment

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

(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

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

(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

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

...

How-To

Spec Name

XPath

Title

/xml/kb_knowledge/short_description

Unique ID

/xml/kb_knowledge/number

Body

/xml/kb_knowledge/text

Summary

/xml/kb_knowledge/intro_text

Author

/xml/kb_knowledge/author@display_value

Last updated

/xml/kb_knowledge/sys_updated_on

Site wide tag

/xml/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

/xml/kb_knowledge/short_description

Unique ID

/xml/kb_knowledge/number

Body

/xml/kb_knowledge/text

Summary

/xml/kb_knowledge/intro_text

Audience

/xml/kb_knowledge/u_audience

Category

/xml/kb_knowledge/u_web_category

Event Date

/xml/kb_knowledge/u_event_date

Expiration Date

/xml/kb_knowledge/valid_to

Last updated

/xml/kb_knowledge/sys_updated_on

Feed URLs

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