AI coding mission · API to CSV

Generate a Python script that exports API data to CSV

Turn a JSON API response into a repeatable CSV export. Describe the endpoint, response shape and columns you need, and use a PlushCrew Mission to create the project. The agents can work on fetching, field mapping and tests while you follow progress. Preview the files and test output before downloading the ZIP.

Try this mission free

Fills the task box; you choose when to send. Guest access: 1 mission per IP in a rolling 24 hours.

Describe the result you need

Include a fictional example response and explain where the list of records lives inside it. Map nested fields to explicit CSV columns, and say how to represent missing values and arrays. Pagination may use a page number, cursor or next-page URL; identify the API’s pattern rather than asking the agents to guess. Keep credentials out of the prompt and generated source.

Example prompt

Create a Python script that fetches JSON from a public API and exports selected fields to CSV. Support pagination, explicit timeouts, bounded retries, and missing fields. Use an environment variable for any API key and test with mocked responses.

Example project files and output

The exact files depend on your request. A project for this prompt could include:

api_to_csv.pyA configurable fetch-and-export command with field mapping.
tests/test_api_to_csv.pyMocked-response tests for pagination, errors and missing values.
README.mdSetup, environment variables and an example export command.

id,name,status
101,Example Project,active
102,Another Project,paused

Illustrative output from fictional JSON records. No live API request is made by this example page.

What to check in the tests

Review the test output in the mission report and open the generated test files. Useful checks for this task include:

Pagination finishes without duplicating or dropping records.
The exporter handles empty responses, missing fields and HTTP errors explicitly.
Retries are bounded and secrets are read from configuration rather than embedded in code.

Passing tests show what the supplied cases covered. They do not guarantee that every input will work or that generated code is safe.

Inputs and limitations

API quotas, permissions and response schemas vary by provider. Mocked tests validate the export logic, not your production credentials or a provider’s current availability. Review the instructions, configure your own credentials locally when required, and try the project on a small response before scheduling larger exports.

Review first, then download

Use Mission for a new project. The existing agent pipeline, sandbox and logic checks run as usual. Open each file in the browser, expand the report to inspect test results, then download the ZIP to use the project locally. A dispatched guest mission consumes the free slot even if it fails or you cancel it.

Chat is for questions; guests have five messages per IP in a rolling 24-hour window. For fixing an existing codebase, Audit accepts a code ZIP from a Pro Max account. See plans and limits for account details.

Fill this example task