WPS to MySQL icon

WPS to MySQL

Import data from Kingsoft WPS to MySQL database with incremental import support

Import from WPS

AI-generated

Summary

Import data from a specified Kingsoft WPS sheet into a MySQL table incrementally by fetching, processing, and batch-inserting only new records based on unique key fields.

Inputs

  • WPS API URL (required) — The Kingsoft WPS API endpoint URL to fetch the sheet data from.
  • WPS API Token (required) — The AirScript-Token for authenticating requests to the WPS API.
  • Sheet Name (required) — The name of the sheet in WPS to import data from.
  • Target Table (required) — The MySQL table in database.table format where data will be imported.
  • Unique Key Fields (required) — Comma-separated field names used to identify unique records for incremental import, preventing duplicates.
  • Allowed Fields (required) — Comma-separated list of field names to import from the WPS data.
  • Options — Optional settings including batch size for inserts (default 1000), request timeout in ms (default 30000), additional JSON parameters to send to WPS API, and debug output flag.

Output shape

a single JSON object per input item containing import statistics and status

The output object includes success boolean, counts of total WPS rows fetched, existing rows in DB, incremental rows imported, number of batches processed, duration in milliseconds, and a message. Errors emit failure objects if 'Continue On Fail' is enabled.

Links

Discussion