MySQL Insert avatar
MySQL Insert
Try for free

No credit card required

View all Actors
MySQL Insert

MySQL Insert

petr_cermak/mysql-insert
Try for free

No credit card required

This act takes a crawler execution and inserts it's results into a remote MySQL database.

User avatar

JSON example not working in JSON editor

Closed

stizzi opened this issue
2 years ago

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)"

User avatar

can you show me a task or run that you're having issues?

User avatar

stizzi

2 years ago

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"} ] }

User avatar

that's just an example of how the input should look like, JSON doesn't allow comments, //optional are comments

Developer
Maintained by Community
Actor metrics
  • 1 monthly users
  • 0.0% runs succeeded
  • 75.2 days response time
  • Created in Jul 2017
  • Modified 8 months ago