topic OLEDB Connection string with authorization in Product Forum

OLEDB Connection string with authorization

MateuszWojcik — Thu, 29 Jul 2021 10:20:00 GMT

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
------------------------------

RE: OLEDB Connection string with authorization

ewilson — Thu, 29 Jul 2021 12:02:00 GMT

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
------------------------------

RE: OLEDB Connection string with authorization

MateuszWojcik — Fri, 06 Aug 2021 09:54:00 GMT

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
------------------------------

RE: OLEDB Connection string with authorization

ritansh.jatwani — Fri, 06 Aug 2021 11:21:00 GMT

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
------------------------------

RE: OLEDB Connection string with authorization

ewilson — Fri, 06 Aug 2021 14:17:00 GMT

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
------------------------------

RE: OLEDB Connection string with authorization

ewilson — Fri, 06 Aug 2021 14:22:00 GMT

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
------------------------------