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.

The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4const client = new ApifyClient({
5    token: '<YOUR_API_TOKEN>',
6});
7
8// Prepare Actor input
9const input = {
10    "connection": {},
11    "proxyConfig": {
12        "useApifyProxy": true,
13        "apifyProxyGroups": [
14            "qfCaFFuCodXxAS59E"
15        ]
16    },
17    "rows": [],
18    "staticParam": {}
19};
20
21(async () => {
22    // Run the Actor and wait for it to finish
23    const run = await client.actor("petr_cermak/mysql-insert").call(input);
24
25    // Fetch and print Actor results from the run's dataset (if any)
26    console.log('Results from dataset');
27    console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
28    const { items } = await client.dataset(run.defaultDatasetId).listItems();
29    items.forEach((item) => {
30        console.dir(item);
31    });
32})();
33
34// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs
Developer
Maintained by Community
Actor metrics
  • 3 monthly users
  • 0 stars
  • 19.5% runs succeeded
  • 63 days response time
  • Created in Jul 2017
  • Modified 8 months ago