Bringing it in using Import Sets
SOAP and REST direct web services allow you to insert or update table data directly. It is like having all the fields available in a form, without any UI Policy, Client Scripts, or other browser-based checks. This means it is very easy to create and edit data using a SOAP or REST application-but also uncontrolled and unchecked. Business Rules are run to provide an element of validation, but the data format or schema must still match that of ServiceNow. For example, when populating the Priority field for a Maintenance task, one of the choice values must be supplied.
Import Sets is a set of technologies that work together to bring data into ServiceNow. It follows a particular pattern:
- The data is imported from a Data Source, which specifies what the data is and where it is stored. This can be a file or information retrieved from a database or web server. After parsing, it is stored unaltered in a staging table.
- The data is run through a Transform Map. This bridges...