MySQL Insert

  • petr_cermak/mysql-insert
  • Modified
  • Users 42
  • 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.

from apify_client import ApifyClient

# Initialize the ApifyClient with your API token
client = ApifyClient("<YOUR_API_TOKEN>")

# Prepare the Actor input
run_input = {
    "connection": {},
    "proxyConfig": {
        "useApifyProxy": True,
        "apifyProxyGroups": ["qfCaFFuCodXxAS59E"],
    },
    "rows": [],
    "staticParam": {},
}

# Run the Actor and wait for it to finish
run = client.actor("petr_cermak/mysql-insert").call(run_input=run_input)

# Fetch and print Actor results from the run's dataset (if there are any)
for item in client.dataset(run["defaultDatasetId"]).iterate_items():
    print(item)