OData - Service Document Location

2016-07-07

Question

_{Thursday, July 7, 2016 5:38 AM}

Hi,

This my attempt at trying to use the Odata source in SSIS and need to specify the service documentation location. How do I create this from my SharePoint URL? There doesn't seem to be detailed anywhere in a clear fashion.

https://mycompany.sharepoint.com/sites/Lists/Portfolio%20Management%20Master/Portfolio%20Management%20Master%20%20Submitted%20By.aspx

Thanks

All replies (5)

_{Friday, July 8, 2016 1:55 AM ✅Answered | 1 vote}

Hi Cameronh,

The Service document location is the OData endpoint. It takes the form of the URL of the site, along with the suffix /_vti_bin/listdata.svc.

For example, if your site is http://sharepoint/sites/team, the service document location is http://sharepoint/sites/team/_vti_bin/listdata.svc.

More information:

http://whitepages.unlimitedviz.com/2014/03/using-the-odata-source-connector-with-sharepoint-online-authentication/

Thanks,

Wendy

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Friday, July 15, 2016 8:44 AM}

Hi Cameronh,

Do you have any update for this issue?

Thanks,

Wendy

_{Tuesday, July 19, 2016 9:41 AM}

I am still trying to work out the SVC link required from the URL.

_{Wednesday, July 20, 2016 8:24 AM}

Hi Cameronh,

Do you have a try as my suggestion?

If yes, please let's know the result.

Thanks,

Wendy

_{Wednesday, July 27, 2016 9:25 AM}

Hi,

Do you have any update for this issue?

Thanks,

Wendy

Share via

OData - Service Document Location

Question

All replies (5)

Additional resources