Create schema to create delimited files in your ServiceNow instance.

Before you begin

  • Request an Integration Hub subscription.
  • Activate the Utility Actions spoke.
  • Role required: sn_utility_spoke.utility_actions_admin.

Procedure

  1. Navigate to All > IntegrationHub Utilities > File Builder > File Schemas.
  2. Click New.
  3. On the form, fill these values.
    Table 1. File Schema form
    FieldDescription
    Schema Name Name to identify the schema record. For example, Incident Schema.
    Delimiter Delimiter in the file. For example, , and \t. The default value is value is comma.
    Has Header Option to specify if the schema has header.
    Quoted Option to escape the delimiters and surround all values with quotation marks.
    Columns Columns of the schema as a JSON array. For each column, specify column name and data type. For example, 
    [
    {
        "name" : "Number",
        "type" : "string"
    },
    {
        "name" : "Caller First Name",
        "type" : "string"
    },
    {
        "name" : "Caller Last Name",
        "type" : "string"
    },
    {
        "name" : "Short Description",
        "type" : "string"
    },
    {
        "name" : "State",
        "type" : "choice",
        "choices" : [
            {
                "label" : "New",
                "value" : "New"
            },
            {
                "label" : "In Progress",
                "value" : "In Progress"
            },
           {
                "label" : "On Hold",
                "value" : "On Hold"
            },
            {
                "label" : "Resolved",
                "value" : "resolved"
            },
            {
                "label" : "Closed",
                "value" : "closed"
            }
        ]
    },
    {
        "name" : "Active",
        "type" : "boolean"
    }
]
    . For more information, see Create a data gathering action for a dynamic template.
    Note: Ensure that you surround the key and value with quotation marks.
  4. Click Submit.