herokuheroku-connect

Is there a way to allow multiple synchronisation errors on heroku connect mapping?

I am always getting postgresql error on sfid field because of unique restrictions after mapping and a bad SF synchronisation (so that field stay blank).

After second SF synchronisation errors I can't save other row.

Please help

Solution

  • In order to save rows without getting UNIQUE errors on sfid, try to create 18 length uid to avoid blank field (x2 blank fields in postgreSQL is considered equal)

    node.js:

    const { v4: uuidv4 } = require('uuid');

let uuid = uuidv4();
record.sfId = uuid.substring(1, 18);