Fetch and process JSON from REST API

Q: Fetch and process JSON from REST API

This is a Data Manipulation (SQL/Python) interview question from Motive for Software Engineer roles. View the full question and solution on PracHub.

Q: How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

Question

Given a REST endpoint that returns a JSON payload, set up a coding environment, perform an HTTP GET, parse the JSON, and extract specified fields to produce a required output (e.g., aggregates per category and the top-k items). Write runnable code that handles pagination, rate limits, retries with backoff, timeouts, and malformed/partial data. Explain your approach, edge cases, and time/space complexity.

Fetch and process JSON from REST API

Comments (0)