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.

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>

Developer
Maintained by Community
Actor metrics
  • 3 monthly users
  • 0 stars
  • 19.5% runs succeeded
  • 60 days response time
  • Created in Jul 2017
  • Modified 8 months ago