To call an API and extract data | Dataford Interview Questions

To call an API and extract data.

Assume the API response data has already been staged in the api_records table. Write a SQL query to return only successfully extracted records that contain a value.

Output

One row per qualifying API record
Columns: record_id, endpoint, record_key, record_value, extracted_at
Order by extracted_at ascending, then record_id ascending

Schema

api_records

Column	Type	Description
record_idPK	INT	Unique identifier for the staged API record
endpoint	VARCHAR(255)	API endpoint that produced the record
response_status	VARCHAR(20)	Processing status of the API response
record_key	VARCHAR(100)	Key identifying the extracted field
record_value	TEXT	Value extracted from the API response
extracted_at	TIMESTAMP	Timestamp when the API record was staged

Your question is To call an API and extract data. Start with the requirements and the one table 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