This is the job you will actually do in the real world: pull data from an authenticated, paginated API, reshape it, and load it somewhere. Build it in n8n.
- Authenticate with an OAuth2 client-credentials credential (see the OAuth2 lesson).
- Call /playground/data/stocks/candles?shape=flat&page_size=50 with pagination turned on, following pagination.next until null.
- Use a Split Out node to flatten the data array into individual rows.
- Load the rows into a destination — Google Sheets, Postgres, or wherever your real target is.
The pre-built "Capstone" workflow in the n8n Cookbook wires steps 1–3 for you; import it, add your OAuth2 credential, and run.
Tip · A student who can build this can walk into any real developer portal — Stripe, Shopify, Razorpay, Zerodha Kite — and immediately know how to authenticate and consume its API. That is the whole point.