Paginated API with Threads | Dataford Interview Questions

An Api is given which is paginated. (Response will not come at once instead you have to call the api with different page numbers in query parameter). You have got K number of threads available write a code which calls this api and returns the whole response.

Asked in the Round 4 (Hiring manager) stage. For this SQL version, the API fetch results are stored by run, page, and item.

Output

Return one row per item from completed runs where every expected page exists and succeeded.
Include run_id, page_number, item_position, and response_payload.
Order by run_id, page_number, and item_position ascending.

Schema

api_runs

Column	Type	Description
run_idPK	INT	Identifier for one complete API retrieval attempt
expected_pages	INT	Number of pages expected for the run
run_status	VARCHAR(20)	Overall status of the API retrieval run

api_pages

Column	Type	Description
run_idPK	INT	API run identifier
page_numberPK	INT	Page number requested from the API
fetch_status	VARCHAR(20)	Result of fetching the page

api_items

Column	Type	Description
run_idPK	INT	API run identifier
page_numberPK	INT	Page containing the item
item_positionPK	INT	Item position within the page
response_payload	VARCHAR(255)	Text representation of the API item payload

Your question is Paginated API with Threads. Start with the requirements and the three 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.

Problem