Question

Connector fails on the following error :

MismatchedInputException:Cannot construct instance of `com.fivetran.integrations.functions.common.Response$Record` (although at least one Creator exists): no String-argument constructor/factory method to deserialize from String value 

Environment

Connector: AWS Lambda

Answer

The AWS response format needs to be corrected as per the documented response format, see below for the expected format:

Cause

In this case, the Delete node is not in the correct format. Delete node can contain a bunch of table nodes whose values are lists of keys meant to be deleted in those tables.