MySQL Insert

Pricing

Pay per usage

Try for free

Go to Apify Store

MySQL Insert

Try for free

Developed by

Petr Cermak

Maintained by Community

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

0.0 (0)

Pricing

Pay per usage

Last modified

2 years ago

Developer tools

Integrations

Open source

Connection information

connectionobjectRequired

Provide the remote MYSQL connection as an object as state in the documentation

Default value of this property is {}

Table name

tablestringRequired

Target table

Proxy config

proxyConfigobjectOptional

Optionally route the connection through the StaticUS3 group

Rows

rowsarrayOptional

Optionally provide the rows to insert

Dataset

datasetIdstringOptional

When not using webhooks, provide the dataset id here

Predefined parameters

staticParamobjectOptional

You can provide the shape of values that should be appended at the end of your INSERT statements

Attribute check

existsAttrstringOptional

Check for the given property existence. It will issue a SELECT query before trying to insert

Row split

rowSplitintegerOptional

How many rows to batch. High values might timeout the query

Default value of this property is 10

Debug log

debugLogbooleanOptional

Enable dumping the contents to the log

Default value of this property is false

PostgreSQL Insert

petr_cermak/PostgreSQL-insert

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

Petr Cermak

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Backup MySQL Database - Google drive Integration

worldunboxer/backup-mysql-database

Effortlessly back up your MySQL database with our Apify actor. It securely connects to your database, generates full SQL backups, and stores them on Google Drive, FTP servers, or Apify Key-Value Store. Ensure data safety with seamless storage and sharing options tailored to your needs.

Umesh Patidar

5.0

Execution To Xlsx

petr_cermak/execution-to-xlsx

The act takes a JSON input containing a crawler executionID, downloads the results and converts them to XLSX.

Petr Cermak

Remote Actor

getdataforme/remote-actor

GetDataForMe

Datasets Compare

petr_cermak/datasets-compare

Act for comparing crawler execution results. By default the final result set will contain only new and updated records.

Petr Cermak

Remote.com Jobs Scraper 🌐🚀💼 - Cheap

scrapestorm/remote-com-jobs-scraper---cheap

Remote.com Jobs Scraper 🔍 allows you to extract detailed remote job listings with customizable filters. Gather insights on job titles, companies, salaries, locations & more perfect for recruitment research or market analysis! 🌍📊🧑‍💼 Ideal for tracking hiring trends in the remote work space

Storm_Scraper

5.0

Remote.com Job Scraper

saswave/remote-com-job-scraper

Remote.com Job Scraper. From a job search url on website remote.com , extract job listings. Get informations about title, date creation, location, salary, company website, company name and more

SASWAVE

Execution ID To XLS Send

vaclavrut/executionid-to-xls-and-send

This actor takes JSON at input, creates it as XLS from the execution ID result and then sends a link by email. The URL is also outputted in the log. Solves attaching XLS files to emails.

Vaclav Rut

Example Process Crawl Results

apify/example-process-crawl-results

Iterates through all results from a crawler run and count them. Needs to be called from the crawler's finish webhook by adding an URL to finish the webhook of your crawler. Use this actor as a starting point to develop custom post-processing of data from the crawler.