Consume an API and Output CSV | Dataford Interview Questions

Consume an API and convert to CSV file.

Asked in the technical interview stage. Practical coding task in the Andela technical interview.

Implement a deterministic, testable version without making network requests. The input is an ordered list of API page objects, each containing an items array of flat JSON records. Return one CSV string. Build the header from keys in first-seen order across all records, leave missing values empty, and correctly escape commas, quotes, and newlines using standard CSV rules.

Signature: def api_pages_to_csv(pages):

Output: A CSV string with one header row and one row per record. Use line endings and return an empty string when there are no records.

Constraints

pages is an ordered list of page objects
Each page contains an items list
Each item is a flat JSON object with string keys
There can be up to 10^5 total records and 50 columns
Values are strings, numbers, booleans, or null
Return an empty string when all pages contain no records

Function Signature

def api_pages_to_csv(pages):

Your question is Consume an API and Output CSV. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem