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

Fetch and parse JSON from REST API

Last updated: Mar 29, 2026

Quick Overview

This question evaluates practical skills in HTTP/REST integration, JSON parsing, authentication, pagination, rate limiting and retry strategies, timeout and malformed-record handling, data transformation into target schemas, unit testing, and logging.

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

Fetch and parse JSON from REST API

Company: Motive

Role: Software Engineer

Category: Data Manipulation (SQL/Python)

Difficulty: Medium

Interview Round: Onsite

Set up a minimal development environment and write code that performs an HTTP GET to a given REST endpoint returning JSON. Parse the response and extract specified fields (e.g., order_id, courier_id, latitude, longitude, timestamp), handling authentication, pagination, rate limiting (e.g., backoff/retry), timeouts, and malformed records. Transform the data into a required schema and output it as CSV/JSON. Include basic unit tests and demonstrate error handling and logging.

Quick Answer: This question evaluates practical skills in HTTP/REST integration, JSON parsing, authentication, pagination, rate limiting and retry strategies, timeout and malformed-record handling, data transformation into target schemas, unit testing, and logging.

Related Interview Questions

  • Fetch and process JSON from REST API - Motive (Medium)
Motive logo
Motive
Aug 13, 2025, 12:00 AM
Software Engineer
Onsite
Data Manipulation (SQL/Python)
3
0

Set up a minimal development environment and write code that performs an HTTP GET to a given REST endpoint returning JSON. Parse the response and extract specified fields (e.g., order_id, courier_id, latitude, longitude, timestamp), handling authentication, pagination, rate limiting (e.g., backoff/retry), timeouts, and malformed records. Transform the data into a required schema and output it as CSV/JSON. Include basic unit tests and demonstrate error handling and logging.

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.