Hi Rama
The following documentation will guide you through the Microsoft Graph API which is used to interact with sharepoint
https://docs.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0
You can use the Graph Connector from the Marketplace to make it a bit more easy to work with the Graph API:
https://marketplace.mendix.com/link/component/117007
Then you need to use the Graph API to retrieve data from Sharepoint, you can find more on how to do that in the Microsoft docs:
https://docs.microsoft.com/en-us/graph/api/resources/sharepoint?view=graph-rest-1.0