I'm using the ConvertJSONToSQL processor, and the MySql table has a space in the name. It appears to be the problem because when I remove the name from the table it works as expected.
I can successfully query the table from various tools and the mysql command line using back ticks "`" around the table name.
The table name:
personal information
I've tried the following:
`personal information`
"personal information"
'personal information'
\"personal information\"
[personal information]
Any suggestions?