<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: OBSIDIAN Studio</title>
    <description>The latest articles on DEV Community by OBSIDIAN Studio (@obsidianstudio).</description>
    <link>https://dev.to/obsidianstudio</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F4257499%2F98a715ab-4862-49ee-9552-88c0e189bec5.png</url>
      <title>DEV Community: OBSIDIAN Studio</title>
      <link>https://dev.to/obsidianstudio</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/obsidianstudio"/>
    <language>en</language>
    <item>
      <title>Three checks to run yourself before accepting a CRM integration</title>
      <dc:creator>OBSIDIAN Studio</dc:creator>
      <pubDate>Sun, 22 Nov 2026 01:12:00 +0000</pubDate>
      <link>https://dev.to/obsidianstudio/three-checks-to-run-yourself-before-accepting-a-crm-integration-10ia</link>
      <guid>https://dev.to/obsidianstudio/three-checks-to-run-yourself-before-accepting-a-crm-integration-10ia</guid>
      <description>&lt;p&gt;"Integration complete" is the most expensive sentence in a form-to-CRM project, because no test is attached to it. Two failures cause most of the damage after handover:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;
&lt;strong&gt;Duplicates&lt;/strong&gt; — the same lead is written twice (double submit, retry, or a webhook delivered twice).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Silent loss&lt;/strong&gt; — the CRM returns 5xx for a few seconds and the lead disappears while the visitor sees an error page.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;Both pass every live demo, because a demo submits once and the CRM is healthy. So before accepting, run three scenarios in a test environment and record four columns: input, expected, actual, verdict. I ran this against a mock CRM with synthetic data (&lt;code&gt;OBS-001&lt;/code&gt;, &lt;code&gt;OBS-002&lt;/code&gt;) on 2026-11-21; every number below came from that run log.&lt;/p&gt;

&lt;h2&gt;
  
  
  Scenario 01 — one submit, one record
&lt;/h2&gt;



&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight http"&gt;&lt;code&gt;&lt;span class="no"&gt;POST&lt;/span&gt; &lt;span class="o"&gt;/&lt;/span&gt;&lt;span class="n"&gt;ingest&lt;/span&gt;
&lt;span class="nc"&gt;Content&lt;/span&gt;&lt;span class="o"&gt;-&lt;/span&gt;&lt;span class="nc"&gt;Type&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;application&lt;/span&gt;&lt;span class="o"&gt;/&lt;/span&gt;&lt;span class="n"&gt;json&lt;/span&gt;

&lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"request_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;"OBS-001"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="s2"&gt;"name"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;"Demo Alpha"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="s2"&gt;"email"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;"ops-a@example.com"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="s2"&gt;"type"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;&lt;span class="s2"&gt;"quote_request"&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Expected: &lt;code&gt;201 created&lt;/code&gt;, exactly one record, backlog 0.&lt;br&gt;
Actual: &lt;code&gt;201 created&lt;/code&gt;, &lt;code&gt;REC-0001&lt;/code&gt;, 1 record, 0 queued, 13 ms round trip. &lt;strong&gt;PASS&lt;/strong&gt;&lt;/p&gt;
&lt;h2&gt;
  
  
  Scenario 02 — the same submit twice
&lt;/h2&gt;

&lt;p&gt;Resend the identical body. The answer you want is not an error, and not a second record.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;POST /ingest   (same body as 01)
→ 200 duplicate_skipped, record_id REC-0001
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Expected: &lt;code&gt;200&lt;/code&gt;, same record id, total 1 record, dedupe key &lt;code&gt;request_id&lt;/code&gt;.&lt;br&gt;
Actual: &lt;code&gt;200 duplicate_skipped&lt;/code&gt;, &lt;code&gt;REC-0001&lt;/code&gt;, total 1 record. &lt;strong&gt;PASS&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;The dedupe key must be a business key that survives a retry: &lt;code&gt;request_id&lt;/code&gt;, or a hash of (form id, submitted date, email). Not the CRM record id — it does not exist on the first attempt — and not a timestamp, which changes on every retry.&lt;/p&gt;
&lt;h2&gt;
  
  
  Scenario 03 — the CRM returns 503
&lt;/h2&gt;


&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;POST /ingest   {"request_id":"OBS-002", ...}
→ 503 unavailable          (records 0, backlog 1)

clear the fault, then retry once with the same request_id
→ 201 created, REC-0002    (records 1, backlog 0)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;


&lt;p&gt;Expected: on 503 nothing is written to the CRM, the lead goes to a queue, and one manual retry with the same key produces exactly one record.&lt;br&gt;
Actual: &lt;code&gt;503&lt;/code&gt; before the write, 0 records / 1 queued; then &lt;code&gt;201 created&lt;/code&gt; &lt;code&gt;REC-0002&lt;/code&gt;. Final state: 2 records, 0 queued, 0 duplicates. &lt;strong&gt;PASS&lt;/strong&gt;&lt;/p&gt;
&lt;h2&gt;
  
  
  The code that has to exist
&lt;/h2&gt;

&lt;p&gt;Three independent mechanisms. If any is missing, one of the checks above fails.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight python"&gt;&lt;code&gt;&lt;span class="nd"&gt;@app&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;post&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"/ingest"&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="k"&gt;def&lt;/span&gt; &lt;span class="nf"&gt;ingest&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;payload&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="kt"&gt;dict&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
    &lt;span class="n"&gt;key&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;payload&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"request_id"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;
    &lt;span class="n"&gt;row&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;db&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;one&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"SELECT crm_id FROM crm_records WHERE request_id = %s"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;key&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;if&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"duplicate_skipped"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"record_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;row&lt;/span&gt;&lt;span class="p"&gt;[&lt;/span&gt;&lt;span class="s2"&gt;"crm_id"&lt;/span&gt;&lt;span class="p"&gt;]&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;200&lt;/span&gt;
    &lt;span class="k"&gt;try&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="n"&gt;crm_id&lt;/span&gt; &lt;span class="o"&gt;=&lt;/span&gt; &lt;span class="n"&gt;crm&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;create&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;payload&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;        &lt;span class="c1"&gt;# write before acknowledging&lt;/span&gt;
    &lt;span class="k"&gt;except&lt;/span&gt; &lt;span class="nc"&gt;CRMUnavailable&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt;
        &lt;span class="n"&gt;db&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;execute&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"INSERT INTO retry_queue(request_id, payload) "&lt;/span&gt;
                   &lt;span class="s2"&gt;"VALUES (%s, %s) ON CONFLICT DO NOTHING"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;key&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;payload&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
        &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"unavailable"&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;503&lt;/span&gt;
    &lt;span class="n"&gt;db&lt;/span&gt;&lt;span class="p"&gt;.&lt;/span&gt;&lt;span class="nf"&gt;execute&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="s2"&gt;"INSERT INTO crm_records(request_id, crm_id) VALUES (%s, %s)"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
               &lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="n"&gt;key&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="n"&gt;crm_id&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
    &lt;span class="k"&gt;return&lt;/span&gt; &lt;span class="p"&gt;{&lt;/span&gt;&lt;span class="s2"&gt;"status"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="s2"&gt;"created"&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="s2"&gt;"record_id"&lt;/span&gt;&lt;span class="p"&gt;:&lt;/span&gt; &lt;span class="n"&gt;crm_id&lt;/span&gt;&lt;span class="p"&gt;}&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt; &lt;span class="mi"&gt;201&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;





&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;CREATE&lt;/span&gt; &lt;span class="k"&gt;TABLE&lt;/span&gt; &lt;span class="n"&gt;crm_records&lt;/span&gt; &lt;span class="p"&gt;(&lt;/span&gt;
  &lt;span class="n"&gt;request_id&lt;/span&gt; &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;PRIMARY&lt;/span&gt; &lt;span class="k"&gt;KEY&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;   &lt;span class="c1"&gt;-- the dedupe key, enforced by the database&lt;/span&gt;
  &lt;span class="n"&gt;crm_id&lt;/span&gt;     &lt;span class="kt"&gt;text&lt;/span&gt; &lt;span class="k"&gt;NOT&lt;/span&gt; &lt;span class="kc"&gt;NULL&lt;/span&gt;&lt;span class="p"&gt;,&lt;/span&gt;
  &lt;span class="n"&gt;created_at&lt;/span&gt; &lt;span class="kt"&gt;timestamptz&lt;/span&gt; &lt;span class="k"&gt;NOT&lt;/span&gt; &lt;span class="kc"&gt;NULL&lt;/span&gt; &lt;span class="k"&gt;DEFAULT&lt;/span&gt; &lt;span class="nb"&gt;now&lt;/span&gt;&lt;span class="p"&gt;(&lt;/span&gt;&lt;span class="p"&gt;)&lt;/span&gt;
&lt;span class="p"&gt;)&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;The application-level &lt;code&gt;SELECT&lt;/code&gt; is the fast path; the primary key is the last line of defence when two identical requests arrive within milliseconds of each other. If the delivered schema has no unique constraint on the business key, ask for it in writing — an index added later means duplicates were possible until then.&lt;/p&gt;

&lt;h2&gt;
  
  
  The acceptance table
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;#&lt;/th&gt;
&lt;th&gt;Input&lt;/th&gt;
&lt;th&gt;Expected&lt;/th&gt;
&lt;th&gt;Actual&lt;/th&gt;
&lt;th&gt;Verdict&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;01&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;OBS-001&lt;/code&gt;, one POST&lt;/td&gt;
&lt;td&gt;201, 1 record, 0 queued&lt;/td&gt;
&lt;td&gt;201 &lt;code&gt;created&lt;/code&gt; &lt;code&gt;REC-0001&lt;/code&gt;, 1 record, 0 queued, 13 ms&lt;/td&gt;
&lt;td&gt;PASS&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;02&lt;/td&gt;
&lt;td&gt;identical body again&lt;/td&gt;
&lt;td&gt;200, same id, total 1&lt;/td&gt;
&lt;td&gt;200 &lt;code&gt;duplicate_skipped&lt;/code&gt; &lt;code&gt;REC-0001&lt;/code&gt;, total 1&lt;/td&gt;
&lt;td&gt;PASS&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;03&lt;/td&gt;
&lt;td&gt;
&lt;code&gt;OBS-002&lt;/code&gt; with 503 injected&lt;/td&gt;
&lt;td&gt;503, 0 records, 1 queued&lt;/td&gt;
&lt;td&gt;503 &lt;code&gt;unavailable&lt;/code&gt;, 0 records, 1 queued&lt;/td&gt;
&lt;td&gt;PASS&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;03b&lt;/td&gt;
&lt;td&gt;same key, one manual retry&lt;/td&gt;
&lt;td&gt;201, 1 record, 0 queued&lt;/td&gt;
&lt;td&gt;201 &lt;code&gt;created&lt;/code&gt; &lt;code&gt;REC-0002&lt;/code&gt;, total 2, 0 queued&lt;/td&gt;
&lt;td&gt;PASS&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

&lt;p&gt;A row is PASS only when the &lt;em&gt;actual&lt;/em&gt; column was copied from a log, not from memory. I attach the run log lines and the run id to the table, and the same id is printed on the screen recording — the table cannot be edited afterwards without the recording disagreeing.&lt;/p&gt;

&lt;h2&gt;
  
  
  What these three checks do not cover
&lt;/h2&gt;

&lt;p&gt;Write the excluded scope into the same acceptance document:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;a write that succeeded but whose response was lost on the way back (client saw a timeout, CRM has the record);&lt;/li&gt;
&lt;li&gt;two identical requests arriving concurrently;&lt;/li&gt;
&lt;li&gt;automatic retry (backoff worker) — this run verified one manual retry only.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;If the build must survive those cases, they become separate rows with their own criteria and their own evidence.&lt;/p&gt;

&lt;h2&gt;
  
  
  Before you sign
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Ask for the test environment and run the three scenarios yourself; do not accept a screen share.&lt;/li&gt;
&lt;li&gt;Write &lt;code&gt;HTTP status + record count + backlog count&lt;/code&gt; for each row &lt;em&gt;before&lt;/em&gt; running it.&lt;/li&gt;
&lt;li&gt;Mark a row FAIL on any difference, even when it looks harmless.&lt;/li&gt;
&lt;li&gt;Keep one run id on the log, the table and the recording.&lt;/li&gt;
&lt;li&gt;Put the excluded scope in the same document as the PASS rows.&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;If you need the table and the checks without building anything, the template (PDF, sheet, three-row acceptance table) is here: &lt;a href="https://proof.intelliliving.kr?utm_source=devto&amp;amp;utm_medium=organic&amp;amp;utm_campaign=b2b_obsidian&amp;amp;utm_content=dv_01" rel="noopener noreferrer"&gt;https://proof.intelliliving.kr?utm_source=devto&amp;amp;utm_medium=organic&amp;amp;utm_campaign=b2b_obsidian&amp;amp;utm_content=dv_01&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;If your team needs the test environment actually built and verified rather than the template, reply with your form tool and CRM and I will scope the three scenarios for your stack.&lt;/p&gt;

</description>
      <category>testing</category>
      <category>webdev</category>
      <category>database</category>
    </item>
  </channel>
</rss>
