MySQL Insert
Pricing
Pay per usage
MySQL Insert
This act takes a crawler execution and inserts it's results into a remote MySQL database.
0.0 (0)
Pricing
Pay per usage
1
58
2
Last modified
2 years ago
JSON example not working in JSON editor
ClosedI copied the JSON example into the JSON box, updated the connection details to my remote mySQL DB. There is an error that says "Error: Cannot start actor run (Field "connection" is required)"
can you show me a task or run that you're having issues?
stizzi
Sure. I'm copying this into "JSON" and hitting run.
{ "connection": { "host" : "hostname", "user" : "admin", "password" : "pass", "database" : "dbname", // optional "port" : 3306 // optional }, "table": "test", "rows": [ {"column_1": "value_1", "column_2": "value_2"}, {"column_1": "value_3", "column_2": "value_4"} ] }
that's just an example of how the input should look like, JSON doesn't allow comments, //optional are comments
