asked on

Show the SharePoint data on my website?

Hello,

I am missing something really basic!

I have set up a Office 356 SharePoint account and uploaded/linked a simple Access table to SharePoint site collection.

I created the website in Dreamweaver - html and CSS

What do I use/do to show the SharePoint data on my website?

If I type the address to the SharePoint site into Internet Explorer all I get is a default 365 Webpage. Can't see how I even "look" at the SharePoint data directly - can only look through a local Access DB at the moment that points to it.

Can anyone point me in the right direction. Thanks!

Lou

Louverril

ASKER

Have managed to view the data via the Office 365 SharePoint site. But still need to know how to add it to a web page on my site not hosted on 365.

Jamie McAllister

There are various ways, as Office 365 supports Web Services, REST and CSOM interfaces that can be used to bring down data. In fact even iFrames can be a possibility.

However, before all that you need to check about licensing. As I understand it, data derived from SharePoint is required to be licensed as if it were being accessed by users in SharePoint. As such I suggest you talk to someone at MS first before attempting this.

Louverril

ASKER

Surely that cannot be correct. How would any one use Access based web apps?

Jamie McAllister

Is the data in the public website part of an O365 site? (or in a section needing login?)

If needing login you might need something like this;

http://www.jeremythake.com/2014/06/using-the-sharepoint-csom-and-rest-api-with-office-365-api-via-azure-ad/

If not needing authentication it simplifies things a lot.

A lot has been happening in the SharePoint space recently, things may have changed, but I'd certainly check about the derivative licensing before proceeding if I were you.

Louverril

ASKER

Fount this - http://blogs.msdn.com/b/odatateam/archive/2009/10/21/using-data-services-over-sharepoint-2010-part-1-getting-started.aspx

But can't figure out how to do it!

Lou

Jamie McAllister

This is perhaps a simpler example, but I know of nothing that's plug and play very simple. This area of development is still having the rough edges taken off!

http://msdn.microsoft.com/en-us/library/jj164022.aspx

On that topic, there are some great code samples here, though a little complicated for your current needs;

https://github.com/OfficeDev

Louverril

ASKER

Thanks Jamie - I am trying to work through this. Slowly getting it! Will let you know!

Lou

Louverril

ASKER

From the links you gave I found some samples on MSDN. I am trying to run this:

executor.executeAsync({
url: "https://louswebsite-public.sharepoint.com/Lists/tblTestIdeaPublic/_api/SP.AppContextSite(@target)/web
/lists(guid'a290086b-2d43-4151-add4-893474a930a9')/items(2)
?@target='http://www.louswebsite.com/'",
method: "GET",
headers: { "accept": "application/json; odata=verbose" },
success: successHandler,
error: errorHandler
});

From here http://msdn.microsoft.com/en-us/library/dn531433.aspx#bk_ListItem

I can't even get it to run! Even to produce an error!.

Have tried:

<body onload="executor.executeAsync()">

executor.executeAsync({
url: "https://louswebsite-public.sharepoint.com/Lists/tblTestIdeaPublic/_api/SP.AppContextSite(@target)/web
/lists(guid'a290086b-2d43-4151-add4-893474a930a9')/items(2)
?@target='http://www.louswebsite.com/'",
method: "GET",
headers: { "accept": "application/json; odata=verbose" },
success: successHandler,
error: errorHandler
});

And a few variations.

Any suggestions?

Many thanks,
Lou

ASKER CERTIFIED SOLUTION

Jamie McAllister

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Louverril

ASKER

Thanks for your help Jamie. I won't go any further into this on EE as my subscription is about to expire! :-) After many years.... due to the price increase and EE's change of focus.

But thanks for helping me and you have given me some great pointers.

Lou