Edits history of script submission #22317 for ' Execute SOQL Query (salesforce)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  
  /**
   * Execute SOQL Query
   * Run a SOQL query and return matching records. Large result sets are paginated — follow nextRecordsUrl with the Query More action.
   */
  export async function main(auth: RT.Salesforce, query: string) {
    const apiVersion = auth.api_version || "v60.0"
    const url = new URL(`${auth.instance_url}/services/data/${apiVersion}/query`)
    url.searchParams.append("q", query)
  
    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