MySQL to WPS icon

MySQL to WPS

Export data from MySQL to Kingsoft WPS with batch processing

Export to WPS

AI-generated

Summary

Execute a MySQL SQL query and export the resulting data in batches to a specified sheet in Kingsoft WPS via its API.

Inputs

  • SQL Query (required) — The MySQL SQL query to run to retrieve data for export.
  • Sheet Name (required) — The target sheet name within Kingsoft WPS where data will be exported.
  • WPS API URL (required) — The endpoint URL of the Kingsoft WPS API to receive the exported data.
  • WPS API Token (required) — Authentication token ('AirScript-Token') used to authorize requests to the WPS API.
  • Options — Additional settings including batch size (rows per request, 1000-50000, default 20000), request timeout in milliseconds (default 120000), debug output enable flag, and max characters for debug output.

Output shape

a single JSON object with export summary

The output object indicates success status, total rows retrieved, sent rows, failed rows, total batches processed, and a message summarizing the export result including rows per second. In case of no data, total rows and sent rows will be zero. Errors are thrown or can be captured if workflow is set to continue on fail.

Discussion