I have a simple FlowFile which contains JSON:
{
"name" : "ga:sessions",
"val" : "0"
}
And some attributes:
account.login = "[email protected]"
account.id = "123456789"
I want to use QueryRecord processor to prepare JSON for saving into database.

But I get an error:
QueryRecord successfully set account_login from attribute but returns error. What is the problem? If I will not use attributes in QueryRecord SQL statement, I'll not get an error:
[{
"metric_name" : "ga:sessions",
"metric_value" : "0"
}]
How to solve it?

QueryRecordbefore in the same way, but now it doesn't work. You can prepare JSON with Expression Language and put attributes to content. But i just usedJoltTransforminstead and all works fine. - funnelCONN