Solved
NiFi LookupRecord Processor Bug
I believe I found a bug in the NiFi LookupRecord processor.
When there is no match for a key in the DatabaseRecordLookupService it returns an error:

The lookup processor config:

The input JSON has the following structure:
[
{
"id": 1,
"name": "Bitcoin",
"symbol": "BTC"
},
{
"id": 2,
"name": "Apecoin",
"symbol": "Ape"
}
]

