The answer was there I just had to keep on looking. Here are the connector settings that worked for me.
{
"name": "MongoAccountSinkConnector",
"config": {
"connector.class": "com.mongodb.kafka.connect.MongoSinkConnector",
"name": "MongoAccountSinkConnector",
"topics": "ACCOUNT",
"connection.uri": "mongodb://...",
"database": "local",
"collection": "Account",
"key.converter": "org.apache.kafka.connect.storage.StringConverter",
"key.converter.schemas.enable": "false",
"value.converter": "io.confluent.connect.avro.AvroConverter",
"value.converter.schemas.enable": "true",
"value.converter.schema.registry.url": "http://...:28081",
"mongodb.delete.on.null.values": "true",
"delete.on.null.values": "true",
"document.id.strategy.overwrite.existing": "true",
"document.id.strategy":"com.mongodb.kafka.connect.sink.processor.id.strategy.ProvidedInKeyStrategy",
"transforms":"hk",
"transforms.hk.type":"org.apache.kafka.connect.transforms.HoistField$Key",
"transforms.hk.field":"_id",
"writemodel.strategy": "com.mongodb.kafka.connect.sink.writemodel.strategy.ReplaceOneDefaultStrategy"
}
}