Edits history of script submission #22725 for ' Delete Record (servicenow)'

• bunnative

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //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 }
  }
  

  Submitted by hugo989 5 days ago