Flatten, Clean, Validate JSON | Dataford Interview Questions

Given a messy JSON payload of user application data at Bestow, write a Python script to flatten, clean, and validate the records.

Implement process_applications(payload). The input is a dictionary with an applications list. Normalize keys to lowercase snake case, flatten nested objects with dot-separated keys, trim strings, convert blank strings to None, and preserve cleaned lists. Return {"valid": [...], "invalid": [...]}. Valid records must contain a nonempty application_id, a valid email, and an integer age from 18 through 100. Invalid records contain the zero-based index and an ordered list of error messages.

Constraints

payload contains an applications list.
Each application is a JSON object containing JSON-compatible values.
Nested objects may occur at any depth.
Application IDs must be unique among nonempty IDs.
A valid age is an integer from 18 through 100 inclusive.
Boolean values do not count as valid ages.

Function Signature

def process_applications(payload):

Your question is Flatten, Clean, Validate JSON. 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

Given a messy JSON payload of user application data at Bestow, write a Python script to flatten, clean, and validate the records.

Constraints

payload contains an applications list.
Each application is a JSON object containing JSON-compatible values.
Nested objects may occur at any depth.
Application IDs must be unique among nonempty IDs.
A valid age is an integer from 18 through 100 inclusive.
Boolean values do not count as valid ages.

Function Signature

def process_applications(payload):

Your question is Flatten, Clean, Validate JSON. 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.