Insert a full JSON response into MySql 8 db field - tried json, text

Hi all,

Getting an error when trying to output JSON from an API directly into a MySql 8 field.

I’ve tried the field as ‘text’ and ‘JSON’ type, and also outputting the API response directly, or using a Set Value Array and outputting that, all throw out the following error:

stack: "Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', experience = ‘[object Object]’, ‘[object Object]’, education = ‘[object Ob’ at line 1↵

Community Page
Last updated: