Excel Add-In for Confluence

Build 26.0.9770

FetchMissingRows

Specifies whether the provider retrieves records that are missing from incomplete pages when paging through tables that use client-side pagination.

Data Type

bool

Default Value

true

Remarks

This property applies only to tables that use client-side (offset-based) pagination. This includes most Confluence Data Center and Server tables, as well as the Users table on Confluence Cloud. It has no effect on tables that use cursor-based pagination, which includes the other Confluence Cloud tables.

While paging through results, the add-in compares the number of records in each page with the page size and with the total number of records reported by Confluence. A page is incomplete when it contains fewer records than expected, including a page that contains no records at all. The add-in retries an empty page several times before treating it as incomplete and abandoning retrieval of the missing records.

When set to true, the add-in tries to retrieve the records that are missing from incomplete pages, so that the query returns the full result set.

When set to false, the add-in does not attempt to retrieve missing records. It continues paging through the remaining results, so the result set might not include every record.

Set this property to false if you prefer shorter query execution time over a complete result set.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770