Oracle Visual Builder: Applications That Outlive Their First Release · Module 6 · Connecting to Fusion
Pagination, properly
Lesson 60 of 176 · 3 min
What the API RETURNS, what your table EXPECTS, and THE APPLICATION THAT WORKED ON TWENTY ROWS AND STOPPED AT TWO THOUSAND. This is the defect that is most certain to happen and least likely to be caught before production, because the difference between right and wrong is invisible on test data. A FUSION LIST ENDPOINT RETURNS A PAGE, NOT A LIST. A default number of rows, an offset, and a flag saying whether there are more. Your table is bound to whatever came back, so on twenty-five rows with a default of twenty-five, the page shows everything and is perfect. THE FAILURE IS THAT IT STAYS PERFECT-LOOKING WHEN IT IS WRONG. At two thousand rows the page shows twenty-five, with no message, no scrollbar hint, and no indication that anything is missing. Lesson 12's second failure, and it is reported as "the report is missing records" rather than as a…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Visual Builder: Applications That Outlive Their First Release, with a certificate on completion and a fourteen-day refund window.
In this module: Module 6 · Connecting to Fusion
- 1What a service connection is
- 2Creating one against a Fusion REST APIFree preview
- 3Authentication, and whose identity is used
- 4Why a shared service account is usually wrong
- 5Query parameters, filtering and fields
- 6Pagination, properly
- 7Writing back to Fusion
- 8When the shape changes underneath you
- 9Calling an OIC integration instead
- 10Handling a service that is down
- 11CORS and the errors it produces
- 12What breaks: four connection failures
- 13Lab briefing · Connect, over-fetch, then fix it
