Follow

How to get data from an Office 365 Sharepoint List into your Data Warehouse (video)

Author: Thomas Lørup Duun Last updated:
tx2014 ssis sr2 sharepoint office365 office_365

In this 10 minute video you can see how you can connect to your Office 365 Sharepoint and retrieve data from a list into your TX solution.

How to get data from an Office 365 Sharepoint List into your Data Warehouse

Was this article helpful?
0 out of 0 found this helpful

5 Comments

Date Votes
  • 0
    Avatar
    Jason Page

    Hi, this video seems to address exactly what i need to do. however, i don't seem to see the "data tools" option in the choose editor for the SSIS customized code - do i need any pre-requisites for this to work?

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Jason,

    You can setup Data Tools as a Custom Editor in General Settings. 

  • 0
    Avatar
    Jason Page

    awesome! that worked perfectly!! now to just get the list to show up.. any idea why i might be getting this error - i get this when i try to browse the listdata.svc/ListName.

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
    <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
    <code/>
    <message xml:lang="en-ZA">An error occurred while processing this request.</message>
    </error>
     
    It's only 1 of the particular lists (the one i want) - all the others work fine? are there any components of a list that might prevent it from working properly?
  • 0
    Avatar
    Thomas Lørup Duun

    Hi Jason,

    That is a good question that I unfortunately are unable to give you an exact answer to. 

    It could be that a duplicate fieldname exists due to some white-space removals - see here: https://nearbaseline.com/2014/09/odata-error-processing-this-request/

    This one could also be relevant: http://sharepoint.stackexchange.com/questions/174088/listdata-svc-returns-an-error-occurred-while-processing-this-request-for-some

    Happy hunting - and please update this thread with your findings! Thanks!

    Edited by Thomas Lørup Duun
  • 0
    Avatar
    Jason Page

    thanks for help, it's been great!

Please sign in to leave a comment.