Search Sheet

//native

type Smartsheet = {

  token: string;

  baseUrl: string;

};

/**

 * Search Sheet

 * Gets a list of the user's search results in a sheet based on query. The list contains an abbreviated row object for each search result in a sheet. If you have not used the public API in a while, we will need to provision your data. This could take up to 24 hours so please check back later! *Note* Newly created or recently updated data may not be immediately discoverable via search.

 */

export async function main(

  auth: Smartsheet,

  sheetId: string,

  query: string | undefined,

) {

  const url = new URL(`${auth.baseUrl}/search/sheets/${sheetId}`);

  for (const [k, v] of [["query", query]]) {

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

      url.searchParams.append(k, v);

    }

  }

  const response = await fetch(url, {

    method: "GET",

    headers: {

      Authorization: "Bearer " + auth.token,

    },

    body: undefined,

  });

  if (!response.ok) {

    const text = await response.text();

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

  }

  return await response.json();

}