List Tables

//native

function authHeader(auth: RT.Servicenow) {

  return auth.token

    ? `Bearer ${auth.token}`

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

}

/**

 * List Tables

 * List the instance's tables (sys_db_object) with their API name, label, and sys_id. Optionally filter by a substring matched against name or label.

 */

export async function main(

  auth: RT.Servicenow,

  name_filter: string | undefined

) {

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

  url.searchParams.append("sysparm_fields", "name,label,sys_id")

  if (name_filter !== undefined && name_filter !== "") {

    url.searchParams.append(

      "sysparm_query",

      `nameLIKE${name_filter}^ORlabelLIKE${name_filter}`

    )

  }

  url.searchParams.append("sysparm_limit", "10000")

  const response = await fetch(url, {

    method: "GET",

    headers: {

      Authorization: authHeader(auth),

      Accept: "application/json",

    },

  })

  if (!response.ok) {

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

  }

  return await response.json()

}