Call APIs and Aggregate Data | Dataford Interview Questions

Some questions about calling APIs, parsing the data, then using some sort of aggregation to display the data.

Using the parsed API request and record tables, produce a daily summary for successful requests only.

Output

Return one row per endpoint and request date with endpoint, request_date, parsed_record_count, total_value, and average_value.
Include successful requests with no parsed records, using zero for the count and total and NULL for the average.
Sort by request_date, then endpoint.

api_requests

Column	Type	Description
request_idPK	INT	Unique identifier for an API request
endpoint	VARCHAR(100)	API endpoint that was called
requested_at	TIMESTAMP	Timestamp when the request was made
http_status	INT	HTTP response status code

api_records

Column	Type	Description
record_idPK	INT	Unique identifier for a parsed API record
request_id	INT	API request that produced the parsed record
record_type	VARCHAR(50)	Type of parsed record
value	NUMERIC(10,2)	Numeric value extracted from the API response

Your question is Call APIs and Aggregate Data. Start with the requirements and the two tables 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.