1. Flattening API Response for Spreadsheet Import
Data AnalystBackground
An analyst received a deeply nested JSON response from a REST API containing user profile data.
Problem
The nested structure cannot be directly imported into a flat CSV report.
How to use
Paste the JSON, select 'Dot Notation' as the strategy, and set the delimiter to a period.
strategy: dot, delimiter: ., includeArrays: trueOutcome
A clean, flat list of keys like 'user.profile.id' and 'user.profile.email' ready for spreadsheet import.