HTTP Status	Error Message	Scenario
400 Bad Request	"key was not present in the dictionary"	Missing Lookup Reference
412 Precondition Failed	"matching key values already exists"	Alternate Key Duplicate
Various	"Cannot insert duplicate key"	Platform Duplicate Constraint

Error 0x80040237: Duplicate Records and Missing References

Scenario 1: Missing Lookup Reference