{"id":851,"date":"2026-05-08T04:26:06","date_gmt":"2026-05-08T08:26:06","guid":{"rendered":"https:\/\/blog2wrkdev.wpenginepowered.com\/newfeatures-upsert-smart-data-mapping\/"},"modified":"2026-09-29T06:32:58","modified_gmt":"2026-09-29T10:32:58","slug":"newfeatures-upsert-smart-data-mapping","status":"publish","type":"post","link":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/","title":{"rendered":"Workato Upsert & Smart Data Mapping for Faster Integrations"},"content":{"rendered":"\n

We’re always working to make our no-code recipe building as intuitive as possible. Our new features, Upsert and Smart Data Mapping<\/a>, do just that, making recipes shorter to read, easier to build and backed by the same powerful integration capabilities you know and love.<\/p>\n\n\n\n

Upsert Object for Salesforce<\/b><\/h2>\n\n\n\n

We’re simplifying the way Workato recipes are built and read with the new Upsert feature. Upsert is a combination of the words “Insert” and “Update.” <\/p>\n\n\n\n

For Workato specifically, it is the process of inserting and\/or updating data from one app into another app without creating duplicates – a very common scenario for our users.\u00a0In other words, when we’re syncing data between apps, we often run into situations where the data we’re inserting from App 1 may already exist in App 2. <\/p>\n\n\n\n

We don’t want duplicate data, so we need to check to see if it already exists –\u00a0if it does, we update it, and if it does not, we create it.<\/p>\n\n\n\n

Let’s imagine that\u00a0when a new Ticket is created or updated in Zendesk<\/a>, we want\u00a0to sync it\u00a0with the corresponding Salesforce Case<\/a>.\u00a0<\/p>\n\n\n\n

If you have created a Workato recipe <\/a>before, you are probably very familiar with the\u00a0logic snippet\u00a0shown below – a new or updated ticket in Zendesk triggers the recipe, then Workato searches for the matching case in Salesforce, if it exists, we update it, if it doesn’t, we create a new\u00a0case.<\/p>\n\n\n

\n
\"upsert-uno\"<\/figure>\n<\/div>\n\n\n

Now, with the new Upsert feature, the very same recipe as above will look like this:<\/p>\n\n\n

\n
\"upsert-dos\"<\/figure>\n<\/div>\n\n\n

To\u00a0configure an Upsert, just\u00a0select the Object (‘Salesforce Case’ in this example) and then specify the Key Field\u00a0you want to use to look up this object (this is the same as what you would have used in the \u2018search\u2019 action – so in this example, ‘Account ID’).<\/p>\n\n\n

\n
\"upsert-3-again\"<\/figure>\n<\/div>\n\n\n

Right now, Upsert is only available for Salesforce. We will be adding\u00a0support for\u00a0the\u00a0Upsert feature\u00a0for other apps as well, so keep an eye out or let us know what apps you want\u00a0to use Upsert with in the comments!<\/p>\n\n\n\n

Smart Data Mapping<\/b><\/h2>\n\n\n\n

Smart Data Mapping means we can help guide you as you build your recipe. We’ll now offer automatic suggestions for how to map a specific field based on the\u00a0actions\/triggers you have used in your recipe. The auto-suggest kicks into action anytime you select an input data field. Check it out:<\/p>\n\n\n\n

\"smart-auto-mapping\"<\/figure>\n\n\n\n

Our auto-suggestions learn from data mappings<\/a> done by Workato users. We look at the data and offer up the best recommendations. <\/p>\n\n\n\n

As a result, you may not see a lot of recommendations for certain fields, but we are working on adding to our corpus and refining the algorithm so we can offer even more great recommendations.<\/p>\n\n\n\n

We hope these new features continue to make recipe building one of the easiest and most effective ways to build robust automations across your apps. Let us know your feedback or any suggestions for new features you might have.<\/p>\n","protected":false},"excerpt":{"rendered":"

We’re always working to make our no-code recipe building as intuitive as possible. Our new features, Upsert and Smart Data Mapping, do just that, making recipes shorter to read, easier to build and backed by the same powerful integration capabilities you know and love. Upsert Object for Salesforce We’re simplifying the way Workato recipes are […]<\/p>\n","protected":false},"author":11,"featured_media":11730,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[35],"tags":[],"class_list":["post-851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-product-news"],"acf":[],"yoast_head":"\nWorkato Upsert & Smart Data Mapping for Faster Integrations - Workato<\/title>\n<meta name=\"description\" content=\"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Workato Upsert & Smart Data Mapping for Faster Integrations - Workato\" \/>\n<meta property=\"og:description\" content=\"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/\" \/>\n<meta property=\"og:site_name\" content=\"Workato\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-08T08:26:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-29T10:32:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"953\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gautham Viswanathan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gautham Viswanathan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/\"},\"author\":{\"name\":\"Gautham Viswanathan\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/44938095250630cf619d3c497ae94869\"},\"headline\":\"Workato Upsert & Smart Data Mapping for Faster Integrations\",\"datePublished\":\"2026-05-08T08:26:06+00:00\",\"dateModified\":\"2026-09-29T10:32:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/\"},\"wordCount\":510,\"image\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/upsert-scaled.jpg\",\"articleSection\":[\"Company & Product News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/\",\"name\":\"Workato Upsert & Smart Data Mapping for Faster Integrations - Workato\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/upsert-scaled.jpg\",\"datePublished\":\"2026-05-08T08:26:06+00:00\",\"dateModified\":\"2026-09-29T10:32:58+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/44938095250630cf619d3c497ae94869\"},\"description\":\"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/upsert-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/upsert-scaled.jpg\",\"width\":2560,\"height\":953},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/newfeatures-upsert-smart-data-mapping\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Workato Upsert & Smart Data Mapping for Faster Integrations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#website\",\"url\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/\",\"name\":\"Workato\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workato.com\\\/the-connector\\\/#\\\/schema\\\/person\\\/44938095250630cf619d3c497ae94869\",\"name\":\"Gautham Viswanathan\",\"description\":\"Gautham currently heads Products at Workato, where he was part of the founding team. Previously as an early employee of TIBCO, he led the development of several Integration products that powered TIBCO\u2019s growth from a startup to one of the top names in Enterprise software.\",\"sameAs\":[\"https:\\\/\\\/www.workato.com\\\/profiles\\\/gautham\"],\"url\":\"https:\\\/\\\/blog2workato.wpengine.com\\\/author\\\/gautham\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Workato Upsert & Smart Data Mapping for Faster Integrations - Workato","description":"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/","og_locale":"en_US","og_type":"article","og_title":"Workato Upsert & Smart Data Mapping for Faster Integrations - Workato","og_description":"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation","og_url":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/","og_site_name":"Workato","article_published_time":"2026-05-08T08:26:06+00:00","article_modified_time":"2026-09-29T10:32:58+00:00","og_image":[{"width":2560,"height":953,"url":"https:\/\/workato.com\/the-connector\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg","type":"image\/jpeg"}],"author":"Gautham Viswanathan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gautham Viswanathan","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#article","isPartOf":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/"},"author":{"name":"Gautham Viswanathan","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/44938095250630cf619d3c497ae94869"},"headline":"Workato Upsert & Smart Data Mapping for Faster Integrations","datePublished":"2026-05-08T08:26:06+00:00","dateModified":"2026-09-29T10:32:58+00:00","mainEntityOfPage":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/"},"wordCount":510,"image":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#primaryimage"},"thumbnailUrl":"https:\/\/blog2workato.wpengine.com\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg","articleSection":["Company & Product News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/","url":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/","name":"Workato Upsert & Smart Data Mapping for Faster Integrations - Workato","isPartOf":{"@id":"https:\/\/www.workato.com\/the-connector\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#primaryimage"},"image":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#primaryimage"},"thumbnailUrl":"https:\/\/blog2workato.wpengine.com\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg","datePublished":"2026-05-08T08:26:06+00:00","dateModified":"2026-09-29T10:32:58+00:00","author":{"@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/44938095250630cf619d3c497ae94869"},"description":"Learn how Workato Upsert and Smart Data Mapping simplify integrations, reduce manual work, and accelerate workflow automation","breadcrumb":{"@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#primaryimage","url":"https:\/\/blog2workato.wpengine.com\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg","contentUrl":"https:\/\/blog2workato.wpengine.com\/wp-content\/uploads\/2026\/09\/upsert-scaled.jpg","width":2560,"height":953},{"@type":"BreadcrumbList","@id":"https:\/\/blog2workato.wpengine.com\/newfeatures-upsert-smart-data-mapping\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog2workato.wpengine.com\/"},{"@type":"ListItem","position":2,"name":"Workato Upsert & Smart Data Mapping for Faster Integrations"}]},{"@type":"WebSite","@id":"https:\/\/www.workato.com\/the-connector\/#website","url":"https:\/\/www.workato.com\/the-connector\/","name":"Workato","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workato.com\/the-connector\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.workato.com\/the-connector\/#\/schema\/person\/44938095250630cf619d3c497ae94869","name":"Gautham Viswanathan","description":"Gautham currently heads Products at Workato, where he was part of the founding team. Previously as an early employee of TIBCO, he led the development of several Integration products that powered TIBCO\u2019s growth from a startup to one of the top names in Enterprise software.","sameAs":["https:\/\/www.workato.com\/profiles\/gautham"],"url":"https:\/\/blog2workato.wpengine.com\/author\/gautham\/"}]}},"_links":{"self":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/comments?post=851"}],"version-history":[{"count":3,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/851\/revisions"}],"predecessor-version":[{"id":5741,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/posts\/851\/revisions\/5741"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/media\/11730"}],"wp:attachment":[{"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/media?parent=851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/categories?post=851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog2workato.wpengine.com\/wp-json\/wp\/v2\/tags?post=851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}