Delete 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))

}

/**

 * Delete Record

 * Delete a record by sys_id. ServiceNow returns 204 No Content on success, so this returns {success, sys_id}.

 */

export async function main(

  auth: RT.Servicenow,

  table: DynSelect_table,

  sys_id: string

) {

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

  const response = await fetch(url, {

    method: "DELETE",

    headers: {

      Authorization: authHeader(auth),

      Accept: "application/json",

    },

  })

  if (!response.ok) {

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

  }

  return { success: true, sys_id }

}