September 19, 2017 at 5:22 am
We have an issue (using the ODATA connector) whereby we cannot extract data that is sourced from a multi value check box in SharePoint, all other data is returned ok - but this data isnt.
We originally began devleopment using the standard SharePoint connector but then faced authentication issues when the job was deployed to the server (due to Kerberos etc) - I understand NTLM authentication was chosen when the farm was first set up, at this stage we dont want to change the authentication mode. So we switched to using the ODATA connector. At this stage i am not aware of any other third party connectors to try.
What other options do i have to deal with these multi value check boxes?
Thanks
October 5, 2017 at 5:41 am
To update this and hopefully help others, a ugly workaround is to export to Excel (retaining the connections) and using Excel as the SSIS source to bring these multi value check boxes in just fine.
Then deal with the regular refresh of the Excel workbook by using PowerShell.
All was rosy , until i then came across a SharePoint list which has a child page in the list which isnt captured in the Excel output - so currently back a the drawing board.
October 5, 2017 at 7:59 am
wannabe_developer - Tuesday, September 19, 2017 5:22 AMWe have an issue (using the ODATA connector) whereby we cannot extract data that is sourced from a multi value check box in SharePoint, all other data is returned ok - but this data isnt.We originally began devleopment using the standard SharePoint connector but then faced authentication issues when the job was deployed to the server (due to Kerberos etc) - I understand NTLM authentication was chosen when the farm was first set up, at this stage we dont want to change the authentication mode. So we switched to using the ODATA connector. At this stage i am not aware of any other third party connectors to try.
What other options do i have to deal with these multi value check boxes?
Thanks
I've read your 2nd post, but what you're saying is that that a particular data item (sourced from said checkbox) is not being returned, while all other data is, but you didn't say exactly how it isn't being returned. We need a little more detail, such as whether or not there's a table with that field in it that your query accesses, or if you've tried accessing that table directly from within SSMS, or any other technical details. We kinda need that stuff to be able to help you.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply