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.
mysql-insert
Apify actor for inserting crawler results into a remote MySQL table.
This actor fetches all results from a specified dataset (or as raw data) and inserts them into a table in a remote MySQL database.
Input
Input is a JSON object with the following properties:
1{ 2 "datasetId": "your_dataset_id", 3 "connection": { 4 "host" : "host_name", 5 "user" : "user_name", 6 "password" : "user_password", 7 "database" : "database_name", // optional 8 "port" : 3306 // optional 9 }, 10 "table": "table_name", 11 // Optionally, you can add raw data instead of datasetId 12 "rows": [ 13 {"column_1": "value_1", "column_2": "value_2"}, 14 {"column_1": "value_3", "column_2": "value_4"} 15 ] 16}
Webhooks
Very often you want to run an image mysql-insert update after every run of your scraping/automation actor. Webhooks are solution for this. The default datasetId will be passed automatically to the this actor's run so you don't need to set it up in the payload template (internally the actor transforms the resource.defaultDatasetId from the webhook into just datasetId for its own input).
I strongly recommend to create a task from this actor with predefined input that will not change in every run - the only changing part is usually datasetId. You will not need to fill up the payload template and your webhook URL will then look like:
https://api.apify.com/v2/actor-tasks/<YOUR-TASK-ID>/runs?token=<YOUR_API_TOKEN>
Petr Cermak- 2 monthly users
- 9.7% runs succeeded
- 53.2 days response time
- Created in Jul 2017
- Modified 7 months ago
