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.

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

Developer
Maintained by Community
Actor metrics
  • 2 monthly users
  • 9.4% runs succeeded
  • 53.2 days response time
  • Created in Jul 2017
  • Modified 7 months ago