Edits history of script submission #22322 for ' Parameterized Search (salesforce)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  
  export type DynSelect_sobject = string
  export type DynMultiselect_fields = string[]
  
  // Dropdown of the org's objects (global describe).
  export async function sobject(auth: RT.Salesforce) {
    const apiVersion = auth.api_version || "v60.0"
    const response = await fetch(
      `${auth.instance_url}/services/data/${apiVersion}/sobjects/`,
      {
        headers: {
          Authorization: `Bearer ${auth.token}`,
          Accept: "application/json",
        },
      }
    )
    if (!response.ok) {
      throw new Error(`${response.status} ${await response.text()}`)
    }
    const { sobjects } = (await response.json()) as {
      sobjects: { name: string; label: string }[]
    }
    return sobjects
      .map((o) => ({ value: o.name, label: `${o.label} (${o.name})` }))
      .sort((a, b) => a.label.localeCompare(b.label))
  }
  
  // Dependent multi-select: fields of the chosen object (only relevant when sobject is set).
  export async function fields(auth: RT.Salesforce, sobject: DynSelect_sobject) {
    if (!sobject) return []
    const apiVersion = auth.api_version || "v60.0"
    const response = await fetch(
      `${auth.instance_url}/services/data/${apiVersion}/sobjects/${sobject}/describe`,
      {
        headers: {
          Authorization: `Bearer ${auth.token}`,
          Accept: "application/json",
        },
      }
    )
    if (!response.ok) {
      throw new Error(`${response.status} ${await response.text()}`)
    }
    const { fields: fieldList } = (await response.json()) as {
      fields: { name: string; label: string }[]
    }
    return fieldList
      .map((f) => ({ value: f.name, label: `${f.label} (${f.name})` }))
      .sort((a, b) => a.label.localeCompare(b.label))
  }
  
  /**
   * Parameterized Search
   * Search for a term without writing SOSL. Optionally restrict to one object and a chosen set of fields to return.
   */
  export async function main(
    auth: RT.Salesforce,
    q: string,
    sobject: DynSelect_sobject | undefined,
    fields: DynMultiselect_fields | undefined
  ) {
    const apiVersion = auth.api_version || "v60.0"
    const url = new URL(
      `${auth.instance_url}/services/data/${apiVersion}/parameterizedSearch`
    )
    url.searchParams.append("q", q)
    if (sobject !== undefined && sobject !== "") {
      url.searchParams.append("sobject", sobject)
      if (fields && fields.length > 0) {
        url.searchParams.append(`${sobject}.fields`, fields.join(","))
      }
    }
  
    const response = await fetch(url, {
      method: "GET",
      headers: {
        Authorization: `Bearer ${auth.token}`,
        Accept: "application/json",
      },
    })
  
    if (!response.ok) {
      throw new Error(`${response.status} ${await response.text()}`)
    }
  
    return await response.json()
  }
  

  Submitted by hugo989 9 days ago