servicenow-import

ServiceNow Imports - bulk data ingestion via import set staging tables

Server path: /servicenow-import | Type: Application | PCID required: Yes

Tools

Tool	Description
servicenow_import_get_result	Get the result of an import
servicenow_import_stage_multiple_records	Import multiple records into a staging table
servicenow_import_stage_record	Import a single record into a staging table

---

servicenow_import_get_result

Get the result of an import

Parameters:

Parameter	Type	Required	Default	Description
stagingTableName	string	Yes	—	Name of the import set staging table
sys_id	string	Yes	—	sys_id of the import set record

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "stagingTableName": {
      "type": "string",
      "description": "Name of the import set staging table"
    },
    "sys_id": {
      "type": "string",
      "description": "sys_id of the import set record"
    }
  },
  "required": [
    "PCID",
    "stagingTableName",
    "sys_id"
  ]
}

---

servicenow_import_stage_multiple_records

Import multiple records into a staging table

Parameters:

Parameter	Type	Required	Default	Description
stagingTableName	string	Yes	—	Name of the import set staging table
multi_import_set_id	string	No	—	sys_id to group multiple batch imports together under one import set
records	object[]	Yes	—	Array of records to import. Each record is an object of column name-value pairs (all values must be strings).

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "stagingTableName": {
      "type": "string",
      "description": "Name of the import set staging table"
    },
    "multi_import_set_id": {
      "type": "string",
      "description": "sys_id to group multiple batch imports together under one import set"
    },
    "records": {
      "type": "array",
      "items": {
        "type": "object"
      },
      "description": "Array of records to import. Each record is an object of column name-value pairs (all values must be strings)."
    }
  },
  "required": [
    "PCID",
    "stagingTableName",
    "records"
  ]
}

---

servicenow_import_stage_record

Import a single record into a staging table

Parameters:

Parameter	Type	Required	Default	Description
stagingTableName	string	Yes	—	Name of the import set staging table (e.g., u_import_users)
body	object	Yes	—	Record fields to import. All values must be strings (ServiceNow import set requirement). Keys are staging table column names.

Show inputSchema

{
  "type": "object",
  "properties": {
    "PCID": {
      "type": "string",
      "description": "Pink Connect ID for the authenticated connection"
    },
    "stagingTableName": {
      "type": "string",
      "description": "Name of the import set staging table (e.g., u_import_users)"
    },
    "body": {
      "type": "object",
      "description": "Record fields to import. All values must be strings (ServiceNow import set requirement). Keys are staging table column names."
    }
  },
  "required": [
    "PCID",
    "stagingTableName",
    "body"
  ]
}