0

Batch Update CRM Objects

by
Published today

Update up to 100 CRM records of one object type in a single call.

Script hubspot Verified

The script

Submitted by hugo989 Typescript (fetch-only)
Verified 4 hours ago
1
//native
2

3
export type DynSelect_object_type = string
4

5
// Dropdown of the standard CRM object types plus the account's custom objects.
6
export async function object_type(auth: RT.Hubspot) {
7
  const standard = [
8
    "contacts",
9
    "companies",
10
    "deals",
11
    "tickets",
12
    "line_items",
13
    "products",
14
    "quotes",
15
    "leads",
16
    "notes",
17
    "tasks",
18
    "meetings",
19
    "calls",
20
    "emails",
21
    "communications",
22
  ].map((o) => ({ value: o, label: o }))
23
  const response = await fetch("https://api.hubapi.com/crm/v3/schemas", {
24
    headers: {
25
      Authorization: `Bearer ${auth.token}`,
26
      Accept: "application/json",
27
    },
28
  })
29
  // A token without crm.schemas.custom.read still gets the standard objects.
30
  if (!response.ok) return standard
31
  const { results } = (await response.json()) as {
32
    results: { fullyQualifiedName: string; labels: { plural: string } }[]
33
  }
34
  return [
35
    ...standard,
36
    ...results.map((s) => ({
37
      value: s.fullyQualifiedName,
38
      label: `${s.labels.plural} (custom)`,
39
    })),
40
  ]
41
}
42

43
/**
44
 * Batch Update CRM Objects
45
 * Update up to 100 CRM records of one object type in a single call. Each input holds the record `id`, the `properties` to change, and optionally `idProperty` when `id` is a unique property value. Object types other than contacts, companies and deals need their own scope on the connection (e.g. tickets, crm.objects.line_items.read, crm.objects.custom.read).
46
 */
47
export async function main(
48
  auth: RT.Hubspot,
49
  object_type: DynSelect_object_type,
50
  inputs: {
51
    id: string
52
    properties: { [key: string]: any }
53
    idProperty?: string
54
  }[]
55
) {
56
  const url = new URL(
57
    `https://api.hubapi.com/crm/v3/objects/${object_type}/batch/update`
58
  )
59

60
  const body: { [key: string]: any } = {}
61
  body.inputs = inputs
62

63
  const response = await fetch(url, {
64
    method: "POST",
65
    headers: {
66
      Authorization: `Bearer ${auth.token}`,
67
      "Content-Type": "application/json",
68
      Accept: "application/json",
69
    },
70
    body: JSON.stringify(body),
71
  })
72

73
  if (!response.ok) {
74
    throw new Error(`${response.status} ${await response.text()}`)
75
  }
76

77
  return await response.json()
78
}
79