{"id":5150,"date":"2026-02-25T08:42:52","date_gmt":"2026-02-25T07:42:52","guid":{"rendered":"https:\/\/www.beeminds.nl\/insights\/how-does-an-upsert-work"},"modified":"2026-02-25T08:42:52","modified_gmt":"2026-02-25T07:42:52","slug":"how-does-an-upsert-work","status":"publish","type":"knowledge_pt","link":"https:\/\/www.beeminds.nl\/en\/insights\/how-does-an-upsert-work","title":{"rendered":"How does an upsert work?"},"content":{"rendered":"<p>In an upsert, the system checks whether a particular record already exists, usually based on a unique ID.<\/p>\n<ul>\n<li>Does the record not yet exist? \u2192 <strong>Insert <\/strong> <\/li>\n<li>Does the record already exist? \u2192 <strong>Update <\/strong>(update existing data) <\/li>\n<\/ul>\n<p>This way you avoid duplicate data and your dataset always remains current.<\/p>\n<h5>And how does Intelligenthive do this?<\/h5>\n<p>Within <strong>Intelligenthive\u00ae <\/strong>, this entire process happens automatically. The platform recognizes changes in your source systems and updates only the changed records in your data platform. <\/p>\n<p>So you don&#8217;t have to write your own scripts or determine what to update. .The <strong>Intelligenthive\u00ae takes the entire upsert logic out of your hands.<\/strong> <\/p>\n<p>The result: always up-to-date, error-free data without manual management.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The term upsert comes from the database world and is a combination of two words: update and insert. It means that a system automatically decides whether a record should be added (insert) or updated (update). <\/p>\n<p>So with an upsert, you don&#8217;t have to first check if a record already exists. The database or data pipeline does that itself. <\/p>\n","protected":false},"featured_media":0,"template":"","knowledge_type":[58],"knowledge_category":[],"class_list":["post-5150","knowledge_pt","type-knowledge_pt","status-publish","hentry","knowledge_type-simplified"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt\/5150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_pt"}],"about":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/types\/knowledge_pt"}],"wp:attachment":[{"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/media?parent=5150"}],"wp:term":[{"taxonomy":"knowledge_type","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_type?post=5150"},{"taxonomy":"knowledge_category","embeddable":true,"href":"https:\/\/www.beeminds.nl\/en\/wp-json\/wp\/v2\/knowledge_category?post=5150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}