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
LouverrilAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LouverrilAuthor Commented:
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.
0
Jamie McAllister MVPSharePoint ConsultantCommented:
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.
0
LouverrilAuthor Commented:
Surely that cannot be correct. How would any one use Access based web apps?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jamie McAllister MVPSharePoint ConsultantCommented:
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.
0
LouverrilAuthor Commented:
0
Jamie McAllister MVPSharePoint ConsultantCommented:
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
0
LouverrilAuthor Commented:
Thanks Jamie - I am trying to work through this. Slowly getting it! Will let you know!

Lou
0
LouverrilAuthor Commented:
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
0
Jamie McAllister MVPSharePoint ConsultantCommented:
You need to get hold of the executor object from SP.RequestExecutor.js

There's a more complete sample here which shows how to reference it;

http://sharepoint.stackexchange.com/questions/109679/getting-list-with-rest-service-to-html-page-on-different-domain

This might also be useful;

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

However I'm concerned the cross domain permissions part of your task might be difficult.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LouverrilAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
HTML

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.