
MySQL Insert
- petr_cermak/mysql-insert
- Modified
- Users 43
- Runs 67k
- Created by
Petr 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);
});
})();