PracHub
QuestionsPremiumLearningGuidesCheatsheetNEWCoaches
|Home/Data Manipulation (SQL/Python)/Motive

Fetch and process JSON from REST API

Last updated: Mar 29, 2026

Quick Overview

This question evaluates a candidate's ability to implement robust API integration and data processing, including HTTP requests, JSON parsing, pagination, rate limiting, retries with backoff, timeouts, handling malformed or partial data, and performing aggregations and top-k computations.

  • Medium
  • Motive
  • Data Manipulation (SQL/Python)
  • Software Engineer

Fetch and process JSON from REST API

Company: Motive

Role: Software Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: Medium

Interview Round: Onsite

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.

Quick Answer: This question evaluates a candidate's ability to implement robust API integration and data processing, including HTTP requests, JSON parsing, pagination, rate limiting, retries with backoff, timeouts, handling malformed or partial data, and performing aggregations and top-k computations.

Related Interview Questions

  • Fetch and parse JSON from REST API - Motive (Medium)
Motive logo
Motive
Sep 6, 2025, 12:00 AM
Software Engineer
Onsite
Data Manipulation (SQL/Python)
1
0

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.

Comments (0)

Sign in to leave a comment

Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More Motive•More Software Engineer•Motive Software Engineer•Motive Data Manipulation (SQL/Python)•Software Engineer Data Manipulation (SQL/Python)
PracHub

Master your tech interviews with 7,500+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.