Insert-or-update rows keyed on their business columns. Each row’s stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table’s own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.
The access token received from the authorization server in the OAuth 2.0 flow.
Scopes
tables:append
Path Parameters
table_id
string
required
Body
application/json
Upsert rows keyed on their business columns.
The primary key (s_id) is derived server-side from key_columns, so rows must
NOT carry s_id; re-sending the same entity updates it in place rather than
duplicating. Inherits the same per-row validation as append.
rows
Rows · object[]
required
Rows to upsert, 1 to 500 per request. Each row is an object of column_name to scalar value; values are coerced to their column type by the table's schema. Every row must carry the same column names. Do NOT include the primary key (s_id) — it is derived from key_columns.
Required array length: 1 - 500 elements
Show child attributes
key_columns
string[] | null
Business-key column names that identify a row. The stable primary key (s_id) is derived deterministically from just these columns, so the same entity always maps to the same row: re-sending it updates in place. Each must be present and non-empty in every row. Omit to use the table's own declared business keys — the usual case, so a caller need not restate keys the table already defines. If provided, must not be empty, and must match the table's declared key columns exactly whenever the rows carry any of them: the declared keys are the row identity the backend enforces, so no other identity can upsert them idempotently.
Minimum array length: 1
Response
Successful Response
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Summation","colors":{"primary":"#000000","light":"#888888","dark":"#000000"},"logo":{"light":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685","dark":"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685"},"favicon":{"light":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368","dark":"https://mintcdn.com/summation-676748f5/shsHObvGm-SkiZl8/images/favicon.ico?fit=max\u0026auto=format\u0026n=shsHObvGm-SkiZl8\u0026q=85\u0026s=25d44d855522b83a4467f76687386368"},"appearance":{"default":"light"},"navbar":{"primary":{"type":"button","label":"Get Started","href":"https://app.summation.com/signup"}},"fonts":{"family":"Inter"},"contextual":{"options":["copy","view","claude","chatgpt"],"display":"header"},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"summation-676748f5","hasAudioNarration":false,"actualSubdomain":"summation-676748f5","customDomains":["docs.summation.com"],"gitSource":{"type":"github","owner":"summationai","repo":"code","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af5cda8b51d0e31167b5abb","clientVersion":"0.0.4205","searchFilterCounts":[{"language":"default","tag":"API","count":156},{"language":"default","tag":"Endpoints","count":144},{"language":"default","tag":"Documentation","count":49},{"language":"default","tag":"Tables","count":31},{"language":"default","tag":"Connectors","count":21},{"language":"default","tag":"Key concepts","count":20},{"language":"default","tag":"Data Connectors","count":17},{"language":"default","tag":"Grid","count":13},{"language":"default","tag":"Conversations","count":12},{"language":"default","tag":"Use cases","count":11}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"a[href=\"https://app.summation.com/signup\"]{border:0!important;box-shadow:none!important}a[href=\"https://app.summation.com/signup\"]>*{background:#000000!important;color:#ffffff!important;box-shadow:none!important;padding-right:1rem!important;padding-left:1rem!important;gap:0!important}a[href=\"https://app.summation.com/signup\"] span,a[href=\"https://app.summation.com/signup\"] svg{color:#ffffff!important}a[href=\"https://app.summation.com/signup\"] svg{display:none!important}a[href=\"https://app.summation.com/signup\"]:hover>*{background:#27272a!important}html[data-current-path=\"/home\"] .eyebrow{display:none}html[data-current-path^=\"/features/\"] .eyebrow{display:none}html[data-current-path=\"/home\"] #header{max-width:41rem;margin-top:3rem}html[data-current-path=\"/home\"] .mdx-content{margin-top:1.5rem}html[data-current-path=\"/home\"] #content-area{width:100%;max-width:64rem}html[data-current-path=\"/home\"] #header>p{margin-top:0.75rem;color:#52525b;font-size:1.125rem;line-height:1.75rem}.home-get-started{display:inline-flex;min-width:10rem;height:2.75rem;align-items:center;justify-content:center;gap:0.5rem;padding-inline:1rem;border-radius:0.75rem;background:#000000;box-shadow:none!important;color:#ffffff!important;font-size:0.875rem;font-weight:500;line-height:1;text-decoration:none!important;transition:background-color 120ms ease}.home-get-started:hover{background:#27272a;box-shadow:none!important}.home-get-started:focus-visible{outline:2px solid #000000;outline-offset:3px}.home-get-started img{width:1rem;height:1rem}.home-section-divider{width:100%;height:0.5px;margin-block:2.5rem;background:#e7e7e7}.home-section-divider+.card-group{margin-top:0!important}html[data-current-path=\"/home\"] .card-group{width:100%;max-width:64rem;grid-template-columns:repeat(3, minmax(0, 1fr))!important;justify-content:center;gap:1.5rem!important}html[data-current-path=\"/home\"] .card-group>.card{--primary: 228 228 231;display:flex;width:100%;min-height:9.5rem;padding:1.3125rem 1.5rem;align-items:center;box-sizing:border-box;margin-block:0!important;border:var(--border-width-border-half, 0.5px) solid\n var(--border-layout-divider, #e7e7e7)!important;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:var(--color-neutral-white, #ffffff);box-shadow:0 1px 2px 0 rgb(0 0 0 / 5%);transition:background-color 120ms ease,\n box-shadow 120ms ease}html[data-current-path=\"/home\"] .card-group>.card:hover{background:#f4f4f5;border-color:#e4e4e7!important}html[data-current-path=\"/home\"] .card-group>.card>div{height:100%;width:100%;padding:0}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-title\"]{font-size:0.9375rem!important}html[data-current-path=\"/home\"] .card-group [data-component-part=\"card-content\"]{color:var(--home-card-description, #52525b)!important;font-size:0.875rem!important;line-height:1.25rem!important}html[data-current-path=\"/home\"] .card-group>.card svg{color:#000000!important}html.dark[data-current-path=\"/home\"] .card-group>.card{--primary-light: 63 63 70;--home-card-description: #888888;border-color:#3f3f46!important;background:#18181b}html.dark[data-current-path=\"/home\"] .card-group>.card svg{color:#f4f4f5!important}html.dark[data-current-path=\"/home\"] .card-group>.card:hover{background:#27272a;border-color:#3f3f46!important}html.dark[data-current-path=\"/home\"] .home-section-divider{background:#27272a}.card{background-color:#fafafa!important;transition:background-color 120ms ease,\n border-color 120ms ease}.card:hover{background-color:#f4f4f5!important}html.dark .card{background-color:#18181b!important}html.dark .card:hover{background-color:#232326!important}#content-area{box-sizing:content-box;width:auto;max-width:700px;margin-inline:auto}#page-title{font-size:2rem!important;line-height:2.5rem!important}#page-context-menu-button{border-radius:8px 0 0 8px!important}#page-context-menu>button[aria-label=\"More actions\"]{border-radius:0 8px 8px 0!important}html[data-current-path=\"/home\"] #page-context-menu{display:none!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:first-child{border-color:transparent!important}div[role=\"menu\"]:has([role=\"menuitem\"] [class~=\"wrap-break-word\"]) [role=\"menuitem\"]>div:nth-child(2)>div:first-child>svg{display:none!important}.mdx-content{font-size:15px;letter-spacing:-0.1px}.mdx-content a.link{border-bottom:0;font-weight:400;text-decoration-line:underline;text-decoration-style:dotted;text-decoration-color:#a1a1aa;text-decoration-thickness:from-font;text-decoration-skip-ink:none;text-underline-position:from-font;transition:text-decoration-color 120ms ease-out}.mdx-content a.link:hover{text-decoration-style:solid;text-decoration-color:currentColor}@media (prefers-reduced-motion: reduce){.mdx-content a.link{transition:none}}.mdx-content>h2{margin-top:3rem!important}#table-of-contents-content{--toc-indicator-height: 1.5rem;--toc-indicator-y: 0px;position:relative;border-left:1px solid #e4e4e7}nav:has(>div>#table-of-contents-content)>h2{display:none}#table-of-contents-content::before{position:absolute;top:0;left:-2px;width:3px;height:var(--toc-indicator-height);border-radius:0;background:#27272a;content:\"\";opacity:0;pointer-events:none;transform:translateY(var(--toc-indicator-y));transition:transform 240ms cubic-bezier(0.4, 0, 0.2, 1),\n height 240ms cubic-bezier(0.4, 0, 0.2, 1),\n opacity 120ms ease-out}#table-of-contents-content[data-has-active=\"true\"]::before{opacity:1}@media (prefers-reduced-motion: reduce){#table-of-contents-content::before{transition:opacity 120ms ease-out}}#table-of-contents-content .toc-item>a{padding-left:calc(\n var(--toc-padding-left) + var(--toc-focus-padding, 0rem) + 1rem\n )!important}#table-of-contents-content .toc-item[data-active=\"true\"]>a{font-weight:400;text-shadow:none!important}#table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#4f4f4f}#table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#000000}.dark #table-of-contents-content{border-left-color:#3f3f46}.dark #table-of-contents-content .toc-item[data-active=\"true\"]:not([data-toc-current=\"true\"])>a{color:#9e9e9e}.dark #table-of-contents-content .toc-item[data-toc-current=\"true\"]>a{color:#888888}.dark #table-of-contents-content::before{background:#f4f4f5}#navigation-items .sidebar-group>li+li{margin-top:4px}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{width:calc(100% - 0.5rem)!important;margin-left:0.5rem}#navigation-items .sidebar-group a,#navigation-items .sidebar-group button[aria-expanded]{padding-top:0.25rem!important;padding-bottom:0.25rem!important;line-height:1.25rem!important}#sidebar a[aria-current=\"page\"]{background-color:#f4f4f5!important;border-radius:8px!important;color:#000000!important;font-weight:500!important;text-shadow:none!important}#navigation-items a:not([aria-current=\"page\"]):hover{background-color:#fafafa!important}.dark #navigation-items a:not([aria-current=\"page\"]):hover{background-color:#18181b!important}.dark #sidebar a[aria-current=\"page\"]{background-color:#27272a!important;color:#ffffff!important}#sidebar button[aria-expanded]>div:last-child{margin-left:auto}#navigation-items .sidebar-group a span,#navigation-items .sidebar-group button span{hyphens:none}div:has(>form #search-input){padding:0!important;border:0!important;background:transparent!important;box-shadow:none!important}#theme-preference-menu-trigger{width:2.25rem;height:2.25rem;padding:0!important;border:0.5px solid #e4e4e7;border-radius:0.625rem!important}#theme-preference-menu-trigger [data-theme-preference-icon]{display:none!important}#theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:inline-flex!important}html[data-summation-theme-toggle=\"ready\"] #theme-preference-menu-content{display:none!important}.dark #theme-preference-menu-trigger{border-color:#27272a}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"dark\"]{display:none!important}.dark #theme-preference-menu-trigger [data-theme-preference-icon=\"light\"]{display:inline-flex!important}#header-ask-ai,#assistant-entry{display:none!important}.chat-assistant-floating-input{display:none!important}#pagination{display:grid;grid-template-columns:repeat(2, minmax(0, 1fr));gap:1.5rem;padding:0}#footer{border-top:0!important}html[data-current-path=\"/home\"] #pagination{display:none!important}#pagination>a{display:grid;box-sizing:border-box;min-width:0;height:5rem;align-content:center;padding:1rem 1.5rem;column-gap:0.75rem;row-gap:0.5rem;border:1px solid #e4e4e7;border-radius:0.75rem;background:transparent;font-weight:400;transition:border-color 120ms ease,\n background-color 120ms ease}#pagination>a:hover{border-color:#d4d4d8;background:#fafafa}#pagination>a::before{color:#71717a;font-size:0.8125rem;font-weight:400;line-height:1.25rem}#pagination .pagination-prev{grid-template-columns:auto minmax(0, 1fr)}#pagination .pagination-prev::before{grid-column:2;grid-row:1;content:\"Previous\"}#pagination .pagination-next{grid-template-columns:minmax(0, 1fr) auto;margin-left:0;text-align:right}#pagination .pagination-next::before{grid-column:1;grid-row:1;content:\"Next\"}#pagination [data-component-part=\"pagination-chevron\"]{grid-row:1;width:0.25rem;height:0.5rem;align-self:center;stroke-width:1}#pagination [data-component-part=\"pagination-chevron\"] path{stroke-width:1!important}#pagination [data-component-part=\"pagination-title\"]{grid-column:1 / -1;grid-row:2;color:#27272a;font-size:0.9375rem;font-weight:400;line-height:1.5rem}.dark #pagination>a{border-color:#3f3f46}.dark #pagination>a:hover{border-color:#52525b;background:#18181b}.dark #pagination [data-component-part=\"pagination-title\"]{color:#f4f4f5}header .max-w-8xl{max-width:none!important;margin-inline:0!important}#navbar a[href=\"/\"]:has(.nav-logo){display:flex;align-items:center}#navbar a[href=\"/\"] .nav-logo{height:1.25rem!important}.dark #navbar a[href=\"/\"] .nav-logo{filter:invert(1)}#navbar .max-w-8xl>div>div>.flex.items-center{padding-inline:1.5rem!important}@media (max-width: 639px){#navbar a[href=\"/\"] .nav-logo{height:1.125rem!important}}#navbar>div:first-child{border-bottom-color:#f0f0f0!important}:root{--topbar-tabs-height: 0rem !important}@media (min-width: 1024px){#navbar div.hidden.lg\\:flex.px-12.h-12{position:absolute!important;top:0!important;left:183px!important;height:4rem!important;padding:0!important;width:auto!important}#navbar .nav-tabs{column-gap:2rem}#navbar .nav-tabs-item{gap:0.5rem;white-space:nowrap}#navbar .nav-tabs-item:hover>div.absolute.bottom-0{background-color:currentColor}#navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#27272a!important}.dark #navbar .nav-tabs-item[aria-current=\"location\"]>div.absolute.bottom-0{background-color:#888888!important}#navbar .nav-tabs-item[aria-current=\"location\"]{text-shadow:none!important}}@media (min-width: 1024px){#navbar div:has(>#search-bar-entry){flex:0 1 16rem;min-width:12rem}#navbar div:has(>nav[aria-label=\"Main\"]){flex:0 0 auto;margin-left:0}}#search-bar-entry:focus-visible{outline:2px solid currentColor;outline-offset:2px}.sidebar-group-header--collapsible{cursor:pointer;user-select:none}.sidebar-group-header--collapsible:hover{color:#18181b}.dark .sidebar-group-header--collapsible:hover{color:#f4f4f5}.sidebar-group-header--collapsible:focus-visible{outline:2px solid #a1a1aa;outline-offset:2px;border-radius:4px}.sidebar-group-chevron{margin-left:auto;transform:rotate(90deg);transition:transform 120ms ease}.sidebar-group-header--collapsible[data-sidebar-collapsed=\"true\"] .sidebar-group-chevron{transform:rotate(0deg)}ul.sidebar-group[data-sidebar-collapsed=\"true\"]{display:none}header div:has(>#theme-preference-menu-trigger){margin-left:0.5rem!important}#navbar nav:has(a[href=\"https://app.summation.com/signup\"]){margin-right:0!important}header a[href=\"https://app.summation.com/signup\"]{padding-inline:0.75rem!important}header a[href=\"https://app.summation.com/signup\"]>div{padding-inline:0!important;background:#000000!important}@media (min-width: 1024px){html[data-current-path=\"/home\"] #content-container{position:relative;left:7.5rem}#sidebar{width:280px!important;max-width:280px;transform:translateX(min(-2rem, calc((92rem - 100vw) / 2 - 2rem)));border-right:1px solid #f0f0f0}html:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #sidebar{transform:translateX(min(-2rem, calc((115rem - 100vw) / 2 - 2rem)))}#sidebar>#sidebar-content{top:0!important;left:1.5rem!important}#sidebar-content>[class~=\"pr-8\"]{padding-right:1.5rem!important}#sidebar-content .sticky.top-0.h-8{height:1.5rem}#sidebar-content>[data-component-part=\"scroll-area-scrollbar\"][data-orientation=\"vertical\"]{inset-inline-end:-2.5px!important;margin-inline:0!important}.dark #sidebar{border-right-color:rgba(255, 255, 255, 0.18)}}@media (min-width: 1280px){html[data-current-path=\"/home\"] #header,html[data-current-path=\"/home\"] .mdx-content{transform:translateX(-1.625rem)}html[data-current-path=\"/home\"] .mdx-content{width:calc(100% + 5.25rem)}}@media (min-width: 1024px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:0}}@media (min-width: 1280px) and (max-width: 1599px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #header,html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{transform:none}html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) .mdx-content{width:100%}}@media (min-width: 1600px) and (max-width: 1839px){html[data-current-path=\"/home\"]:has(#chat-assistant-sheet[aria-hidden=\"false\"]) #content-container{left:calc(50vw - 50rem)}}@media (max-width: 767px){#pagination{grid-template-columns:minmax(0, 1fr)}html[data-current-path=\"/home\"] #header{margin-top:2rem}html[data-current-path=\"/home\"] #header>p{font-size:1rem;line-height:1.5rem}.home-section-divider{margin-block:1.5rem}html[data-current-path=\"/home\"] .card-group{grid-template-columns:minmax(0, 1fr)!important}}figure[data-name=\"frame\"]{padding:1.25rem!important;margin-top:0!important;margin-bottom:1.5rem!important;border-radius:var(--border-radius-rounded-xl, 0.75rem)!important;background:#fafafa!important}.columns figure[data-name=\"frame\"]{margin-bottom:0!important}.columns{margin-top:0!important;margin-bottom:1.5rem!important;row-gap:1.5rem!important}html.dark figure[data-name=\"frame\"]{background:#18181b!important}figure[data-name=\"frame\"]>div[class*=\"bg-grid\"]{display:none}figure[data-name=\"frame\"]>div[class*=\"justify-center\"]{overflow:visible;border-radius:0}figure[data-name=\"frame\"] img{border-radius:0.375rem;box-shadow:0 0 0 0.5px #d4d4d8,\n 0 1px 2px 0 rgb(0 0 0 / 5%)}html.dark figure[data-name=\"frame\"] img{box-shadow:0 0 0 0.5px #3f3f46,\n 0 1px 2px 0 rgb(0 0 0 / 30%)}figure[data-name=\"frame\"]>div[class*=\"pointer-events-none\"]{border-color:transparent}@media (max-width: 767px){figure[data-name=\"frame\"]{padding:0.75rem!important}}html[data-current-path=\"/introduction\"] .card-group,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center){row-gap:0.5rem!important}html[data-current-path=\"/introduction\"] .card-group>.card,html[data-current-path=\"/use-cases/overview\"] .card-group:has(>.card [data-component-part=\"card-content-container\"].items-center)>.card{margin-block:0!important}.template-meta{display:grid;grid-template-columns:7.5rem minmax(0, 1fr);gap:0.5rem 1rem;margin:0 0 1.5rem;padding:1.25rem;border-radius:var(--border-radius-rounded-xl, 0.75rem);background:#fafafa}.template-meta-label{margin:0;font-weight:500;color:#71717a}.template-meta-value{margin:0}html.dark .template-meta{background:#18181b}html.dark .template-meta-label{color:#a1a1aa}@media (max-width: 639px){.template-meta{grid-template-columns:minmax(0, 1fr);gap:0.25rem;padding:1rem}.template-meta-value:not(:last-child){margin-bottom:0.5rem}}"}],"page":{"pagePath":"api-reference/tables/upsert-rows-into-a-table","slug":"/api-reference/tables/upsert-rows-into-a-table","pageMetadata":{"title":"Upsert rows into a table","description":"Insert-or-update rows keyed on their business columns. Each row's stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. `key_columns` is optional: omit it to use the table's own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/tables/{table_id}/rows","href":"/api-reference/tables/upsert-rows-into-a-table","autogeneratedByOpenApi":true},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n code: \"code\",\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsxs(_components.p, {\n children: [\"Insert-or-update rows keyed on their business columns. Each row’s stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. \", _jsx(_components.code, {\n children: \"key_columns\"\n }), \" is optional: omit it to use the table’s own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\"]\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){return _jsx(_Fragment,{})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Upsert rows into a table","description":"Insert-or-update rows keyed on their business columns. Each row's stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. `key_columns` is optional: omit it to use the table's own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/tables/{table_id}/rows","href":"/api-reference/tables/upsert-rows-into-a-table","autogeneratedByOpenApi":true}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":["/_mintlify/custom/summation-676748f5/109fb4ec55c4f518/theme-toggle.js","/_mintlify/custom/summation-676748f5/767147eed46ae967/toc-indicator.js","/_mintlify/custom/summation-676748f5/82e2d1909a80e450/sidebar-collapse.js"],"openApiReferenceData":{"operation":{"tags":["Tables"],"summary":"Upsert rows into a table","description":"Insert-or-update rows keyed on their business columns. Each row's stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. `key_columns` is optional: omit it to use the table's own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.","operationId":"upsert_table_rows","security":["a701a8de-0327-4d56-95ae-f1ecd7085e79"],"parameters":["4e3b2230-5dc2-4188-b9cf-01900d39ea6b"],"requestBody":"59861bc3-f885-4a9b-8064-9a2edadc9e10","responses":{"200":"3ea8e6be-3fbe-483e-bb24-458d650b096a","207":"5cb85548-ddd8-45f4-80ce-5b5a7a8c9127","400":"10e4edf8-a827-4f52-bba6-b991a1ee3688","401":"d9be8790-47f1-42fd-bd06-19599e9203da","403":"7b32da86-621c-4661-aba3-06343f090e63","404":"eaab393a-76d8-4f90-8cb9-bf97e3c9e55f","422":"7196775c-09ba-4bb1-bf65-4efda6614b54","429":"7a56525f-203d-4c56-bb1c-5ad1925a2454","500":"396b3225-e650-456e-ab7a-5bbf61c80caf"},"method":"put","type":"path","servers":[],"path":"/v1/tables/{table_id}/rows","baseUrlOptions":[],"title":"Upsert rows into a table","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"4e3b2230-5dc2-4188-b9cf-01900d39ea6b":{"name":"table_id","in":"path","required":true,"schema":{"type":"string","title":"Table Id","isRequired":true,"uniqueKey":"","typeLabel":"string"}}},"requestBody":{"required":true,"content":{"application/json":{"schema":{"properties":{"rows":{"items":{"additionalProperties":{"oneOf":[{"type":"string","uniqueKey":"rows.items.[INDEX].additionalProperties.oneOf.0","typeLabel":"string"},{"type":"integer","uniqueKey":"rows.items.[INDEX].additionalProperties.oneOf.1","typeLabel":"integer"},{"type":"number","uniqueKey":"rows.items.[INDEX].additionalProperties.oneOf.2","typeLabel":"number"},{"type":"boolean","uniqueKey":"rows.items.[INDEX].additionalProperties.oneOf.3","typeLabel":"boolean"},{"type":"null","uniqueKey":"rows.items.[INDEX].additionalProperties.oneOf.4","typeLabel":"null"}],"uniqueKey":"rows.items.[INDEX].additionalProperties","typeLabel":"string | integer | number | boolean | null"},"type":"object","uniqueKey":"rows.items.[INDEX]","typeLabel":"object"},"type":"array","maxItems":500,"minItems":1,"title":"Rows","description":"Rows to upsert, 1 to 500 per request. Each row is an object of column_name to scalar value; values are coerced to their column type by the table's schema. Every row must carry the same column names. Do NOT include the primary key (s_id) — it is derived from key_columns.","isRequired":true,"uniqueKey":"rows","typeLabel":"Rows · object[]"},"key_columns":{"oneOf":[{"type":"array","items":{"type":"string","uniqueKey":"key_columns.oneOf.0.items.[INDEX]","typeLabel":"string"},"title":"Key Columns","description":"Business-key column names that identify a row. The stable primary key (s_id) is derived deterministically from just these columns, so the same entity always maps to the same row: re-sending it updates in place. Each must be present and non-empty in every row. Omit to use the table's own declared business keys — the usual case, so a caller need not restate keys the table already defines. If provided, must not be empty, and must match the table's declared key columns exactly whenever the rows carry any of them: the declared keys are the row identity the backend enforces, so no other identity can upsert them idempotently.","minItems":1,"uniqueKey":"key_columns.oneOf.0","typeLabel":"string[]"},{"type":"null","title":"Key Columns","description":"Business-key column names that identify a row. The stable primary key (s_id) is derived deterministically from just these columns, so the same entity always maps to the same row: re-sending it updates in place. Each must be present and non-empty in every row. Omit to use the table's own declared business keys — the usual case, so a caller need not restate keys the table already defines. If provided, must not be empty, and must match the table's declared key columns exactly whenever the rows carry any of them: the declared keys are the row identity the backend enforces, so no other identity can upsert them idempotently.","uniqueKey":"key_columns.oneOf.1","typeLabel":"null"}],"uniqueKey":"key_columns","typeLabel":"string[] | null"}},"additionalProperties":false,"type":"object","required":["rows"],"title":"TableUpsertRowsRequest","description":"Upsert rows keyed on their business columns.\n\nThe primary key (s_id) is derived server-side from key_columns, so rows must\nNOT carry s_id; re-sending the same entity updates it in place rather than\nduplicating. Inherits the same per-row validation as append.","uniqueKey":"","typeLabel":"TableUpsertRowsRequest · object"},"examples":{"Example":{"title":"Example","value":{"rows":[{}],"key_columns":["\u003cstring>"]}}},"exampleType":"generated"}},"exampleType":"generated"},"responses":{"3ea8e6be-3fbe-483e-bb24-458d650b096a":{"description":"Successful Response","content":{"application/json":{"schema":{}}},"exampleType":"generated"},"5cb85548-ddd8-45f4-80ce-5b5a7a8c9127":{"description":"Some rows upserted; response includes errors for failed rows.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"10e4edf8-a827-4f52-bba6-b991a1ee3688":{"description":"Invalid request or unsupported option.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"d9be8790-47f1-42fd-bd06-19599e9203da":{"description":"Missing, invalid, or expired credentials.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"7b32da86-621c-4661-aba3-06343f090e63":{"description":"Authenticated but missing the required scope.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"eaab393a-76d8-4f90-8cb9-bf97e3c9e55f":{"description":"Resource not found or not accessible.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"7196775c-09ba-4bb1-bf65-4efda6614b54":{"description":"No rows upserted; response includes row-level errors.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"7a56525f-203d-4c56-bb1c-5ad1925a2454":{"description":"Rate limit exceeded.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"},"396b3225-e650-456e-ab7a-5bbf61c80caf":{"description":"Internal server error.","content":{"application/problem+json":{"schema":{"description":"Public error envelope (RFC 7807 ``application/problem+json``).\n\nMirrors the body produced by :func:`api_error`. Declaring it in the contract\nlets generated clients type error handling instead of guessing.","properties":{"type":{"description":"URI reference identifying the problem type.","title":"Type","type":"string","isRequired":true,"uniqueKey":"type","typeLabel":"string"},"title":{"description":"Short, human-readable summary of the problem type.","title":"Title","type":"string","isRequired":true,"uniqueKey":"title","typeLabel":"string"},"status":{"description":"HTTP status code.","title":"Status","type":"integer","isRequired":true,"uniqueKey":"status","typeLabel":"integer"},"detail":{"description":"Human-readable explanation specific to this occurrence.","title":"Detail","type":"string","isRequired":true,"uniqueKey":"detail","typeLabel":"string"},"code":{"description":"Stable, machine-readable error code.","title":"Code","type":"string","isRequired":true,"uniqueKey":"code","typeLabel":"string"},"request_id":{"description":"Correlation id, echoed in the x-request-id header.","title":"Request Id","type":"string","isRequired":true,"uniqueKey":"request_id","typeLabel":"string"}},"required":["type","title","status","detail","code","request_id"],"title":"ProblemError","type":"object","uniqueKey":"","typeLabel":"ProblemError · object"},"examples":{"Example":{"title":"Example","value":{"type":"\u003cstring>","title":"\u003cstring>","status":123,"detail":"\u003cstring>","code":"\u003cstring>","request_id":"\u003cstring>"}}},"exampleType":"generated"}},"exampleType":"generated"}},"security":{"a701a8de-0327-4d56-95ae-f1ecd7085e79":{"SummationMachineAuth":{"type":"oauth2","flows":{"clientCredentials":{"scopes":{"agent:read":"agent:read","agent:write":"agent:write"},"tokenUrl":"/v1/auth/m2m/token"}},"scopes":["tables:append"],"schemeName":"SummationMachineAuth"}}},"servers":{},"processedSecurityOptions":[{"schemes":[{"scheme":{"type":"oauth2","flows":{"clientCredentials":{"scopes":{"agent:read":"agent:read","agent:write":"agent:write"},"tokenUrl":"/v1/auth/m2m/token"}},"scopes":["tables:append"],"schemeName":"SummationMachineAuth"},"schema":{"title":"OAuth2 Auth","type":"string","isRequired":true,"description":"The access token received from the authorization server in the OAuth 2.0 flow.","format":"bearer","typeLabel":"string\u003cbearer>","deprecated":false},"schemeName":"SummationMachineAuth","name":"Authorization"}],"title":"SummationMachineAuth"}]},"originalFileLocation":"https://api.summation.com/openapi.json"},"subdomain":"summation-676748f5","siteName":"Summation","title":"Upsert rows into a table - Summation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-28T20:05:20.989Z","originalFileLocation":"api-reference/tables/upsert-rows-into-a-table.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Insert-or-update rows keyed on their business columns. Each row\u0026#x27;s stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table\u0026#x27;s own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Summation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Upsert rows into a table - Summation\">\u003cmeta data-mint-head property=\"og:description\" content=\"Insert-or-update rows keyed on their business columns. Each row\u0026#x27;s stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table\u0026#x27;s own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Summation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Tables\u0026amp;title=Upsert+rows+into+a+table\u0026amp;description=Insert-or-update+rows+keyed+on+their+business+columns.+Each+row%27s+stable+primary+key+%28s_id%29+is+derived+from+the+key+columns%2C+so+rows+whose+key+already+exists+ar\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=b3fd10fef08e67843a09d3e03635da0c8d2013f058cee7636fa8592f58ec9a8c\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Upsert rows into a table - Summation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Insert-or-update rows keyed on their business columns. Each row\u0026#x27;s stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table\u0026#x27;s own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://summation-676748f5.mintlify.site/_mintlify/api/og/v2?division=Tables\u0026amp;title=Upsert+rows+into+a+table\u0026amp;description=Insert-or-update+rows+keyed+on+their+business+columns.+Each+row%27s+stable+primary+key+%28s_id%29+is+derived+from+the+key+columns%2C+so+rows+whose+key+already+exists+ar\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=b3fd10fef08e67843a09d3e03635da0c8d2013f058cee7636fa8592f58ec9a8c\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/summation-676748f5/s-DowS6hFbVgFajy/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Summation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#000000\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/api-reference/tables/upsert-rows-into-a-table.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.summation.com/#organization\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/summation-676748f5/VNNtt3ifsblE4Ta9/images/summation-logo.svg?fit=max\u0026auto=format\u0026n=VNNtt3ifsblE4Ta9\u0026q=85\u0026s=6d050102e07df435f3532e1a4e34e685\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.summation.com#website\",\"name\":\"Summation\",\"url\":\"https://docs.summation.com\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table#webpage\",\"url\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table\",\"name\":\"Upsert rows into a table\",\"description\":\"Insert-or-update rows keyed on their business columns. Each row's stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table's own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\",\"dateModified\":\"2026-10-28T20:05:20.989Z\",\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Endpoints\",\"item\":\"https://docs.summation.com/api-reference/auth/create-a-machine-access-token\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tables\",\"item\":\"https://docs.summation.com/api-reference/tables/list-tables\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Upsert rows into a table\",\"item\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table#apireference\",\"headline\":\"Upsert rows into a table\",\"name\":\"Upsert rows into a table\",\"description\":\"Insert-or-update rows keyed on their business columns. Each row's stable primary key (s_id) is derived from the key columns, so rows whose key already exists are updated in place and new keys are inserted — sending the same entity again is idempotent. key_columns is optional: omit it to use the table's own declared business keys (the usual case), or pass it to override — an override must match the declared keys exactly unless the rows leave the declared key columns out entirely. Returns 200 when all succeed, 207 when some fail (see errors), and 422 when none do. Requires the tables:append scope.\",\"url\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table\",\"mainEntityOfPage\":{\"@id\":\"https://docs.summation.com/api-reference/tables/upsert-rows-into-a-table#webpage\"},\"dateModified\":\"2026-10-28T20:05:20.989Z\",\"publisher\":{\"@id\":\"https://docs.summation.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Summation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Summation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/api-reference/tables/upsert-rows-into-a-table.md","siteName":"Summation","nav":{"global":null,"tabs":[{"tab":"Documentation","icon":"book-open","pages":[{"title":"Documentation","href":"/introduction"}]},{"tab":"Use cases","icon":"lightbulb","pages":[{"title":"Use cases","href":"/use-cases/overview"}]},{"tab":"API","icon":"code","groups":[{"group":"Introduction","pages":[{"title":"Overview","href":"/api/overview"},{"title":"CLI","href":"/api/cli"},{"title":"Authentication","href":"/api/authentication"},{"title":"Conventions","href":"/api/conventions"},{"title":"API coverage","href":"/api/coverage"}]},{"group":"Resources","pages":[{"title":"Conversations","href":"/api/conversations"},{"title":"Projects \u0026 files","href":"/api/projects-and-files"},{"title":"Reports","href":"/api/reports"},{"title":"Playbooks \u0026 schedules","href":"/api/playbooks-and-schedules"},{"title":"Workflows","href":"/api/workflows"},{"title":"Tables \u0026 views","href":"/api/tables"},{"title":"Connections","href":"/api/connections"}]},{"group":"Endpoints","pages":[{"group":"Auth","pages":[{"title":"Create a machine access token","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/auth/m2m/token","href":"/api-reference/auth/create-a-machine-access-token"},{"title":"Exchange an identity assertion for a member token","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/auth/token-exchange","href":"/api-reference/auth/exchange-an-identity-assertion-for-a-member-token"},{"title":"Show current identity","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/me","href":"/api-reference/auth/show-current-identity"},{"title":"Show current identity","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/auth/status","href":"/api-reference/auth/show-current-identity-1"},{"title":"Clear client credentials","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/auth/logout","href":"/api-reference/auth/clear-client-credentials"}]},{"group":"Tenant","pages":[{"title":"Get organization details","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tenant/org","href":"/api-reference/tenant/get-organization-details"}]},{"group":"Projects","pages":[{"title":"List projects","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects","href":"/api-reference/projects/list-projects"},{"title":"Create project","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects","href":"/api-reference/projects/create-project"},{"title":"Show default project","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/default","href":"/api-reference/projects/show-default-project"},{"title":"Show project","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}","href":"/api-reference/projects/show-project"},{"title":"Delete project","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/projects/{project_id}","href":"/api-reference/projects/delete-project"},{"title":"Update project","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/projects/{project_id}","href":"/api-reference/projects/update-project"}]},{"group":"Conversations","pages":[{"title":"List chat models","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/chat-models","href":"/api-reference/conversations/list-chat-models"},{"title":"List conversations","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/conversations","href":"/api-reference/conversations/list-conversations"},{"title":"Create conversation and stream response","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/conversations","href":"/api-reference/conversations/create-conversation-and-stream-response"},{"title":"Show conversation","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/conversations/{chat_id}","href":"/api-reference/conversations/show-conversation"},{"title":"Create message and stream response","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/conversations/{chat_id}/messages","href":"/api-reference/conversations/create-message-and-stream-response"},{"title":"Stream message events","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/conversations/{chat_id}/messages/{message_id}/events","href":"/api-reference/conversations/stream-message-events"},{"title":"Submit message feedback","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/conversations/{chat_id}/messages/{message_id}/feedback","href":"/api-reference/conversations/submit-message-feedback"},{"title":"List queued messages","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/conversations/{chat_id}/queue","href":"/api-reference/conversations/list-queued-messages"},{"title":"Show queued message","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/conversations/{chat_id}/queue/{queued_message_id}","href":"/api-reference/conversations/show-queued-message"},{"title":"Withdraw queued message","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/projects/{project_id}/conversations/{chat_id}/queue/{queued_message_id}","href":"/api-reference/conversations/withdraw-queued-message"},{"title":"Resume queued messages","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/conversations/{chat_id}/queue/resume","href":"/api-reference/conversations/resume-queued-messages"},{"title":"Cancel analyst reply","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/conversations/{chat_id}/messages/{message_id}/cancel","href":"/api-reference/conversations/cancel-analyst-reply"}]},{"group":"Reports","pages":[{"title":"List reports","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/reports","href":"/api-reference/reports/list-reports"},{"title":"Generate report and stream response","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/reports/generations","href":"/api-reference/reports/generate-report-and-stream-response"},{"title":"Show report","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/reports/{report_id}","href":"/api-reference/reports/show-report"},{"title":"Delete report","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/projects/{project_id}/reports/{report_id}","href":"/api-reference/reports/delete-report"},{"title":"Verify report and stream response","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/reports/{report_id}/verifications","href":"/api-reference/reports/verify-report-and-stream-response"},{"title":"Export report content","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/reports/{report_id}/content","href":"/api-reference/reports/export-report-content"}]},{"group":"Playbooks","pages":[{"title":"List playbooks","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/playbooks","href":"/api-reference/playbooks/list-playbooks"},{"title":"Show playbook","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/playbooks/{playbook_id}","href":"/api-reference/playbooks/show-playbook"}]},{"group":"Files","pages":[{"title":"List or search files","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/files","href":"/api-reference/files/list-or-search-files"},{"title":"Write file content","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/projects/{project_id}/files/content","href":"/api-reference/files/write-file-content"},{"title":"Show file","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/files/{file_id}","href":"/api-reference/files/show-file"},{"title":"Delete file","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/projects/{project_id}/files/{file_id}","href":"/api-reference/files/delete-file"},{"title":"Create file download URL","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/files/{file_id}/download-url","href":"/api-reference/files/create-file-download-url"},{"title":"Download file content","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/files/{file_id}/content","href":"/api-reference/files/download-file-content"},{"title":"Create a presigned upload","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/files/uploads","href":"/api-reference/files/create-a-presigned-upload"},{"title":"Finalize a presigned upload","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/files/uploads/{upload_id}/finalize","href":"/api-reference/files/finalize-a-presigned-upload"},{"title":"Import file through agent workflow","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/files/{file_id}/imports","href":"/api-reference/files/import-file-through-agent-workflow"}]},{"group":"Catalog Entries","pages":[{"title":"List project catalog entries","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/catalog-entries","href":"/api-reference/catalog-entries/list-project-catalog-entries"},{"title":"Attach table or view to project catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/catalog-entries","href":"/api-reference/catalog-entries/attach-table-or-view-to-project-catalog"},{"title":"Show project catalog entry","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/projects/{project_id}/catalog-entries/{catalog_entry_id}","href":"/api-reference/catalog-entries/show-project-catalog-entry"},{"title":"Detach project catalog entry","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/projects/{project_id}/catalog-entries/{catalog_entry_id}","href":"/api-reference/catalog-entries/detach-project-catalog-entry"},{"title":"Refresh project catalog entry","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/projects/{project_id}/catalog-entries/{catalog_entry_id}/refreshes","href":"/api-reference/catalog-entries/refresh-project-catalog-entry"}]},{"group":"Data Connectors","pages":[{"title":"List connections","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data","href":"/api-reference/data-connectors/list-connections"},{"title":"Create connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/data","href":"/api-reference/data-connectors/create-connection"},{"title":"Update connection snapshot policy","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/connections/data/{connection_id}/snapshot-config","href":"/api-reference/data-connectors/update-connection-snapshot-policy"},{"title":"Update connection settings","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/connections/data/{connection_id}/config","href":"/api-reference/data-connectors/update-connection-settings"},{"title":"List connector types","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data/types","href":"/api-reference/data-connectors/list-connector-types"},{"title":"Show connector type","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data/types/{connector_type}","href":"/api-reference/data-connectors/show-connector-type"},{"title":"Show connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data/{connection_id}","href":"/api-reference/data-connectors/show-connection"},{"title":"Delete connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/connections/data/{connection_id}","href":"/api-reference/data-connectors/delete-connection"},{"title":"Update connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/connections/data/{connection_id}","href":"/api-reference/data-connectors/update-connection"},{"title":"Browse connection resources","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/data/{connection_id}/resources","href":"/api-reference/data-connectors/browse-connection-resources"},{"title":"List connection datasets","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data/{connection_id}/datasets","href":"/api-reference/data-connectors/list-connection-datasets"},{"title":"Attach connection datasets","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/data/{connection_id}/datasets","href":"/api-reference/data-connectors/attach-connection-datasets"},{"title":"Detach connection dataset","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/connections/data/{connection_id}/datasets/{dataset_id}","href":"/api-reference/data-connectors/detach-connection-dataset"},{"title":"Update connection dataset","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/connections/data/{connection_id}/datasets/{dataset_id}","href":"/api-reference/data-connectors/update-connection-dataset"},{"title":"Test connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/data/{connection_id}/tests","href":"/api-reference/data-connectors/test-connection"},{"title":"Snapshot dataset","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/data/{connection_id}/datasets/{dataset_id}/snapshots","href":"/api-reference/data-connectors/snapshot-dataset"},{"title":"List snapshot runs","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/data/{connection_id}/snapshots","href":"/api-reference/data-connectors/list-snapshot-runs"}]},{"group":"App Connectors","pages":[{"title":"List app connections","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/app","href":"/api-reference/app-connectors/list-app-connections"},{"title":"List available app connectors","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/app/catalog","href":"/api-reference/app-connectors/list-available-app-connectors"},{"title":"List app connector tools","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/app/catalog/{app_key}/tools","href":"/api-reference/app-connectors/list-app-connector-tools"},{"title":"Show app connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/connections/app/{connection_id}","href":"/api-reference/app-connectors/show-app-connection"},{"title":"Delete app connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/connections/app/{connection_id}","href":"/api-reference/app-connectors/delete-app-connection"},{"title":"Update app connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/connections/app/{connection_id}","href":"/api-reference/app-connectors/update-app-connection"},{"title":"Disconnect app connection","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/connections/app/{connection_id}/disconnect","href":"/api-reference/app-connectors/disconnect-app-connection"}]},{"group":"Tables","pages":[{"title":"List tables","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables","href":"/api-reference/tables/list-tables"},{"title":"List table catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables/catalog","href":"/api-reference/tables/list-table-catalog"},{"title":"Show table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables/{table_id}","href":"/api-reference/tables/show-table"},{"title":"Delete table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/tables/{table_id}","href":"/api-reference/tables/delete-table"},{"title":"Fetch table data","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables/{table_id}/data","href":"/api-reference/tables/fetch-table-data"},{"title":"Show table catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables/{table_id}/catalog","href":"/api-reference/tables/show-table-catalog"},{"title":"Update table catalog","description":"Update a table's catalog metadata — description, owner, semantics.\nFields omitted are left unchanged.","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/tables/{table_id}/catalog","href":"/api-reference/tables/update-table-catalog"},{"title":"Upsert rows into a table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/tables/{table_id}/rows","href":"/api-reference/tables/upsert-rows-into-a-table"},{"title":"Append rows to a table","description":"Append one or more rows to a table. Append-only: existing rows are never modified or deleted. Each row is an object of column name to scalar value, validated and type-coerced against the table's schema. Every row in a batch must carry the same column names.\n\nThe target must be a promoted (ACTIVE) Summation data table — one backed by a physical row store. Draft or unpromoted tables, calculation tables, and imported tables (e.g. file/CSV imports) have no row store and are rejected with 409; a table appearing with a SUMMATION source in the table list is not sufficient on its own.\n\nEach row must include a value for the table's primary key column(s) — primary keys are caller-supplied, not auto-generated. A row missing its primary key is rejected with 400.\n\nReturns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. Requires the tables:append scope.","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/tables/{table_id}/rows","href":"/api-reference/tables/append-rows-to-a-table"},{"title":"Create asset upload URL","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/assets/upload-urls","href":"/api-reference/tables/create-asset-upload-url"},{"title":"Preview import asset","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/assets/{asset_id}/previews","href":"/api-reference/tables/preview-import-asset"},{"title":"Create table import","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/table-imports","href":"/api-reference/tables/create-table-import"},{"title":"Show table import","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/table-imports/{import_id}","href":"/api-reference/tables/show-table-import"},{"title":"Submit a NetSuite REST source page","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/data-syncs/{sync_id}/pages","href":"/api-reference/tables/submit-a-netsuite-rest-source-page"},{"title":"Get the committed source checkpoint","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/data-syncs/{sync_id}/checkpoint","href":"/api-reference/tables/get-the-committed-source-checkpoint"},{"title":"Get a source page","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/data-syncs/{sync_id}/pages/{page_id}","href":"/api-reference/tables/get-a-source-page"},{"title":"Create a provider snapshot upload","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/data-syncs/{sync_id}/snapshots","href":"/api-reference/tables/create-a-provider-snapshot-upload"},{"title":"Stage one provider snapshot page","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/data-syncs/{sync_id}/snapshots/{snapshot_id}/pages","href":"/api-reference/tables/stage-one-provider-snapshot-page"},{"title":"Commit a provider snapshot","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/data-syncs/{sync_id}/snapshots/{snapshot_id}/complete","href":"/api-reference/tables/commit-a-provider-snapshot"},{"title":"Get a provider snapshot","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/data-syncs/{sync_id}/snapshots/{snapshot_id}","href":"/api-reference/tables/get-a-provider-snapshot"},{"title":"Create an ingestion batch","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/tables/{table_id}/ingestion-batches","href":"/api-reference/tables/create-an-ingestion-batch"},{"title":"Create a batch part upload URL","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/tables/{table_id}/ingestion-batches/{batch_id}/parts/{part_number}/upload-url","href":"/api-reference/tables/create-a-batch-part-upload-url"},{"title":"Commit an ingestion batch","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/tables/{table_id}/ingestion-batches/{batch_id}/commit","href":"/api-reference/tables/commit-an-ingestion-batch"},{"title":"Get an ingestion batch","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/tables/{table_id}/ingestion-batches/{batch_id}","href":"/api-reference/tables/get-an-ingestion-batch"},{"title":"Abort an ingestion batch","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/tables/{table_id}/ingestion-batches/{batch_id}","href":"/api-reference/tables/abort-an-ingestion-batch"}]},{"group":"Views","pages":[{"title":"List views","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/views","href":"/api-reference/views/list-views"},{"title":"List view catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/views/catalog","href":"/api-reference/views/list-view-catalog"},{"title":"Show view","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/views/{view_id}","href":"/api-reference/views/show-view"},{"title":"Delete view","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/views/{view_id}","href":"/api-reference/views/delete-view"},{"title":"Fetch view data","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/views/{view_id}/data","href":"/api-reference/views/fetch-view-data"},{"title":"Show view catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/views/{view_id}/catalog","href":"/api-reference/views/show-view-catalog"},{"title":"Update view catalog","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/views/{view_id}/catalog","href":"/api-reference/views/update-view-catalog"}]},{"group":"Query Executions","pages":[{"title":"Execute read-only SQL query","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/query-executions","href":"/api-reference/query-executions/execute-read-only-sql-query"}]},{"group":"Grid","pages":[{"title":"Show grid status","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/status","href":"/api-reference/grid/show-grid-status"},{"title":"Show grid diff","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/diff","href":"/api-reference/grid/show-grid-diff"},{"title":"Validate grid","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/validation","href":"/api-reference/grid/validate-grid"},{"title":"Synchronize materialized table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/grid/tables/{table_id}/synchronizations","href":"/api-reference/grid/synchronize-materialized-table"},{"title":"Create grid table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/grid/tables","href":"/api-reference/grid/create-grid-table"},{"title":"Start async table materialization or refresh","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/grid/tables/{table_id}/materializations","href":"/api-reference/grid/start-async-table-materialization-or-refresh"},{"title":"Get table materialization status","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/tables/{table_id}/materializations/{run_id}","href":"/api-reference/grid/get-table-materialization-status"},{"title":"Materialize calculation table","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/grid/tables/{table_id}/materialize","href":"/api-reference/grid/materialize-calculation-table"},{"title":"Update calculation table query","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json patch /v1/grid/tables/{table_id}","href":"/api-reference/grid/update-calculation-table-query"},{"title":"List table changes","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/tables/{table_id}/changes","href":"/api-reference/grid/list-table-changes"},{"title":"Get table change","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/tables/{table_id}/changes/{change_id}","href":"/api-reference/grid/get-table-change"},{"title":"Roll back failed table change","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/grid/tables/{table_id}/changes/{change_id}/rollback","href":"/api-reference/grid/roll-back-failed-table-change"},{"title":"Show table lineage","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/grid/tables/{table_id}/lineage","href":"/api-reference/grid/show-table-lineage"}]},{"group":"Schedules","pages":[{"title":"List schedules","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/schedules","href":"/api-reference/schedules/list-schedules"},{"title":"Create schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/schedules","href":"/api-reference/schedules/create-schedule"},{"title":"Show schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/schedules/{schedule_id}","href":"/api-reference/schedules/show-schedule"},{"title":"Update schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/schedules/{schedule_id}","href":"/api-reference/schedules/update-schedule"},{"title":"Delete schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/schedules/{schedule_id}","href":"/api-reference/schedules/delete-schedule"},{"title":"Pause schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/schedules/{schedule_id}/pause","href":"/api-reference/schedules/pause-schedule"},{"title":"Resume schedule","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/schedules/{schedule_id}/resume","href":"/api-reference/schedules/resume-schedule"},{"title":"List schedule runs","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/schedules/{schedule_id}/runs","href":"/api-reference/schedules/list-schedule-runs"},{"title":"Run schedule now","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/schedules/{schedule_id}/runs","href":"/api-reference/schedules/run-schedule-now"}]},{"group":"SumApps","pages":[{"title":"List the tenant's deployed SumApps","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/sum-apps","href":"/api-reference/sumapps/list-the-tenants-deployed-sumapps"},{"title":"Register a deployed SumApp","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/sum-apps","href":"/api-reference/sumapps/register-a-deployed-sumapp"},{"title":"Deregister a SumApp","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/sum-apps/{slug}","href":"/api-reference/sumapps/deregister-a-sumapp"}]},{"group":"Verification Tests","pages":[{"title":"List custom verification tests","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/verification-tests","href":"/api-reference/verification-tests/list-custom-verification-tests"},{"title":"Create custom verification tests","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/verification-tests","href":"/api-reference/verification-tests/create-custom-verification-tests"},{"title":"List verification-test overlays","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/verification-tests/attachments","href":"/api-reference/verification-tests/list-verification-test-overlays"},{"title":"Create verification-test overlay","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/verification-tests/attachments","href":"/api-reference/verification-tests/create-verification-test-overlay"},{"title":"Detach verification-test overlay","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json delete /v1/verification-tests/attachments/{attachment_id}","href":"/api-reference/verification-tests/detach-verification-test-overlay"},{"title":"Preview effective verification tests","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/verification-tests/effective","href":"/api-reference/verification-tests/preview-effective-verification-tests"}]},{"group":"Workflows","pages":[{"title":"List workflows","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows","href":"/api-reference/workflows/list-workflows"},{"title":"Create workflow","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/workflows","href":"/api-reference/workflows/create-workflow"},{"title":"List workflow node types","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows/node-types","href":"/api-reference/workflows/list-workflow-node-types"},{"title":"Show workflow","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows/{workflow_id}","href":"/api-reference/workflows/show-workflow"},{"title":"Update workflow","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json put /v1/workflows/{workflow_id}","href":"/api-reference/workflows/update-workflow"},{"title":"Activate workflow","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/workflows/{workflow_id}/activate","href":"/api-reference/workflows/activate-workflow"},{"title":"List workflow versions","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows/{workflow_id}/versions","href":"/api-reference/workflows/list-workflow-versions"},{"title":"List workflow runs","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows/{workflow_id}/runs","href":"/api-reference/workflows/list-workflow-runs"},{"title":"Run workflow now","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json post /v1/workflows/{workflow_id}/runs","href":"/api-reference/workflows/run-workflow-now"},{"title":"Show workflow run","deprecated":null,"version":null,"openapi":"https://api.summation.com/openapi.json get /v1/workflows/{workflow_id}/runs/{run_id}","href":"/api-reference/workflows/show-workflow-run"}]}]}]}]},"basePath":"","title":"Upsert rows into a table - Summation","deploymentId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","buildId":"dpl_FZMKUpaaKiVETbfqhoUe4sPFDTmY","dynamics":["c2aa737661","2b790eda92","b0f84f53ff","a9bb46feb3"],"chunks":["OpenApiReferenceProvider-B6WFFOBL.js","utils-BN5um1KA.js","cloneDeep-C3md22mN.js","_Uint8Array-DLlL8L26.js","isObject-FP1Yky1u.js","utils-BSmbkXJR.js","addUniqueKeysToSchema-2tqcVnUE.js","snippetPresets-CtWfvr2J.js","style-to-object-BY3JEAdk.js","v4-DIgz8zy6.js","conditional-requirements-CFM0id0Q.js","ApiExamples-DkKHBy30.js","isEqual-O3q7y6pq.js","usePlaygroundInputsStore-Brc5H9UJ.js","shallow-C4L4xvbs.js","getApiPlaygroundDisplay-2bxyq_aI.js","CodeSnippet-BJu8ddd5.js","CodeSnippets-dazWmoqB.js","Page-CnLhKuUV.js","getPastedJson-Chy3Qa1S.js","icon-CyO7h3jh.js","MethodPill-Dle0_91v.js","DuplicateIcon-CVvWAf4a.js","createIcon-Di07A27B.js","DynamicMarkdown-C4w9kavL.js","SectionHeading-XiBebVYC.js","axios-vUo_bRtp.js","Markdown-DTeL0SpS.js","dist-OCScizqf.js","lib-DuNMoZ05.js","lib-B8HbPgcC.js","katex-YMM-FMeD.js","html-void-elements-mCSPHezU.js","marked.esm-CZWythHk.js","AssistantPageLink-KcneGfMY.js"]}