Function formatters produce an output value without requiring an input attribute. You can use a function formatter on its own or as the start of a more complex expression, with additional formatters piped in after it.For example, [vault(local/MyItem)] resolves the vault item in the local vault on its own, but you can also chain formatters after it, as shown below:[vault(local/MyItem) | equals(bar)]
Returns the value of the vault item in the Global Settings Vault that matches the provided identifier. By default, if no matching vault item exists, an error is generated.
VaultId: The ID of the vault provider. Use local for the local vault or env for the Environment Variable provider. If vaultid is not specified, Sync will default to the local vault.
ItemName: The name of the vault item to retrieve.
ifnotexist: An optional default value to return when no vault item with the specified itemname exists. Supplying this parameter prevents an error from being generated.
Use caution when you reference encrypted vault items in scripting contexts to ensure that sensitive values are not included in logs.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"CData Sync Documentation","colors":{"primary":"#002660","light":"#FFE500","dark":"#002660"},"logo":{"light":"https://mintcdn.com/cdata-sync/QUMemwq13NTEtcu3/logo/light.svg?fit=max\u0026auto=format\u0026n=QUMemwq13NTEtcu3\u0026q=85\u0026s=43d1024396897d27671dc28b97b7b547","dark":"https://mintcdn.com/cdata-sync/QUMemwq13NTEtcu3/logo/dark.svg?fit=max\u0026auto=format\u0026n=QUMemwq13NTEtcu3\u0026q=85\u0026s=39f9b5fdae484196e48e4551c58a3bb4","href":"https://www.cdata.com/sync"},"favicon":"https://mintcdn.com/cdata-sync/PFw7qu4c9rVTYkCl/favicon.ico?fit=max\u0026auto=format\u0026n=PFw7qu4c9rVTYkCl\u0026q=85\u0026s=fb52ae951b5238a82240b61752f1187a","appearance":{"default":"system","strict":false},"background":{"color":{"light":"#F1EEE9","dark":"#15151C"}},"footer":{"socials":{"x":"https://x.com/cdatasoftware","youtube":"https://www.youtube.com/c/CDataSoftware","linkedin":"https://www.linkedin.com/company/cdatasoftware","facebook":"https://www.facebook.com/cdatasoftware","instagram":"https://www.instagram.com/cdatasoftware"}},"fonts":{"heading":{"family":"DM Sans","weight":700},"body":{"family":"DM Sans"}},"styling":{"eyebrows":"breadcrumbs","latex":true},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"navigation":{"languages":[{"language":"en","default":true,"navbar":{"primary":{"type":"button","label":" Contact Us","href":"https://www.cdata.com/company/contact.aspx"}},"href":"26.4/en/getting-started/getting-started"},{"language":"ja","navbar":{"primary":{"type":"button","label":"お問い合わせ","href":"https://jp.cdata.com/contact/"}},"href":"26.4/ja/getting-started/getting-started"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"cdata-sync","hasAudioNarration":false,"actualSubdomain":"cdata-sync","customDomains":["docs.sync.cdata.com"],"gitSource":{"type":"github","owner":"cdatasoftware","repo":"sync-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6ac305e396d5b8c1827cf5e9","collectionId":"a8b41b9e-df6d-4ea6-a14e-6492d866dded","schemaVersion":"v3","latestBuiltDeploymentHistoryId":"6ac305e396d5b8c1827cf5e9"},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6ae0c8626c1a15a18d9e55fd","clientVersion":"0.0.3971","searchFilterCounts":[{"language":"en","tag":"Sync User Guide","count":1119},{"language":"ja","tag":"Sync ユーザーガイド","count":1115},{"language":"en","tag":"Connections","count":879},{"language":"ja","tag":"接続","count":879},{"language":"en","tag":"Sources","count":742},{"language":"ja","tag":"データソース","count":742},{"language":"default","tag":"Sync REST API","count":390},{"language":"default","tag":"REST API","count":390},{"language":"default","tag":"API V2","count":284},{"language":"en","tag":"Destinations","count":128},{"language":"ja","tag":"同期先","count":128},{"language":"default","tag":"API V1","count":106},{"language":"en","tag":"Getting Started","count":92},{"language":"ja","tag":"はじめに","count":89},{"language":"default","tag":"Jobs","count":85},{"language":"default","tag":"Workspaces","count":66},{"language":"default","tag":"Transformations","count":57},{"language":"default","tag":"Pipelines","count":57},{"language":"default","tag":"Connections","count":55},{"language":"en","tag":"Release Notes","count":54},{"language":"ja","tag":"リリースノート","count":53},{"language":"en","tag":"Administration","count":49},{"language":"ja","tag":"管理","count":49},{"language":"en","tag":"Events","count":43},{"language":"ja","tag":"イベント","count":43},{"language":"default","tag":"Users","count":35},{"language":"en","tag":"JSON","count":33},{"language":"ja","tag":"JSON","count":33},{"language":"en","tag":"Jobs","count":30},{"language":"ja","tag":"ジョブ","count":30}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":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":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-v7-file-tree","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":"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":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","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":"per-site-search-delta","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":"editor-private-page-search","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":"editor-nav-generations","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":"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":"byok-sep-25","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":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","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":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":true},"customCss":[{"filePath":"docs.css","content":"/* latin-ext */\n@font-face {\n font-family: 'DM Mono';\n font-style: normal;\n font-weight: 400;\n font-display: swap;\n src: url(/_mintlify/assets/fonts/google/s/dmmono/v16/aFTU7PB1QTsUX8KYthSQBLyM.woff2) format('woff2');\n unicode-range: U+0100-02BA, U+02BD-02C5, U+02C7-02CC, U+02CE-02D7, U+02DD-02FF, U+0304, U+0308, U+0329, U+1D00-1DBF, U+1E00-1E9F, U+1EF2-1EFF, U+2020, U+20A0-20AB, U+20AD-20C4, U+2113, U+2C60-2C7F, U+A720-A7FF;\n}\n/* latin */\n@font-face {\n font-family: 'DM Mono';\n font-style: normal;\n font-weight: 400;\n font-display: swap;\n src: url(/_mintlify/assets/fonts/google/s/dmmono/v16/aFTU7PB1QTsUX8KYthqQBA.woff2) format('woff2');\n unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+0304, U+0308, U+0329, U+2000-206F, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;\n}\n/* latin-ext */\n@font-face {\n font-family: 'DM Mono';\n font-style: normal;\n font-weight: 500;\n font-display: swap;\n src: url(/_mintlify/assets/fonts/google/s/dmmono/v16/aFTR7PB1QTsUX8KYvumzEY2tbZX9.woff2) format('woff2');\n unicode-range: U+0100-02BA, U+02BD-02C5, U+02C7-02CC, U+02CE-02D7, U+02DD-02FF, U+0304, U+0308, U+0329, U+1D00-1DBF, U+1E00-1E9F, U+1EF2-1EFF, U+2020, U+20A0-20AB, U+20AD-20C4, U+2113, U+2C60-2C7F, U+A720-A7FF;\n}\n/* latin */\n@font-face {\n font-family: 'DM Mono';\n font-style: normal;\n font-weight: 500;\n font-display: swap;\n src: url(/_mintlify/assets/fonts/google/s/dmmono/v16/aFTR7PB1QTsUX8KYvumzEYOtbQ.woff2) format('woff2');\n unicode-range: U+0000-00FF, U+0131, U+0152-0153, U+02BB-02BC, U+02C6, U+02DA, U+02DC, U+0304, U+0308, U+0329, U+2000-206F, U+20AC, U+2122, U+2191, U+2193, U+2212, U+2215, U+FEFF, U+FFFD;\n}\n@font-face{font-family:'Grafier';src:local('Grafier'),url(https://www.cdata.com/ui/fonts/grafier/PPGrafier-Regular.woff2) format('woff2'),url(https://www.cdata.com/ui/fonts/grafier/PPGrafier-Regular.woff) format('woff');font-weight:400;font-style:normal;font-display:swap}:root{--brand-agility:#FFE500;--brand-resolve:#002660;--brand-depth:#15151C;--brand-clarity:#F1EEE9;--brand-balance:#B5B9BC;--brand-link:#0B59CE;--brand-link-hover:#1F5B8E;--system-error:#BE6634;--n0:#FFFFFF;--n1:#FFFDFA;--n2:#F1EEE9;--n3:#D9D6D2;--n9:#525252;--n11:#15151C;--surface-bg:var(--brand-clarity);--surface-sidebar:transparent;--surface-card:var(--n0);--surface-header:transparent;--text-primary:var(--n11);--text-secondary:var(--n9);--border:var(--n3);--radius:5px;--shadow:0 10px 35px rgba(50,50,93,.10), 0 3px 15px rgba(0,0,0,.07);--shadow-up:0 13px 35px rgba(50,50,93,.20), 0 3px 18px rgba(0,0,0,.08);--font-sans:'DM Sans', ui-sans-serif, system-ui, sans-serif;--font-mono:'DM Mono', 'Nimbus Mono PS', 'Courier New', monospace;--logo-h:23px;--logo-w:116px}html.dark{--surface-bg:#1a1a22;--surface-sidebar:var(--surface-bg);--surface-card:#1a1a22;--surface-header:var(--surface-bg);--text-primary:rgb(158, 159, 161);--text-secondary:var(--brand-balance);--border:#2e2e3a;--brand-link:#5b9cf6;--brand-link-hover:#93c5fd}html:not(.dark) body{background-color:var(--surface-bg)}html.dark body{background-color:var(--surface-bg)}html.dark #background-color{background-color:var(--surface-bg)!important}html:not(.dark) body .mint-bg-white{background:linear-gradient(135deg,#fffdfa 0,#f1eee9 100%)!important}html.dark body .mint-bg-white{background:linear-gradient(135deg,#1a1a22 0,#15151c 100%)!important}body,html{font-weight:400;color:var(--text-primary)}h1,h2,h3,h4,h5,h6{line-height:1.2;color:#000}body,h3,h4,h5,h6,html{font-family:var(--font-sans)}h3,h4,h5,h6{font-weight:700}#page-title,h1,h2{font-family:'Grafier',var(--font-sans);font-weight:400!important;letter-spacing:normal!important;font-feature-settings:\"ss01\",\"case\"}#page-title *,h1 *,h2 *{letter-spacing:inherit!important;font-weight:inherit!important}html.dark h1,html.dark h2,html.dark h3,html.dark h4,html.dark h5,html.dark h6{color:#fff}label,li,p,td,th{line-height:1.65}code,kbd,pre,samp{font-family:var(--font-mono)!important}a{color:var(--brand-link);text-decoration:none;transition:color .15s}a:hover{color:var(--brand-link-hover)}#header a,#navbar a{color:inherit}#sidebar-content a.nav-anchor{color:var(--text-secondary)}#navbar a.nav-anchor:hover,.nav-anchor:hover{color:var(--brand-resolve)!important}html.dark #navbar a.nav-anchor:hover,html.dark .nav-anchor:hover{color:var(--brand-link-hover)!important}.nav-anchor>div.rounded-md{background:var(--text-secondary)!important}.nav-anchor:hover>div.rounded-md{background:var(--brand-resolve)!important}html.dark .nav-anchor:hover>div.rounded-md{background:var(--brand-link)!important}#header{background-color:var(--surface-header)!important;border-bottom:1px solid var(--border)!important}html.dark #header,html.dark #navbar,html.dark header,html.dark nav{background-color:var(--surface-bg)!important;border-bottom:1px solid var(--border)!important}#navbar a,label,li,p,td,th{font-family:var(--font-sans)}#navbar a{font-weight:500;font-size:.9375rem}html:not(.dark) [class*=btn-primary],html:not(.dark) [class*=button-primary],html:not(.dark) a.btn,html:not(.dark) button:not([class*=ghost]):not([class*=icon]):not([aria-label]):not(#localization-select-trigger):not([class*=text-gray]):not([class*=text-white]):not(.chat-assistant-sheet button):not(.chat-assistant-floating-input button){background-color:var(--brand-depth)!important;color:#fff!important;border-color:var(--brand-depth)!important}html:not(.dark) #navbar button:not(#topbar-cta-button),html:not(.dark) #sidebar button,html:not(.dark) #table-of-contents button,html:not(.dark) .chat-assistant-floating-input button,html:not(.dark) .chat-assistant-sheet button{background-color:transparent!important;color:inherit!important;border-color:transparent!important;box-shadow:none!important}#topbar-cta-button{background-color:var(--brand-depth)!important;color:#fff!important;border:0!important;border-radius:var(--radius)!important;height:40px;padding:0 20px;font-family:var(--font-sans);font-weight:500;font-size:.9375rem;white-space:nowrap;transition:box-shadow .2s,transform .1s;cursor:pointer}#topbar-cta-button:hover{box-shadow:var(--shadow-up);transform:translateY(-1px);color:#fff!important}html.dark #topbar-cta-button{background-color:var(--brand-agility)!important}html.dark #topbar-cta-button,html.dark #topbar-cta-button:hover{color:var(--brand-depth)!important}html.dark #topbar-cta-button span,html.dark #topbar-cta-button svg{color:var(--brand-depth)!important;fill:var(--brand-depth)!important}#topbar-cta-button span[class*=bg-primary]{background-color:transparent!important;border-radius:inherit!important}img.nav-logo{height:var(--logo-h)!important;width:auto!important;max-width:var(--logo-w)!important;max-height:var(--logo-h)!important}@media (max-width:768px){:root{--logo-h:23px;--logo-w:116px}}#sidebar,html.dark #sidebar{background-color:var(--surface-sidebar)!important;border-right:1px solid var(--border)!important}#sidebar-content a,#sidebar-content button{font-family:var(--font-sans);font-weight:400;font-size:.9rem;color:var(--text-primary);border-radius:var(--radius);transition:background-color .12s,color .12s}#sidebar-content a:hover{background-color:var(--n2);color:var(--brand-resolve)}html.dark #sidebar-content a:hover{background-color:rgba(255,255,255,.06);color:#fff}#sidebar-content li[data-active]>a{color:var(--brand-resolve)!important;font-weight:600!important;background-color:#dedfe1!important;box-shadow:none!important}html.dark #sidebar-content li[data-active]>a{color:#fff!important;background-color:rgba(255,229,0,.12)!important;box-shadow:none!important}.sidebar-group-header{font-family:var(--font-sans);font-size:.7rem;font-weight:500;letter-spacing:.1em;text-transform:uppercase;color:var(--text-secondary)}.nav-tabs{border-bottom:1px solid var(--border)}.nav-tabs-item{font-family:var(--font-sans);font-weight:500;color:var(--text-secondary);transition:color .15s,border-color .15s}.nav-tabs-item[data-active]{color:var(--brand-resolve)!important;font-weight:700!important}html.dark .nav-tabs-item[data-active]{color:#fff!important}a.nav-tabs-item[data-active]>div.absolute.bottom-0{height:8px!important}html:not(.dark) a.nav-tabs-item[data-active]>div.absolute.bottom-0{background-color:var(--brand-resolve)!important}html.dark a.nav-tabs-item[data-active]>div.absolute.bottom-0{background-color:var(--brand-agility)!important}#content-area{background-color:var(--surface-bg);color:var(--text-primary)}#body-content,.mdx-content{font-family:var(--font-sans);color:var(--text-primary)}#page-title{font-size:1.875rem;color:#000;line-height:1.2}html.dark #page-title{color:#fff}:not(pre)>code{background-color:color-mix(in srgb,var(--brand-resolve) 8%,var(--surface-card));color:var(--brand-resolve);border:1px solid color-mix(in srgb,var(--brand-resolve) 18%,transparent);border-radius:3px;padding:.15em .4em;font-family:var(--font-mono)!important;font-size:.875em}html.dark :not(pre)>code{background-color:rgba(255,255,255,.08);color:#93c5fd;border-color:rgba(255,255,255,.12)}.code-block button,pre button{color:var(--brand-balance);border-radius:3px;transition:color .15s,background-color .15s}.code-block button:hover,pre button:hover{color:var(--brand-agility);background-color:rgba(255,229,0,.12)}.card,html.dark .card{background-color:var(--surface-card)}.card{border:1px solid var(--border);border-radius:var(--radius);box-shadow:var(--shadow);transition:box-shadow .2s}.card:hover{box-shadow:var(--shadow-up)}html.dark .card{border-color:var(--border)}.callout[data-type=info]{border-left:4px solid var(--brand-resolve);background-color:color-mix(in srgb,var(--brand-resolve) 6%,var(--surface-card))}.callout[data-type=warning]{border-left:4px solid var(--brand-agility);background-color:color-mix(in srgb,var(--brand-agility) 10%,var(--surface-card))}.callout[data-type=error]{border-left:4px solid var(--system-error);background-color:color-mix(in srgb,var(--system-error) 8%,var(--surface-card))}.callout[data-type=success],.callout[data-type=tip]{border-left:4px solid #27ae60;background-color:color-mix(in srgb,#27ae60 6%,var(--surface-card))}#table-of-contents{font-size:.85rem}.toc-item a{color:var(--text-secondary);transition:color .15s}.toc-item[data-active-deepest] a{color:var(--brand-resolve)!important;font-weight:600}html.dark .toc-item[data-active-deepest] a{color:var(--brand-agility)!important}#search-input,#table-of-contents{font-family:var(--font-sans)}#search-input:focus{outline:2px solid var(--brand-resolve);outline-offset:2px}html.dark #search-input:focus{outline-color:var(--brand-agility)}[cmdk-item][aria-selected=true],[cmdk-item][data-selected=true]{background-color:color-mix(in srgb,var(--brand-resolve) 8%,transparent)!important}html.dark [cmdk-item][aria-selected=true],html.dark [cmdk-item][data-selected=true]{background-color:rgba(255,229,0,.12)!important}#footer,table{font-family:var(--font-sans)}#footer{background-color:transparent!important;border-top:none!important}#footer a{color:var(--brand-balance);transition:color .15s}#footer a:hover{color:var(--text-primary)}#footer [class*=social]:hover,html.dark h1 a,html.dark h2 a,html.dark h3 a,html.dark h4 a{color:var(--brand-agility)}table{border-radius:var(--radius);overflow:hidden;width:100%}table thead tr th,th,thead th{background-color:var(--brand-resolve);color:#fff!important;font-weight:600;font-size:.875rem;padding:.6rem .75rem!important;vertical-align:middle!important}html.dark th{background-color:#1a2a4a}td{border-bottom:1px solid var(--border);padding:.55rem .75rem;font-size:.9rem}td:first-child{padding-left:.75rem!important}tr:last-child td{border-bottom:none}tr:nth-child(even) td{background-color:color-mix(in srgb,var(--brand-resolve) 3%,transparent)}html.dark tr:nth-child(even) td{background-color:rgba(255,255,255,.03)}h1 a,h2 a,h3 a,h4 a{color:var(--brand-resolve);opacity:0;transition:opacity .15s}h1:hover a,h2:hover a,h3:hover a,h4:hover a{opacity:1}hr{border:0;border-top:1px solid var(--border);margin:1.5rem 0}:focus-visible{outline:2px solid var(--brand-resolve);outline-offset:3px;border-radius:var(--radius)}html.dark :focus-visible{outline-color:var(--brand-agility)}::selection{background-color:color-mix(in srgb,var(--brand-agility) 45%,transparent);color:var(--brand-depth)}@media (max-width:768px){h1{font-size:1.625rem}h2{font-size:1.25rem}.code-block,pre{font-size:.8em}}html:not(.dark) .breadcrumb-item a{color:#002660!important;font-weight:600!important}html:not(.dark) .breadcrumb-item a:hover{color:#002660!important}html.dark .breadcrumb-item a{color:var(--brand-agility)!important;font-weight:600!important}.inline-icon{display:inline;height:1em;vertical-align:-.125em;margin:0}"}],"page":{"pagePath":"26.4/en/events/formatters/function-formatters","slug":"/26.4/en/events/formatters/function-formatters","pageMetadata":{"title":"Function Formatters","description":null,"href":"/26.4/en/events/formatters/function-formatters"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Heading,Warning}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Function formatters produce an output value without requiring an input attribute. You can use a function formatter on its own or as the start of a more complex expression, with additional formatters piped in after it.`}),`\n`,_jsxs(_components.p,{children:[`For example, `,_jsx(_components.code,{children:`[vault(local/MyItem)]`}),` resolves the vault item in the local vault on its own, but you can also chain formatters after it, as shown below:`]}),`\n`,_jsx(_components.p,{children:_jsx(_components.code,{children:`[vault(local/MyItem) | equals(bar)]`})}),`\n`,_jsx(Heading,{level:`2`,id:`vault-vaultid/itemname-ifnotexist`,children:`vault(VaultId/ItemName[, ifnotexist])`}),`\n`,_jsxs(_components.p,{children:[`Returns the value of the vault item in the `,_jsx(_components.a,{href:`/26.4/en/getting-started/administration/settings-page/global-settings-vault`,children:`Global Settings Vault`}),` that matches the provided identifier. By default, if no matching vault item exists, an error is generated.`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.em,{children:_jsx(_components.strong,{children:`VaultId`})}),`: The ID of the vault provider. Use `,_jsx(_components.code,{children:`local`}),` for the local vault or `,_jsx(_components.code,{children:`env`}),` for the Environment Variable provider. If vaultid is not specified, Sync will default to the local vault.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.em,{children:_jsx(_components.strong,{children:`ItemName`})}),`: The name of the vault item to retrieve.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`ifnotexist`}),`: An optional default value to return when no vault item with the specified `,_jsx(_components.code,{children:`itemname`}),` exists. Supplying this parameter prevents an error from being generated.`]}),`\n`]}),`\n`,_jsx(Warning,{children:`Use caution when you reference encrypted vault items in scripting contexts to ensure that sensitive values are not included in logs.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Function Formatters","description":null,"href":"/26.4/en/events/formatters/function-formatters"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"vault(VaultId/ItemName[, ifnotexist])","slug":"vault-vaultid/itemname-ifnotexist","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"cdata-sync","siteName":"CData Sync Documentation","title":"Function Formatters - CData Sync Documentation","navMaps":{"firstHrefInVersion":{"26.4":{"href":"/26.4/en/events/formatters/function-formatters","matchLevel":0},"26.3":{"href":"/26.3/en/getting-started/getting-started","matchLevel":4},"26.2":{"href":"/26.2/en/getting-started/getting-started","matchLevel":4}},"firstHrefInLanguage":{"en":{"href":"/26.4/en/events/formatters/function-formatters","matchLevel":0},"ja":{"href":"/26.4/ja/events/formatters/function-formatters","matchLevel":1}}},"lastModified":"2026-10-27T15:53:55.864Z","originalFileLocation":"26.4/en/events/formatters/function-formatters.mdx","locale":"en"},"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=\"system\"}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=\"application-name\" content=\"CData Sync Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_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/cdata-sync/NcixqO7S3DIEEQup/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Function Formatters - CData Sync Documentation\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"CData Sync Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://cdata-sync.mintlify.app/_mintlify/api/og/v2?division=Formatters\u0026amp;title=Function+Formatters\u0026amp;theme=67478e292fca207d08b5c74f\u0026amp;signature=cdd19415d5bb207203228cc2994352b1dedee840cdf2872e2c4b0ff266d2c822\">\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=\"Function Formatters - CData Sync Documentation\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://cdata-sync.mintlify.app/_mintlify/api/og/v2?division=Formatters\u0026amp;title=Function+Formatters\u0026amp;theme=67478e292fca207d08b5c74f\u0026amp;signature=cdd19415d5bb207203228cc2994352b1dedee840cdf2872e2c4b0ff266d2c822\">\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/cdata-sync/NcixqO7S3DIEEQup/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"CData Sync Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#002660\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/26.4/en/events/formatters/function-formatters.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://docs.sync.cdata.com/26.4/ja/events/formatters/function-formatters\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.sync.cdata.com/#organization\",\"name\":\"CData Sync Documentation\",\"url\":\"https://docs.sync.cdata.com\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/cdata-sync/QUMemwq13NTEtcu3/logo/light.svg?fit=max\u0026auto=format\u0026n=QUMemwq13NTEtcu3\u0026q=85\u0026s=43d1024396897d27671dc28b97b7b547\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.sync.cdata.com#website\",\"name\":\"CData Sync Documentation\",\"url\":\"https://docs.sync.cdata.com\",\"publisher\":{\"@id\":\"https://docs.sync.cdata.com/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters#webpage\",\"url\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\",\"name\":\"Function Formatters\",\"dateModified\":\"2026-10-27T15:53:55.864Z\",\"isPartOf\":{\"@id\":\"https://docs.sync.cdata.com#website\"},\"breadcrumb\":{\"@id\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Events\",\"item\":\"https://docs.sync.cdata.com/26.4/en/events/events\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formatters\",\"item\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/formatters\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Function Formatters\",\"item\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters#article\",\"headline\":\"Function Formatters\",\"name\":\"Function Formatters\",\"url\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters\",\"mainEntityOfPage\":{\"@id\":\"https://docs.sync.cdata.com/26.4/en/events/formatters/function-formatters#webpage\"},\"dateModified\":\"2026-10-27T15:53:55.864Z\",\"publisher\":{\"@id\":\"https://docs.sync.cdata.com/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.sync.cdata.com#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"CData Sync Documentation\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"CData Sync Documentation","nav":{"global":null,"languages":[{"language":"en","default":true,"navbar":{"primary":{"type":"button","label":" Contact Us","href":"https://www.cdata.com/company/contact.aspx"}},"versions":[{"version":"26.4","default":true,"tabs":[{"tab":"Sync User Guide","pages":[{"group":"Getting Started","pages":[{"title":"Getting Started","href":"/26.4/en/getting-started/getting-started"},{"group":"Installation and Configuration","pages":[{"title":"Installation and Configuration","href":"/26.4/en/getting-started/installation-and-configuration/installation-configuration"},{"title":"Starting the Server","href":"/26.4/en/getting-started/installation-and-configuration/starting-the-server"},{"title":"Configuring the Server","sidebarTitle":"Configuring the Server","href":"/26.4/en/getting-started/installation-and-configuration/configuring-the-server"},{"title":"Memory Management","href":"/26.4/en/getting-started/installation-and-configuration/memory-management"},{"title":"Defining a Custom Master Key","href":"/26.4/en/getting-started/installation-and-configuration/custom-master-key"},{"title":"Git Version Control","href":"/26.4/en/getting-started/installation-and-configuration/git-version-control"},{"title":"Deploying CData Sync to External Servlets","href":"/26.4/en/getting-started/installation-and-configuration/deploying-cdata-sync-to-external-servlets"},{"title":"AWS AMI Edition","href":"/26.4/en/getting-started/installation-and-configuration/aws-ami-edition"},{"title":"Azure Marketplace Edition","href":"/26.4/en/getting-started/installation-and-configuration/azure-marketplace-edition"},{"title":"Cluster Installation and Configuration","href":"/26.4/en/getting-started/installation-and-configuration/clustering"}]},{"group":"Administration","pages":[{"title":"Server Administration","href":"/26.4/en/getting-started/administration/server-administration"},{"title":"Dashboard Page","href":"/26.4/en/getting-started/administration/dashboard-page"},{"title":"Pipelines Page","href":"/26.4/en/getting-started/administration/pipelines-page"},{"title":"Jobs Page","href":"/26.4/en/getting-started/administration/jobs-page"},{"title":"Connections Page","href":"/26.4/en/getting-started/administration/connections-page"},{"title":"Transformations Page","href":"/26.4/en/getting-started/administration/transformations-page"},{"title":"Logs Page","href":"/26.4/en/getting-started/administration/logs-page"},{"group":"System Settings Page","pages":[{"title":"System Settings Page","href":"/26.4/en/getting-started/administration/settings-page/settings-page"},{"title":"Workspace Management","href":"/26.4/en/getting-started/administration/settings-page/workspace-management"},{"title":"Git Version Control Configuration","sidebarTitle":"Git Version Control for Workspaces","href":"/26.4/en/getting-started/administration/settings-page/git-version-control-configuration-for-workspaces"},{"group":"User Management","pages":[{"title":"User Management","href":"/26.4/en/getting-started/administration/settings-page/user-management/user-management"},{"title":"Roles","href":"/26.4/en/getting-started/administration/settings-page/user-management/roles"},{"title":"Two-Factor Authentication","href":"/26.4/en/getting-started/administration/settings-page/user-management/two-factor-authentication"},{"title":"Single Sign-On","href":"/26.4/en/getting-started/administration/settings-page/user-management/single-sign-on"}]},{"title":"Migration","href":"/26.4/en/getting-started/administration/settings-page/migration"},{"title":"Global Settings Vault","href":"/26.4/en/getting-started/administration/settings-page/global-settings-vault"}]},{"title":"System Monitoring","href":"/26.4/en/getting-started/administration/system-monitoring"}]},{"title":"Configuring Your First Replication Job","href":"/26.4/en/getting-started/configuring-jobs"},{"title":"Features","href":"/26.4/en/getting-started/features"},{"title":"Software Upgrades","href":"/26.4/en/getting-started/software-upgrades"},{"title":"Glossary","href":"/26.4/en/getting-started/glossary"}]},{"group":"Connections","pages":[{"title":"Connections","href":"/26.4/en/connections/connections"},{"group":"Sources","pages":[{"title":"Act! CRM","href":"/26.4/en/connections/sources/act-crm-source"},{"title":"ActiveCampaign","href":"/26.4/en/connections/sources/activecampaign-source"},{"title":"Act-On","href":"/26.4/en/connections/sources/act-on-source"},{"title":"Acumatica","href":"/26.4/en/connections/sources/acumatica-source"},{"title":"Adobe Analytics","href":"/26.4/en/connections/sources/adobe-analytics-source"},{"title":"Adobe Commerce","href":"/26.4/en/connections/sources/adobe-commerce-source"},{"title":"Adobe Target","href":"/26.4/en/connections/sources/adobe-target-source"},{"title":"ADP","href":"/26.4/en/connections/sources/adp-source"},{"title":"Airtable","href":"/26.4/en/connections/sources/airtable-source"},{"title":"AlloyDB","href":"/26.4/en/connections/sources/alloydb-source"},{"title":"Amazon Athena","href":"/26.4/en/connections/sources/amazon-athena-source"},{"title":"Amazon DynamoDB","href":"/26.4/en/connections/sources/amazon-dynamodb-source"},{"title":"Amazon Marketplace","href":"/26.4/en/connections/sources/amazon-marketplace-source"},{"title":"Amazon Redshift","href":"/26.4/en/connections/sources/amazon-redshift-source"},{"title":"Amazon S3","href":"/26.4/en/connections/sources/amazon-s3-source"},{"title":"Anaplan","href":"/26.4/en/connections/sources/anaplan-source"},{"title":"Apache CouchDB","href":"/26.4/en/connections/sources/apache-couchdb-source"},{"title":"Apache HBase","href":"/26.4/en/connections/sources/apache-hbase-source"},{"title":"Apache Hive","href":"/26.4/en/connections/sources/apache-hive-source"},{"title":"Apache Impala","href":"/26.4/en/connections/sources/apache-impala-source"},{"title":"Apache Kafka","href":"/26.4/en/connections/sources/apache-kafka-source"},{"title":"Apache Phoenix","href":"/26.4/en/connections/sources/apache-phoenix-source"},{"title":"Asana","href":"/26.4/en/connections/sources/asana-source"},{"title":"au PAY Market","href":"/26.4/en/connections/sources/au-pay-market-source"},{"title":"Authorize.Net","href":"/26.4/en/connections/sources/authorize-net-source"},{"title":"Avalara","href":"/26.4/en/connections/sources/avalara-source"},{"group":"Avro","pages":[{"title":"Avro","href":"/26.4/en/connections/sources/avro-source"},{"title":"Connecting to Azure Blob Storage","sidebarTitle":"Azure Blob Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-blob-storage-connection-type"},{"title":"Connecting to Azure Files","sidebarTitle":"Azure Files","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-files-connection-type"},{"title":"Connecting to Google Cloud Storage","sidebarTitle":"Google Cloud Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/google-cloud-storage-connection-type"},{"title":"Connecting to Google Drive","sidebarTitle":"Google Drive","href":"/26.4/en/connections/sources/storage-source-connection-types/google-drive-connection-type"},{"title":"Connecting to HDFS","sidebarTitle":"HDFS","href":"/26.4/en/connections/sources/storage-source-connection-types/hdfs-connection-type"},{"title":"Connecting to HTTP or HTTPS","sidebarTitle":"HTTP or HTTPS","href":"/26.4/en/connections/sources/storage-source-connection-types/http-connection-type"},{"title":"Connecting to IBM Object Storage","sidebarTitle":"IBM Object Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/ibm-object-storage-connection-type"},{"title":"Connecting to OneDrive","sidebarTitle":"OneDrive","href":"/26.4/en/connections/sources/storage-source-connection-types/onedrive-connection-type"},{"title":"Connecting to SFTP","sidebarTitle":"SFTP","href":"/26.4/en/connections/sources/storage-source-connection-types/sftp-connection-type"},{"title":"Connecting to SharePoint Online","sidebarTitle":"SharePoint Online","href":"/26.4/en/connections/sources/storage-source-connection-types/sharepoint-online-connection-type"}]},{"title":"Azure Active Directory","href":"/26.4/en/connections/sources/azure-active-directory-source"},{"title":"Azure Blob Storage","href":"/26.4/en/connections/sources/azure-blob-storage-source"},{"title":"Azure Cosmos DB","href":"/26.4/en/connections/sources/azure-cosmos-db-source"},{"title":"Azure Data Catalog","href":"/26.4/en/connections/sources/azure-data-catalog-source"},{"title":"Azure Data Lake Storage","href":"/26.4/en/connections/sources/azure-data-lake-storage-source"},{"title":"Azure DevOps","href":"/26.4/en/connections/sources/azure-devops-source"},{"title":"Azure Synapse","href":"/26.4/en/connections/sources/azure-synapse-source"},{"title":"Backlog","href":"/26.4/en/connections/sources/backlog-source"},{"title":"Basecamp","href":"/26.4/en/connections/sources/basecamp-source"},{"title":"BigCommerce","href":"/26.4/en/connections/sources/bigcommerce-source"},{"title":"Blackbaud Financial Edge NXT","href":"/26.4/en/connections/sources/blackbaud-financial-edge-nxt-source"},{"title":"Blackbaud Raiser's Edge NXT","href":"/26.4/en/connections/sources/blackbaud-raisers-edge-nxt-source"},{"title":"Box","href":"/26.4/en/connections/sources/box-source"},{"title":"Bugzilla","href":"/26.4/en/connections/sources/bugzilla-source"},{"title":"Bullhorn CRM","href":"/26.4/en/connections/sources/bullhorn-crm-source"},{"title":"Business b-ridge","href":"/26.4/en/connections/sources/business-b-ridge-source"},{"title":"Cassandra","href":"/26.4/en/connections/sources/cassandra-source"},{"title":"CData Connect","href":"/26.4/en/connections/sources/connect-source"},{"title":"Certinia","href":"/26.4/en/connections/sources/certinia-source"},{"title":"Claude Compliance","href":"/26.4/en/connections/sources/claude-compliance-source"},{"title":"Cloudant","href":"/26.4/en/connections/sources/cloudant-source"},{"title":"CloudSign","href":"/26.4/en/connections/sources/cloudsign-source"},{"title":"CockroachDB","href":"/26.4/en/connections/sources/cockroachdb-source"},{"title":"Confluence","href":"/26.4/en/connections/sources/confluence-source"},{"title":"Couchbase","href":"/26.4/en/connections/sources/couchbase-source"},{"group":"CSV","pages":[{"title":"CSV","href":"/26.4/en/connections/sources/csv-source"},{"title":"Connecting to Azure Blob Storage","sidebarTitle":"Azure Blob Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-blob-storage-connection-type"},{"title":"Connecting to Azure Files","sidebarTitle":"Azure Files","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-files-connection-type"},{"title":"Connecting to Google Cloud Storage","sidebarTitle":"Google Cloud Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/google-cloud-storage-connection-type"},{"title":"Connecting to Google Drive","sidebarTitle":"Google Drive","href":"/26.4/en/connections/sources/storage-source-connection-types/google-drive-connection-type"},{"title":"Connecting to HDFS","sidebarTitle":"HDFS","href":"/26.4/en/connections/sources/storage-source-connection-types/hdfs-connection-type"},{"title":"Connecting to HTTP or HTTPS","sidebarTitle":"HTTP or HTTPS","href":"/26.4/en/connections/sources/storage-source-connection-types/http-connection-type"},{"title":"Connecting to IBM Object Storage","sidebarTitle":"IBM Object Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/ibm-object-storage-connection-type"},{"title":"Connecting to OneDrive","sidebarTitle":"OneDrive","href":"/26.4/en/connections/sources/storage-source-connection-types/onedrive-connection-type"},{"title":"Connecting to SFTP","sidebarTitle":"SFTP","href":"/26.4/en/connections/sources/storage-source-connection-types/sftp-connection-type"},{"title":"Connecting to SharePoint Online","sidebarTitle":"SharePoint Online","href":"/26.4/en/connections/sources/storage-source-connection-types/sharepoint-online-connection-type"}]},{"title":"Cvent","href":"/26.4/en/connections/sources/cvent-source"},{"title":"Databricks","href":"/26.4/en/connections/sources/databricks-source"},{"title":"DB2 (Native)","href":"/26.4/en/connections/sources/db2-(native)-source"},{"title":"DB2 for i (Native)","href":"/26.4/en/connections/sources/db2-i-(native)-source"},{"title":"DocuSign","href":"/26.4/en/connections/sources/docusign-source"},{"title":"Domino","href":"/26.4/en/connections/sources/domino-source"},{"title":"eBay","href":"/26.4/en/connections/sources/ebay-source"},{"title":"eBay Analytics","href":"/26.4/en/connections/sources/ebay-analytics-source"},{"title":"Elasticsearch","href":"/26.4/en/connections/sources/elasticsearch-source"},{"title":"Email","href":"/26.4/en/connections/sources/email-source"},{"title":"EnterpriseDB","href":"/26.4/en/connections/sources/enterprisedb-source"},{"title":"Epicor Kinetic","href":"/26.4/en/connections/sources/epicor-kinetic-source"},{"title":"e-Sales Manager Remix","href":"/26.4/en/connections/sources/esales-manager-remix-source"},{"title":"Exact Online","href":"/26.4/en/connections/sources/exact-online-source"},{"title":"Facebook","href":"/26.4/en/connections/sources/facebook-source"},{"title":"Facebook Ads","href":"/26.4/en/connections/sources/facebook-ads-source"},{"title":"FHIR","href":"/26.4/en/connections/sources/fhir-source"},{"title":"Freshdesk","href":"/26.4/en/connections/sources/freshdesk-source"},{"title":"Garoon","href":"/26.4/en/connections/sources/garoon-source"},{"title":"GitHub","href":"/26.4/en/connections/sources/github-source"},{"title":"GMO MakeShop","href":"/26.4/en/connections/sources/gmo-makeshop-source"},{"title":"Google Ad Manager","href":"/26.4/en/connections/sources/google-ad-manager-source"},{"title":"Google Ads","href":"/26.4/en/connections/sources/google-ads-source"},{"title":"Google Analytics","href":"/26.4/en/connections/sources/google-analytics-source"},{"title":"Google BigQuery","href":"/26.4/en/connections/sources/google-bigquery-source"},{"title":"Google Calendar","href":"/26.4/en/connections/sources/google-calendar-source"},{"title":"Google Campaign Manager 360","href":"/26.4/en/connections/sources/google-campaign-manager-source"},{"title":"Google Cloud Storage","href":"/26.4/en/connections/sources/google-cloud-storage-source"},{"title":"Google Contacts","href":"/26.4/en/connections/sources/google-contacts-source"},{"title":"Google Directory","href":"/26.4/en/connections/sources/google-directory-source"},{"title":"Google Search","href":"/26.4/en/connections/sources/google-search-source"},{"title":"Google Sheets","href":"/26.4/en/connections/sources/google-sheets-source"},{"title":"Google Spanner","href":"/26.4/en/connections/sources/google-spanner-source"},{"title":"GraphQL","href":"/26.4/en/connections/sources/graphql-source"},{"title":"Greenplum","href":"/26.4/en/connections/sources/greenplum-source"},{"title":"HDFS","href":"/26.4/en/connections/sources/hdfs-source"},{"title":"Highrise","href":"/26.4/en/connections/sources/highrise-source"},{"title":"HubSpot","href":"/26.4/en/connections/sources/hubspot-source"},{"title":"IBM Cloud Data Engine","href":"/26.4/en/connections/sources/ibm-cloud-data-engine-source"},{"title":"IBM Cloud Object Storage","href":"/26.4/en/connections/sources/ibm-cloud-object-storage-source"},{"title":"Informix","href":"/26.4/en/connections/sources/informix-source"},{"title":"Informix (Native)","href":"/26.4/en/connections/sources/informix-(native)-source"},{"title":"Instagram","href":"/26.4/en/connections/sources/instagram-source"},{"title":"JD Edwards","href":"/26.4/en/connections/sources/jd-edwards-source"},{"title":"Jira","href":"/26.4/en/connections/sources/jira-source"},{"title":"Jira Assets","href":"/26.4/en/connections/sources/jira-assets-source"},{"title":"Jira Service Management","href":"/26.4/en/connections/sources/jira-service-management-source"},{"group":"JSON","pages":[{"title":"JSON","href":"/26.4/en/connections/sources/json-source"},{"title":"Connecting to Azure Blob Storage","sidebarTitle":"Azure Blob Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-blob-storage-connection-type"},{"title":"Connecting to Azure Files","sidebarTitle":"Azure Files","href":"/26.4/en/connections/sources/storage-source-connection-types/azure-files-connection-type"},{"title":"Connecting to Google Cloud Storage","sidebarTitle":"Google Cloud Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/google-cloud-storage-connection-type"},{"title":"Connecting to Google Drive","sidebarTitle":"Google Drive","href":"/26.4/en/connections/sources/storage-source-connection-types/google-drive-connection-type"},{"title":"Connecting to HDFS","sidebarTitle":"HDFS","href":"/26.4/en/connections/sources/storage-source-connection-types/hdfs-connection-type"},{"title":"Connecting to HTTP or HTTPS","sidebarTitle":"HTTP or HTTPS","href":"/26.4/en/connections/sources/storage-source-connection-types/http-connection-type"},{"title":"Connecting to IBM Object Storage","sidebarTitle":"IBM Object Storage","href":"/26.4/en/connections/sources/storage-source-connection-types/ibm-object-storage-connection-type"},{"title":"Connecting to OneDrive","sidebarTitle":"OneDrive","href":"/26.4/en/connections/sources/storage-source-connection-types/onedrive-connection-type"},{"title":"Connecting to SFTP","sidebarTitle":"SFTP","href":"/26.4/en/connections/sources/storage-source-connection-types/sftp-connection-type"},{"title":"Connecting to SharePoint Online","sidebarTitle":"SharePoint Online","href":"/26.4/en/connections/sources/storage-source-connection-types/sharepoint-online-connection-type"}]},{"title":"Kingdee K/3 WISE","href":"/26.4/en/connections/sources/kingdee-k3-wise-source"},{"title":"Kintone","href":"/26.4/en/connections/sources/kintone-source"},{"title":"LDAP","href":"/26.4/en/connections/sources/ldap-source"},{"title":"Linear","href":"/26.4/en/connections/sources/linear-source"},{"title":"LinkedIn","href":"/26.4/en/connections/sources/linkedin-source"},{"title":"LinkedIn Marketing Solutions","href":"/26.4/en/connections/sources/linkedin-marketing-solutions-source"},{"title":"Local File Storage","href":"/26.4/en/connections/sources/local-file-storage-source"},{"title":"Mailchimp","href":"/26.4/en/connections/sources/mailchimp-source"},{"title":"MariaDB","href":"/26.4/en/connections/sources/mariadb-source"},{"title":"Marketo","href":"/26.4/en/connections/sources/marketo-source"},{"title":"MarkLogic","href":"/26.4/en/connections/sources/marklogic-source"},{"title":"Microsoft Access","href":"/26.4/en/connections/sources/microsoft-access-source"},{"title":"Microsoft Active Directory","href":"/26.4/en/connections/sources/microsoft-active-directory-source"},{"title":"Microsoft Ads","href":"/26.4/en/connections/sources/microsoft-ads-source"},{"title":"Microsoft Dataverse","href":"/26.4/en/connections/sources/microsoft-dataverse-source"},{"title":"Microsoft Dynamics 365","href":"/26.4/en/connections/sources/microsoft-dynamics-365-source"},{"title":"Microsoft Dynamics 365 Business Central","href":"/26.4/en/connections/sources/microsoft-dynamics365-business-central-source"},{"title":"Microsoft Dynamics CRM","href":"/26.4/en/connections/sources/microsoft-dynamics-crm-source"},{"title":"Microsoft Dynamics NAV","href":"/26.4/en/connections/sources/microsoft-dynamics-nav-source"},{"title":"Microsoft Excel","href":"/26.4/en/connections/sources/microsoft-excel-source"},{"title":"Microsoft Excel Online","href":"/26.4/en/connections/sources/microsoft-excel-online-source"},{"title":"Microsoft Exchange","href":"/26.4/en/connections/sources/microsoft-exchange-source"},{"title":"Microsoft Office 365","href":"/26.4/en/connections/sources/microsoft-office-365-source"},{"title":"Microsoft OneLake","href":"/26.4/en/connections/sources/microsoft-onelake-source"},{"title":"Microsoft OneNote","href":"/26.4/en/connections/sources/microsoft-onenote-source"},{"title":"Microsoft Planner","href":"/26.4/en/connections/sources/microsoft-planner-source"},{"title":"Microsoft Power BI XMLA","href":"/26.4/en/connections/sources/microsoft-power-bi-xmla-source"},{"title":"Microsoft Project","href":"/26.4/en/connections/sources/microsoft-project-source"},{"title":"Microsoft SharePoint","href":"/26.4/en/connections/sources/microsoft-sharepoint-source"},{"title":"Microsoft SharePoint Excel","href":"/26.4/en/connections/sources/microsoft-sharepoint-excel-source"},{"title":"Microsoft Teams","href":"/26.4/en/connections/sources/microsoft-teams-source"},{"title":"Monday","href":"/26.4/en/connections/sources/monday-source"},{"title":"MongoDB","href":"/26.4/en/connections/sources/mongodb-source"},{"title":"MYOB","href":"/26.4/en/connections/sources/myob-source"},{"title":"MySQL","href":"/26.4/en/connections/sources/mysql-source"},{"title":"Neo4j","href":"/26.4/en/connections/sources/neo4j-source"},{"title":"NetSuite","href":"/26.4/en/connections/sources/netsuite-source"},{"title":"NetSuite SuiteAnalytics","href":"/26.4/en/connections/sources/netsuite-suiteanalytics-source"},{"title":"OData","href":"/26.4/en/connections/sources/odata-source"},{"title":"Odoo","href":"/26.4/en/connections/sources/odoo-source"},{"title":"Oracle","href":"/26.4/en/connections/sources/oracle-source"},{"title":"Oracle (Native)","href":"/26.4/en/connections/sources/oracle-(native)-source"},{"title":"Oracle Eloqua","href":"/26.4/en/connections/sources/oracle-eloqua-source"},{"title":"Oracle Fusion Cloud HCM","href":"/26.4/en/connections/sources/oracle-fusion-cloud-hcm-source"},{"title":"Oracle Fusion Cloud SCM","href":"/26.4/en/connections/sources/oracle-fusion-cloud-scm-source"},{"title":"Oracle Fusion Financials Cloud","href":"/26.4/en/connections/sources/oracle-fusion-cloud-financials-source"},{"title":"Oracle Sales","href":"/26.4/en/connections/sources/oracle-sales-source"},{"title":"Oracle Service Cloud","href":"/26.4/en/connections/sources/oracle-service-cloud-source"},{"title":"Outreach","href":"/26.4/en/connections/sources/outreach-source"},{"title":"Parquet","href":"/26.4/en/connections/sources/parquet-source"},{"title":"Paylocity","href":"/26.4/en/connections/sources/paylocity-source"},{"title":"PayPal","href":"/26.4/en/connections/sources/paypal-source"},{"title":"PCA Accounting","href":"/26.4/en/connections/sources/pca-accounting-source"},{"title":"PCA Sales","href":"/26.4/en/connections/sources/pca-sales-source"},{"title":"Pinterest","href":"/26.4/en/connections/sources/pinterest-source"},{"title":"Pipedrive","href":"/26.4/en/connections/sources/pipedrive-source"},{"title":"Ponparemall","href":"/26.4/en/connections/sources/ponparemall-source"},{"title":"PostgreSQL","href":"/26.4/en/connections/sources/postgresql-source"},{"title":"PostgreSQL (Native)","href":"/26.4/en/connections/sources/postgresql-(native)-source"},{"title":"Presto","href":"/26.4/en/connections/sources/presto-source"},{"title":"Quickbase","href":"/26.4/en/connections/sources/quickbase-source"},{"title":"QuickBooks","href":"/26.4/en/connections/sources/quickbooks-source"},{"title":"QuickBooks Online","href":"/26.4/en/connections/sources/quickbooks-online-source"},{"title":"QuickBooks Time","href":"/26.4/en/connections/sources/quickbooks-time-source"},{"title":"Reckon","href":"/26.4/en/connections/sources/reckon-source"},{"title":"Reckon Accounts Hosted","href":"/26.4/en/connections/sources/reckon-accounts-hosted-source"},{"title":"Redis","href":"/26.4/en/connections/sources/redis-source"},{"title":"REST","href":"/26.4/en/connections/sources/rest-source"},{"title":"RSS","href":"/26.4/en/connections/sources/rss-source"},{"title":"Sage 200","href":"/26.4/en/connections/sources/sage-200-source"},{"title":"Sage 300","href":"/26.4/en/connections/sources/sage-300-source"},{"title":"Sage 50 UK","href":"/26.4/en/connections/sources/sage-50-uk-source"},{"title":"Sage Business Cloud Accounting","href":"/26.4/en/connections/sources/sage-business-cloud-accounting-source"},{"title":"Sage Intacct","href":"/26.4/en/connections/sources/sage-intacct-source"},{"title":"Sage X3 Cloud","href":"/26.4/en/connections/sources/sage-x3-cloud-source"},{"title":"Salesforce","href":"/26.4/en/connections/sources/salesforce-source"},{"title":"Salesforce Data 360","href":"/26.4/en/connections/sources/salesforce-data-360-source"},{"title":"Salesforce Marketing Cloud","href":"/26.4/en/connections/sources/salesforce-marketing-cloud-source"},{"title":"Salesforce Marketing Cloud Account Engagement","href":"/26.4/en/connections/sources/salesforce-marketing-cloud-account-engagement-source"},{"title":"Salesloft","href":"/26.4/en/connections/sources/salesloft-source"},{"title":"Sansan","href":"/26.4/en/connections/sources/sansan-source"},{"title":"SAP Ariba Procurement","href":"/26.4/en/connections/sources/sap-ariba-procurement-source"},{"title":"SAP Ariba Source","href":"/26.4/en/connections/sources/sap-ariba-source-source"},{"title":"SAP Business One","href":"/26.4/en/connections/sources/sap-business-one-source"},{"title":"SAP Business Warehouse","href":"/26.4/en/connections/sources/sap-business-warehouse-source"},{"title":"SAP BusinessObjects BI","href":"/26.4/en/connections/sources/sap-businessobjects-bi-source"},{"title":"SAP ByDesign","href":"/26.4/en/connections/sources/sap-bydesign-source"},{"title":"SAP Cloud for Customer","href":"/26.4/en/connections/sources/sap-cloud-for-customer-source"},{"title":"SAP Concur","href":"/26.4/en/connections/sources/sap-concur-source"},{"title":"SAP ERP","href":"/26.4/en/connections/sources/sap-erp-source"},{"title":"SAP Fieldglass","href":"/26.4/en/connections/sources/sap-fieldglass-source"},{"title":"SAP Gateway","href":"/26.4/en/connections/sources/sap-gateway-source"},{"title":"SAP HANA","href":"/26.4/en/connections/sources/sap-hana-source"},{"title":"SAP HANA XSA","href":"/26.4/en/connections/sources/sap-hana-xsa-source"},{"title":"SAP SuccessFactors","href":"/26.4/en/connections/sources/sap-successfactors-source"},{"title":"SAS Xpt","href":"/26.4/en/connections/sources/sas-xpt-source"},{"title":"SendGrid","href":"/26.4/en/connections/sources/sendgrid-source"},{"title":"ServiceNow","href":"/26.4/en/connections/sources/servicenow-source"},{"title":"ShipStation","href":"/26.4/en/connections/sources/shipstation-source"},{"title":"Shopify","href":"/26.4/en/connections/sources/shopify-source"},{"title":"SingleStore","href":"/26.4/en/connections/sources/singlestore-source"},{"title":"Slack","href":"/26.4/en/connections/sources/slack-source"},{"title":"Smaregi","href":"/26.4/en/connections/sources/smaregi-source"},{"title":"Smartsheet","href":"/26.4/en/connections/sources/smartsheet-source"},{"title":"Snapchat Ads","href":"/26.4/en/connections/sources/snapchat-ads-source"},{"title":"Snowflake","href":"/26.4/en/connections/sources/snowflake-source"},{"title":"Spark SQL","href":"/26.4/en/connections/sources/spark-sql-source"},{"title":"Splunk","href":"/26.4/en/connections/sources/splunk-source"},{"title":"SQL Server","href":"/26.4/en/connections/sources/sql-source"},{"title":"Square","href":"/26.4/en/connections/sources/square-source"},{"title":"Stripe","href":"/26.4/en/connections/sources/stripe-source"},{"title":"SugarCRM","href":"/26.4/en/connections/sources/sugarcrm-source"},{"title":"SuiteCRM","href":"/26.4/en/connections/sources/suitecrm-source"},{"title":"SurveyMonkey","href":"/26.4/en/connections/sources/surveymonkey-source"},{"title":"Sybase","href":"/26.4/en/connections/sources/sybase-source"},{"title":"Sybase IQ","href":"/26.4/en/connections/sources/sybase-iq-source"},{"title":"Tableau CRM Analytics","href":"/26.4/en/connections/sources/tableau-crm-analytics-source"},{"title":"Talkdesk","href":"/26.4/en/connections/sources/talkdesk-source"},{"title":"Tally","href":"/26.4/en/connections/sources/tally-source"},{"title":"TaxJar","href":"/26.4/en/connections/sources/taxjar-source"},{"title":"Teradata","href":"/26.4/en/connections/sources/teradata-source"},{"title":"Trello","href":"/26.4/en/connections/sources/trello-source"},{"title":"Twilio","href":"/26.4/en/connections/sources/twilio-source"},{"title":"Twitter","href":"/26.4/en/connections/sources/twitter-source"},{"title":"Twitter Ads","href":"/26.4/en/connections/sources/twitter-ads-source"},{"title":"Veeva Vault","href":"/26.4/en/connections/sources/veeva-vault-source"},{"title":"Vertica","href":"/26.4/en/connections/sources/vertica-source"},{"title":"Wave Financial","href":"/26.4/en/connections/sources/wave-financial-source"},{"title":"WooCommerce","href":"/26.4/en/connections/sources/woocommerce-source"},{"title":"WordPress","href":"/26.4/en/connections/sources/wordpress-source"},{"title":"Workday","href":"/26.4/en/connections/sources/workday-source"},{"title":"xBase","href":"/26.4/en/connections/sources/xbase-source"},{"title":"Xero","href":"/26.4/en/connections/sources/xero-source"},{"title":"XML","href":"/26.4/en/connections/sources/xml-source"},{"title":"Yahoo Shopping","href":"/26.4/en/connections/sources/yahoo-shopping-source"},{"title":"Youtube Analytics","href":"/26.4/en/connections/sources/youtube-analytics-source"},{"title":"Zendesk","href":"/26.4/en/connections/sources/zendesk-source"},{"title":"Zoho Books","href":"/26.4/en/connections/sources/zoho-books-source"},{"title":"Zoho Creator","href":"/26.4/en/connections/sources/zoho-creator-source"},{"title":"Zoho CRM","href":"/26.4/en/connections/sources/zoho-crm-source"},{"title":"Zoho Inventory","href":"/26.4/en/connections/sources/zoho-inventory-source"},{"title":"Zoho Projects","href":"/26.4/en/connections/sources/zoho-projects-source"},{"title":"Zuora","href":"/26.4/en/connections/sources/zuora-source"}]},{"group":"Destinations","pages":[{"title":"AlloyDB","href":"/26.4/en/connections/destinations/alloydb-destination"},{"title":"Amazon Redshift","href":"/26.4/en/connections/destinations/amazon-redshift-destination"},{"title":"Amazon S3","href":"/26.4/en/connections/destinations/amazon-s3-destination"},{"title":"Apache Doris","href":"/26.4/en/connections/destinations/apache-doris-destination"},{"title":"Apache Kafka","href":"/26.4/en/connections/destinations/apache-kafka-destination"},{"title":"Azure Blob Storage","href":"/26.4/en/connections/destinations/azure-blob-storage-destination"},{"title":"Azure Data Lake Storage","href":"/26.4/en/connections/destinations/azure-data-lake-storage-destination"},{"title":"Azure Event Hubs","href":"/26.4/en/connections/destinations/azure-event-hubs-destination"},{"title":"Azure SQL Database","href":"/26.4/en/connections/destinations/azure-sql-database-destination"},{"title":"Azure Synapse","href":"/26.4/en/connections/destinations/azure-synapse-destination"},{"title":"Cassandra","href":"/26.4/en/connections/destinations/cassandra-destination"},{"title":"ClickHouse","href":"/26.4/en/connections/destinations/clickhouse-destination"},{"title":"CockroachDB","href":"/26.4/en/connections/destinations/cockroachdb-destination"},{"title":"Couchbase","href":"/26.4/en/connections/destinations/couchbase-destination"},{"title":"Databricks","href":"/26.4/en/connections/destinations/databricks-destination"},{"title":"DB2","href":"/26.4/en/connections/destinations/db2-destination"},{"title":"DB2 for i (Native)","href":"/26.4/en/connections/destinations/db2-i-(native)-destination"},{"title":"EnterpriseDB","href":"/26.4/en/connections/destinations/enterprisedb-destination"},{"title":"Google BigQuery","href":"/26.4/en/connections/destinations/google-bigquery-destination"},{"title":"Google Cloud Storage","href":"/26.4/en/connections/destinations/google-cloud-storage-destination"},{"title":"HubSpot","href":"/26.4/en/connections/destinations/hubspot-destination"},{"title":"Kintone","href":"/26.4/en/connections/destinations/kintone-destination"},{"title":"Local File Storage","href":"/26.4/en/connections/destinations/local-file-storage-destination"},{"title":"MariaDB","href":"/26.4/en/connections/destinations/mariadb-destination"},{"title":"Microsoft Dynamics 365","href":"/26.4/en/connections/destinations/microsoft-dynamics-365-destination"},{"title":"Microsoft OneLake","href":"/26.4/en/connections/destinations/microsoft-onelake-destination"},{"title":"Microsoft OneLake Mirroring","href":"/26.4/en/connections/destinations/microsoft-onelake-mirroring-destination"},{"title":"MongoDB","href":"/26.4/en/connections/destinations/mongodb-destination"},{"title":"MySQL","href":"/26.4/en/connections/destinations/mysql-destination"},{"title":"Oracle (Native)","href":"/26.4/en/connections/destinations/oracle-(native)-destination"},{"title":"PostgreSQL","href":"/26.4/en/connections/destinations/postgresql-destination"},{"title":"Sage Intacct","href":"/26.4/en/connections/destinations/sage-intacct-destination"},{"title":"Salesforce","href":"/26.4/en/connections/destinations/salesforce-destination"},{"title":"Salesforce Marketing Cloud","href":"/26.4/en/connections/destinations/salesforce-marketing-cloud-destination"},{"title":"Salesforce Marketing Cloud Account Engagement","href":"/26.4/en/connections/destinations/salesforce-marketing-cloud-account-engagement-destination"},{"title":"SAP HANA","href":"/26.4/en/connections/destinations/sap-hana-destination"},{"title":"SingleStore","href":"/26.4/en/connections/destinations/singlestore-destination"},{"title":"Snowflake","href":"/26.4/en/connections/destinations/snowflake-destination"},{"title":"SQL Server","href":"/26.4/en/connections/destinations/sql-server-destination"},{"title":"Teradata","href":"/26.4/en/connections/destinations/teradata-destination"},{"title":"Veeva Vault","href":"/26.4/en/connections/destinations/veeva-vault-destination"},{"title":"Vertica","href":"/26.4/en/connections/destinations/vertica-destination"},{"title":"Zoho CRM","href":"/26.4/en/connections/destinations/zoho-crm-destination"}]},{"title":"API Connector","sidebarTitle":"API Connector","href":"/26.4/en/connections/api-connector"},{"title":"JDBC (Generic) Connector","sidebarTitle":"JDBC Connector (Generic)","href":"/26.4/en/connections/jdbc-generic-connector"}]},{"group":"Jobs","pages":[{"title":"Jobs","href":"/26.4/en/jobs/jobs"},{"title":"Change Data Capture","href":"/26.4/en/jobs/change-data-capture"},{"title":"Reverse ETL","href":"/26.4/en/jobs/reverse-etl"},{"group":"Tasks","pages":[{"title":"Tasks","href":"/26.4/en/jobs/tasks/tasks"},{"title":"Custom Querying: REPLICATE Command","sidebarTitle":"Custom Querying: REPLICATE Command","href":"/26.4/en/jobs/tasks/replicate-command"},{"title":"Custom Querying: CHECKCACHE Command","sidebarTitle":"Custom Querying: CHECKCACHE Command","href":"/26.4/en/jobs/tasks/checkcache-command"}]},{"title":"Scheduling Jobs","href":"/26.4/en/jobs/scheduling-jobs"},{"title":"Alerts","href":"/26.4/en/jobs/notifications"},{"title":"Logs and History","href":"/26.4/en/jobs/logging-history"},{"title":"Advanced Job Options","href":"/26.4/en/jobs/advanced-job-options"}]},{"group":"Events","pages":[{"title":"Events","href":"/26.4/en/events/events"},{"title":"Introduction to APIScript","sidebarTitle":"APIScript","href":"/26.4/en/events/apiscript"},{"group":"Python Scripting","pages":[{"title":"Python","href":"/26.4/en/events/python-scripting/python"},{"title":"Prerequisites","href":"/26.4/en/events/python-scripting/prerequisites"},{"title":"Writing Python","href":"/26.4/en/events/python-scripting/writing-python"}]},{"group":"Operations","pages":[{"title":"Operations","href":"/26.4/en/events/operations/operations"},{"title":"Database Operations","href":"/26.4/en/events/operations/database-operations"},{"title":"File Operations","href":"/26.4/en/events/operations/file-operations"},{"title":"HTTP Operations","href":"/26.4/en/events/operations/http-operations"}]},{"group":"Formatters","pages":[{"title":"Formatters","href":"/26.4/en/events/formatters/formatters"},{"title":"String Formatters","href":"/26.4/en/events/formatters/string-formatters"},{"title":"Date Formatters","href":"/26.4/en/events/formatters/date-formatters"},{"title":"Math Formatters","href":"/26.4/en/events/formatters/math-formatters"},{"title":"File Formatters","description":null,"href":"/26.4/en/events/formatters/file-formatters"},{"title":"Function Formatters","href":"/26.4/en/events/formatters/function-formatters"}]}]},{"group":"Transformations","pages":[{"title":"Transformations","description":null,"href":"/26.4/en/transformations/transformations"},{"title":"In-Flight (ETL)","href":"/26.4/en/transformations/etl"},{"group":"Post-Job (ELT)","pages":[{"title":"ELT","href":"/26.4/en/transformations/post-job-elt/elt"},{"title":"DBT Transformations","href":"/26.4/en/transformations/post-job-elt/dbt-transformations"},{"title":"SQL Transformations","href":"/26.4/en/transformations/post-job-elt/sql-transformations"}]}]},{"group":"Release Notes","pages":[{"title":"Current Release","href":"/26.4/en/release-notes/current-release"},{"group":"2026","pages":[{"title":"July 2026 (26.3.9734)","href":"/26.4/en/release-notes/2026/july-2026"},{"title":"April 2026 (26.2.9629)","href":"/26.4/en/release-notes/2026/april-2026"},{"title":"January 2026 (26.1.9516)","href":"/26.4/en/release-notes/2026/january-2026"}]},{"group":"2025","pages":[{"title":"September 2025 (25.3.9396)","href":"/26.4/en/release-notes/2025/september-2025"},{"title":"June 2025 (25.2.9306)","href":"/26.4/en/release-notes/2025/june-2025"},{"title":"March 2025 (25.1.9242)","href":"/26.4/en/release-notes/2025/march-2025"}]},{"group":"2024","pages":[{"title":"December 2024 (24.3.9120)","href":"/26.4/en/release-notes/2024/december-2024"},{"title":"July 2024 (24.2.8969)","href":"/26.4/en/release-notes/2024/july-2024"},{"title":"April 2024 (24.1.8895)","href":"/26.4/en/release-notes/2024/april-2024"},{"title":"January 2024 (23.4.8794)","href":"/26.4/en/release-notes/2024/january-2024"}]},{"group":"2023","pages":[{"title":"October 2023 (23.3.8700)","href":"/26.4/en/release-notes/2023/october-2023"},{"title":"July 2023 (23.2.8606)","href":"/26.4/en/release-notes/2023/july-2023"},{"title":"April 2023 (23.0.8522)","href":"/26.4/en/release-notes/2023/april-2023"},{"title":"January 2023 (22.0.8434)","href":"/26.4/en/release-notes/2023/january-2023"}]},{"group":"2022","pages":[{"title":"November 2022 (22.0.8342)","href":"/26.4/en/release-notes/2022/november-2022"},{"title":"July 2022 (22.0.8242)","href":"/26.4/en/release-notes/2022/july-2022"},{"title":"March 2022 (21.0.8097)","href":"/26.4/en/release-notes/2022/march-2022"}]},{"group":"2021","pages":[{"title":"December 2021 (21.0.7998)","href":"/26.4/en/release-notes/2021/december-2021"}]}]},{"group":"License","pages":[{"title":"CData Sync End User Agreement","mode":"wide","href":"/26.4/en/legal/software-license"},{"title":"CData Sync Cloud Service Agreement","mode":"wide","href":"/26.4/en/legal/software-license-cloud"}]}]},{"tab":"Sync REST API","pages":[{"title":"Sync REST API","href":"/26.4/en/rest-api/rest-api"}]}]},{"version":"26.3","default":false,"pages":[{"title":"26.3","href":"/26.3/en/getting-started/getting-started"}]},{"version":"26.2","default":false,"pages":[{"title":"26.2","href":"/26.2/en/getting-started/getting-started"}]}]},{"language":"ja","navbar":{"primary":{"type":"button","label":"お問い合わせ","href":"https://jp.cdata.com/contact/"}},"pages":[{"title":"ja","href":"/26.4/ja/events/formatters/function-formatters"}]}]},"title":"Function Formatters - CData Sync Documentation","buildId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","deploymentId":"dpl_DFJrtvUi8HS5F9nkooKuDJsuD5BM","dynamics":[],"chunks":[]}