MySQL Insert
No credit card required
MySQL Insert
No credit card required
This act takes a crawler execution and inserts it's results into a remote MySQL database.
JSON example not working in JSON editor
Closed
I 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
Petr Cermak- 1 monthly user
- 1 star
- Created in Jul 2017
- Modified 12 months ago
