MySQL Insert

  • petr_cermak/mysql-insert
  • Modified
  • Users 43
  • Runs 67k
  • Created by Author's avatarPetr Cermak

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

To run the code examples, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token. For a more detailed explanation, please read about running Actors via the API in Apify Docs.

import { ApifyClient } from 'apify-client';

// Initialize the ApifyClient with API token
const client = new ApifyClient({
    token: '<YOUR_API_TOKEN>',
});

// Prepare Actor input
const input = {
    "connection": {},
    "proxyConfig": {
        "useApifyProxy": true,
        "apifyProxyGroups": [
            "qfCaFFuCodXxAS59E"
        ]
    },
    "rows": [],
    "staticParam": {}
};

(async () => {
    // Run the Actor and wait for it to finish
    const run = await client.actor("petr_cermak/mysql-insert").call(input);

    // Fetch and print Actor results from the run's dataset (if any)
    console.log('Results from dataset');
    const { items } = await client.dataset(run.defaultDatasetId).listItems();
    items.forEach((item) => {
        console.dir(item);
    });
})();