Ctrl K

List sales orders

Published Oct 17, 2025

List all sales orders.

Script zoho Verified

Use in Windmill

The script

Submitted by hugo697 Bun

Verified 235 days ago

All edits

Permalink

//native
type Zoho = {
  token: string;
};
/**
 * List sales orders
 * List all sales orders.
 */
export async function main(
  auth: Zoho,
  organization_id: string | undefined,
  sort_column: string | undefined,
  search_text: string | undefined,
  filter_by: string | undefined,
  salesorder_number: string | undefined,
  item_name: string | undefined,
  item_id: string | undefined,
  item_description: string | undefined,
  reference_number: string | undefined,
  customer_name: string | undefined,
  total: string | undefined,
  date: string | undefined,
  shipment_date: string | undefined,
  status: string | undefined,
  customer_id: string | undefined,
  salesperson_id: string | undefined,
  salesorder_ids: string | undefined,
  zcrm_potential_id: string | undefined,
  last_modified_time: string | undefined,
  accept: string | undefined,
  print: string | undefined,
  customview_id: string | undefined,
) {
  const url = new URL(`https://www.zohoapis.com/books/v3/salesorders`);
  for (const [k, v] of [
    ["organization_id", organization_id],
    ["sort_column", sort_column],
    ["search_text", search_text],
    ["filter_by", filter_by],
    ["salesorder_number", salesorder_number],
    ["item_name", item_name],
    ["item_id", item_id],
    ["item_description", item_description],
    ["reference_number", reference_number],
    ["customer_name", customer_name],
    ["total", total],
    ["date", date],
    ["shipment_date", shipment_date],
    ["status", status],
    ["customer_id", customer_id],
    ["salesperson_id", salesperson_id],
    ["salesorder_ids", salesorder_ids],
    ["zcrm_potential_id", zcrm_potential_id],
    ["last_modified_time", last_modified_time],
    ["accept", accept],
    ["print", print],
    ["customview_id", customview_id],
  ]) {
    if (v !== undefined && v !== "" && k !== undefined) {
      url.searchParams.append(k, v);
    }
  }
  const response = await fetch(url, {
    method: "GET",
    headers: {
      Authorization: "Zoho-oauthtoken " + auth.token,
    },
    body: undefined,
  });
  if (!response.ok) {
    const text = await response.text();
    throw new Error(`${response.status} ${text}`);
  }
  return await response.json();
}


`1`	`//native`
`2`	`type Zoho = {`
`3`	`token: string;`
`4`	`};`
`5`	`/**`
`6`	`* List sales orders`
`7`	`* List all sales orders.`
`8`	`*/`
`9`	`export async function main(`
`10`	`auth: Zoho,`
`11`	`organization_id: string \| undefined,`
`12`	`sort_column: string \| undefined,`
`13`	`search_text: string \| undefined,`
`14`	`filter_by: string \| undefined,`
`15`	`salesorder_number: string \| undefined,`
`16`	`item_name: string \| undefined,`
`17`	`item_id: string \| undefined,`
`18`	`item_description: string \| undefined,`
`19`	`reference_number: string \| undefined,`
`20`	`customer_name: string \| undefined,`
`21`	`total: string \| undefined,`
`22`	`date: string \| undefined,`
`23`	`shipment_date: string \| undefined,`
`24`	`status: string \| undefined,`
`25`	`customer_id: string \| undefined,`
`26`	`salesperson_id: string \| undefined,`
`27`	`salesorder_ids: string \| undefined,`
`28`	`zcrm_potential_id: string \| undefined,`
`29`	`last_modified_time: string \| undefined,`
`30`	`accept: string \| undefined,`
`31`	`print: string \| undefined,`
`32`	`customview_id: string \| undefined,`
`33`	`) {`
`34`	const url = new URL(`https://www.zohoapis.com/books/v3/salesorders`);
`35`	`for (const [k, v] of [`
`36`	`["organization_id", organization_id],`
`37`	`["sort_column", sort_column],`
`38`	`["search_text", search_text],`
`39`	`["filter_by", filter_by],`
`40`	`["salesorder_number", salesorder_number],`
`41`	`["item_name", item_name],`
`42`	`["item_id", item_id],`
`43`	`["item_description", item_description],`
`44`	`["reference_number", reference_number],`
`45`	`["customer_name", customer_name],`
`46`	`["total", total],`
`47`	`["date", date],`
`48`	`["shipment_date", shipment_date],`
`49`	`["status", status],`
`50`	`["customer_id", customer_id],`
`51`	`["salesperson_id", salesperson_id],`
`52`	`["salesorder_ids", salesorder_ids],`
`53`	`["zcrm_potential_id", zcrm_potential_id],`
`54`	`["last_modified_time", last_modified_time],`
`55`	`["accept", accept],`
`56`	`["print", print],`
`57`	`["customview_id", customview_id],`
`58`	`]) {`
`59`	`if (v !== undefined && v !== "" && k !== undefined) {`
`60`	`url.searchParams.append(k, v);`
`61`	`}`
`62`	`}`
`63`	`const response = await fetch(url, {`
`64`	`method: "GET",`
`65`	`headers: {`
`66`	`Authorization: "Zoho-oauthtoken " + auth.token,`
`67`	`},`
`68`	`body: undefined,`
`69`	`});`
`70`	`if (!response.ok) {`
`71`	`const text = await response.text();`
`72`	throw new Error(`${response.status} ${text}`);
`73`	`}`
`74`	`return await response.json();`
`75`	`}`
`76`