Create Record

//native

export type DynSelect_table = string

function authHeader(auth: RT.Servicenow) {

  return auth.token

    ? `Bearer ${auth.token}`

    : `Basic ${btoa(`${auth.username}:${auth.password}`)}`

}

// Dropdown of the instance's tables (sys_db_object).

export async function table(auth: RT.Servicenow) {

  const response = await fetch(

    `${auth.instance_url}/api/now/table/sys_db_object?sysparm_fields=name,label&sysparm_limit=10000`,

    {

      headers: {

        Authorization: authHeader(auth),

        Accept: "application/json",

      },

    }

  )

  if (!response.ok) {

    throw new Error(`${response.status} ${await response.text()}`)

  }

  const { result } = (await response.json()) as {

    result: { name: string; label: string }[]

  }

  return result

    .filter((t) => t.name)

    .map((t) => ({ value: t.name, label: `${t.label} (${t.name})` }))

    .sort((a, b) => a.label.localeCompare(b.label))

}

/**

 * Create Record

 * Insert a record into any table (incident, change_request, sys_user, cmdb_ci, or a custom table). Pick the table from a live dropdown and pass a column/value map.

 */

export async function main(

  auth: RT.Servicenow,

  table: DynSelect_table,

  body: { [key: string]: any }

) {

  const url = new URL(`${auth.instance_url}/api/now/table/${table}`)

  const response = await fetch(url, {

    method: "POST",

    headers: {

      Authorization: authHeader(auth),

      "Content-Type": "application/json",

      Accept: "application/json",

    },

    body: JSON.stringify(body),

  })

  if (!response.ok) {

    throw new Error(`${response.status} ${await response.text()}`)

  }

  return await response.json()

}