MySQL Insert avatar
MySQL Insert

Pricing

Pay per usage

Go to Store
MySQL Insert

MySQL Insert

petr_cermak/mysql-insert

Developed by

Petr Cermak

Maintained by Community

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

0.0 (0)

Pricing

Pay per usage

1

Monthly users

1

0

Last modified

2 years ago

ST

JSON example not working in JSON editor

Closed
stizzi opened this issue
3 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)"

pocesar avatar

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

ST

stizzi

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

pocesar avatar

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

Pricing

Pricing model

Pay per usage

This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.