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.
The 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.
Each 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.
Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. 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
rows
Rows · object[]
required
Rows to append, 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, and each must include the table's primary key column(s) — primary keys are caller-supplied, not auto-generated. Append-only — existing rows are never modified.
Required array length: 1 - 500 elements
Show child attributes
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":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"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/append-rows-to-a-table","slug":"/api-reference/tables/append-rows-to-a-table","pageMetadata":{"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","autogeneratedByOpenApi":true},"description":{"compiledSource":"\"use strict\";\nconst {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsxs(_Fragment, {\n children: [_jsx(_components.p, {\n children: \"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 }), \"\\n\", _jsx(_components.p, {\n children: \"The 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 }), \"\\n\", _jsx(_components.p, {\n children: \"Each 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 }), \"\\n\", _jsx(_components.p, {\n children: \"Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. Requires the tables:append scope.\"\n })]\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":"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","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":"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.","operationId":"append_table_rows","security":["30ef0b4f-977a-489f-ad88-5b1687824f34"],"parameters":["6346bbbd-8bfb-4a15-b954-920d4d805119"],"requestBody":"81d751e6-b373-4c1b-9bdc-fd519a3cd6bf","responses":{"200":"9d522124-32b0-4503-baeb-68cf97d1ff5b","207":"422f428f-616a-45b8-a3e7-c613fd696c94","400":"83e9077d-77e2-4a2b-9640-5b24e6d826f5","401":"6a21779e-e459-4ee1-bca0-910206772a1f","403":"9a49aa9b-a86c-48ab-904b-c500cef786a0","404":"71bd4b58-3c4b-4db5-9a89-df425b2f6a5a","409":"839b24a5-e6fe-433e-9379-24958d0e7ce9","422":"20bf4e7d-8fbb-471d-85a3-1b80fab6be23","429":"e924dd71-33b6-4363-bc34-c272c7b43f42","500":"fb680c19-60ed-4bef-b6ac-71bd5b11d247"},"method":"post","type":"path","servers":[],"path":"/v1/tables/{table_id}/rows","baseUrlOptions":[],"title":"Append rows to a table","codeSamples":[],"requiredOnlyExamples":false,"requestExampleType":"generated","responseExampleType":"generated"},"dependencies":{"parameters":{"6346bbbd-8bfb-4a15-b954-920d4d805119":{"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 append, 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, and each must include the table's primary key column(s) — primary keys are caller-supplied, not auto-generated. Append-only — existing rows are never modified.","isRequired":true,"uniqueKey":"rows","typeLabel":"Rows · object[]"}},"type":"object","required":["rows"],"title":"TableAppendRowsRequest","uniqueKey":"","typeLabel":"TableAppendRowsRequest · object"},"examples":{"Example":{"title":"Example","value":{"rows":[{}]}}},"exampleType":"generated"}},"exampleType":"generated"},"responses":{"9d522124-32b0-4503-baeb-68cf97d1ff5b":{"description":"Successful Response","content":{"application/json":{"schema":{}}},"exampleType":"generated"},"422f428f-616a-45b8-a3e7-c613fd696c94":{"description":"Some rows inserted; response includes errors for failed rows.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"83e9077d-77e2-4a2b-9640-5b24e6d826f5":{"description":"Invalid row content, e.g. a row missing its primary key column(s).","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"6a21779e-e459-4ee1-bca0-910206772a1f":{"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"},"9a49aa9b-a86c-48ab-904b-c500cef786a0":{"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"},"71bd4b58-3c4b-4db5-9a89-df425b2f6a5a":{"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"},"839b24a5-e6fe-433e-9379-24958d0e7ce9":{"description":"Table does not accept row appends: it is not a promoted (ACTIVE) Summation data table backed by a physical row store.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"20bf4e7d-8fbb-471d-85a3-1b80fab6be23":{"description":"No rows inserted; response includes row-level errors.","content":{"_mintlify/placeholder":{"schema":{"type":"object","description":""}}}},"e924dd71-33b6-4363-bc34-c272c7b43f42":{"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"},"fb680c19-60ed-4bef-b6ac-71bd5b11d247":{"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":{"30ef0b4f-977a-489f-ad88-5b1687824f34":{"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":"Append rows to a table - Summation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-28T20:05:20.999Z","originalFileLocation":"api-reference/tables/append-rows-to-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=\"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\u0026#x27;s schema. Every row in a batch must carry the same column names. The 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. Each row must include a value for the table\u0026#x27;s primary key column(s) — primary keys are caller-supplied, not auto-generated. A row missing its primary key is rejected with 400. Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. 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=\"Append rows to a table - Summation\">\u003cmeta data-mint-head property=\"og:description\" content=\"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\u0026#x27;s schema. Every row in a batch must carry the same column names. The 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. Each row must include a value for the table\u0026#x27;s primary key column(s) — primary keys are caller-supplied, not auto-generated. A row missing its primary key is rejected with 400. Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. 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/append-rows-to-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=Append+rows+to+a+table\u0026amp;description=Append+one+or+more+rows+to+a+table.+Append-only%3A+existing+rows+are+never+modified+or+deleted.+Each+row+is+an+object+of+column+name+to+scalar+value%2C+validated+an\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=ac0baeb121e1e61afacb01b7e71da315131b129723f36aefb878d583de2e172a\">\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=\"Append rows to a table - Summation\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"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\u0026#x27;s schema. Every row in a batch must carry the same column names. The 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. Each row must include a value for the table\u0026#x27;s primary key column(s) — primary keys are caller-supplied, not auto-generated. A row missing its primary key is rejected with 400. Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. 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=Append+rows+to+a+table\u0026amp;description=Append+one+or+more+rows+to+a+table.+Append-only%3A+existing+rows+are+never+modified+or+deleted.+Each+row+is+an+object+of+column+name+to+scalar+value%2C+validated+an\u0026amp;theme=1190c7185ed5fee9aa38321d\u0026amp;signature=ac0baeb121e1e61afacb01b7e71da315131b129723f36aefb878d583de2e172a\">\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/append-rows-to-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/append-rows-to-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/append-rows-to-a-table#webpage\",\"url\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table\",\"name\":\"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. The 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. Each 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. Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. Requires the tables:append scope.\",\"dateModified\":\"2026-10-28T20:05:20.999Z\",\"isPartOf\":{\"@id\":\"https://docs.summation.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.summation.com/api-reference/tables/append-rows-to-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\":\"Append rows to a table\",\"item\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table\"}]},{\"@type\":[\"TechArticle\",\"APIReference\"],\"@id\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table#apireference\",\"headline\":\"Append rows to a table\",\"name\":\"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. The 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. Each 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. Returns 200 when all rows insert, 207 when some rows fail (see errors), and 422 when no rows insert. Requires the tables:append scope.\",\"url\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table\",\"mainEntityOfPage\":{\"@id\":\"https://docs.summation.com/api-reference/tables/append-rows-to-a-table#webpage\"},\"dateModified\":\"2026-10-28T20:05:20.999Z\",\"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/append-rows-to-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","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","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"},{"title":"Append rows to a table","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","description":"Create a short-lived upload URL for a source file that will be imported into a table. Upload the file to the returned URL with HTTP PUT and the header Content-Type: text/csv — the URL's signature requires it, so a request without that exact header is rejected with a signature mismatch. Then preview or import the resulting asset.","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":"Append rows to 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"]}