Edits history of script submission #22733 for ' List Tables (servicenow)'

• bunnative

  Ap­pro­ved version

  Edit in Windmill

  Embed

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

  Submitted by hugo989 5 days ago