servicenow-import

{
  "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"
  ]
}

{
  "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"
  ]
}

{
  "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"
  ]
}