Below article helped me to read only file.
We are running a batch job in D365FO and want to read multiple Excel files from SharePoint folder and create Sales order.
How to read multiple Excel files from SharePoint folder to D365fo x++?
Does it have to use X++? what about using Logic Apps and Odata?