Execute View

type Zendesk = {

  username: string;

  password: string;

  subdomain: string;

};

/**

 * Execute View

 * Returns the column titles and the rows of the specified view.

 */

export async function main(

  auth: Zendesk,

  view_id: string,

  sort_by: string | undefined,

  sort_order: string | undefined

) {

  const url = new URL(

    `https://${auth.subdomain}.zendesk.com/api/v2/views/${view_id}/execute`

  );

  for (const [k, v] of [

    ["sort_by", sort_by],

    ["sort_order", sort_order],

  ]) {

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

      url.searchParams.append(k, v);

    }

  }

  const response = await fetch(url, {

    method: "GET",

    headers: {

      Authorization: "Basic " + btoa(`${auth.username}:${auth.password}`),

    },

    body: undefined,

  });

  if (!response.ok) {

    const text = await response.text();

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

  }

  return await response.json();

}