Some of the Sharepoint Lists we want to connect to have multiple views defined. At least on one list, it's default view is filtered (i.e. showing only non-completed values).
To transfer all the list's items (and not only those in the default view), we have to figure out the ID of AllItems.aspx, which always shows all items of said list.
Addition: We also had issues on larger Sharepoint lists taking a long time to load. Therefore a custom page size option has been added as well.
Some of the Sharepoint Lists we want to connect to have multiple views defined. At least on one list, it's
default
view is filtered (i.e. showing only non-completed values).To transfer all the list's items (and not only those in the
default
view), we have to figure out the ID ofAllItems.aspx
, which always shows all items of said list.Addition: We also had issues on larger Sharepoint lists taking a long time to load. Therefore a custom page size option has been added as well.
This PR therefore adds/changes the following:
python-connectors/sharepoint-online_lists/connector.json:
advanced
parameterUse All Items view
(default:False
)advanced
parameterPage Size
(default:30
as would be without parameter as well)python-lib/sharepoint_client.py:
get_list_allitems_view_url()
to build the URL required to download all available views for a given listget_list_allitems_view_id()
to return a dictionary withview id
if a non-default view is requiredget_view_query_string()
to return a combined query string with all relevant parameters.view id
if available (default parameter)paging
size if available (default parameter)NextHref
python-connectors/sharepoint-online_lists/connector.py:
get_next_page_query_string()
to combineNextHref
with default parametersIf you have any suggestions please let me know.
Best regards, Richard