We have a requirement in SharePoint Online to create list view that can view more than 100,000 items. We have a custom list synchronization with email, and there are more than 16,000 item creates every day at this list.
I know that the maximum list view limit is 5000 items, but I want to know if there is any way or third party to allowed to view all items of current month in one view?
What if I use external data base of another website and access by API services? I want to know how can I access with this external database and execute commands like insert items to external DB, updates, query by workflow when items are created?
Can I do it By HTTP action that is in SP Designer 2013?