OLEDB Connection string with authorization

[MateuszWojcik]

Hi,

I use OLEDB to connect the SharePoint List table. Before first connection I have to open SharePoint List on IE to get authorization.

Do you know the way to get authorization directly in the connection string?
Do you know other tool that helps me download data from table without opening Sharepoint list using IE?


Connection string:
"Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;DATABASE=" & [C_Constants.T_SHP_Summary_List_Name]& ";LIST=" & [C_Constants.T_SHP_Summary_List_ID] & ";

Thank you in advance

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

[ewilson]

Hi Mateusz,

You might take a look at the MS Graph for SharePoint integration available on the DX. It includes several actions for working directly on SharePoint Lists.

https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint

Cheers,
​

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[MateuszWojcik]

Hi Eric,

Thank you for your help.

MS Graph is right now not an option for us.

I am looking for other solution.

Kind regards

------------------------------
Mateusz Wojcik
RPA Programist
Rockwell Automation
Europe/Warsaw
------------------------------

[ritansh.jatwani]

Hi @Mateusz Wojcik,

Are there any API's available for performing the task?​

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

[ewilson]

I'm not sure there's any way to work around the browser prompt w/o moving to Graph or using some of the older SharePoint access libraries. I did come across a really old post shown below, but it sounds like this may be what you're already doing. There seem to be quite a few posts online over the years of people trying to include credentials in an OLEDB connection string for connecting to a SharePoint list, but not many answers. 😞



Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

[ewilson]

You mentioned Graph wasn't an option. What about the default SharePoint REST API?

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=csom

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------