[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Show the SharePoint data on my website?

Posted on 2014-08-22
10
Medium Priority
?
223 Views
Last Modified: 2014-09-01
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
0
Comment
Question by:Louverril
  • 6
  • 4
10 Comments
 

Author Comment

by:Louverril
ID: 40278620
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
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40278648
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
 

Author Comment

by:Louverril
ID: 40278655
Surely that cannot be correct. How would any one use Access based web apps?
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40278678
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
 
LVL 32

Expert Comment

by:Jamie McAllister MVP
ID: 40278751
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
 

Author Comment

by:Louverril
ID: 40278907
Thanks Jamie - I am trying to work through this. Slowly getting it! Will let you know!

Lou
0
 

Author Comment

by:Louverril
ID: 40279261
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
 
LVL 32

Accepted Solution

by:
Jamie McAllister MVP earned 2000 total points
ID: 40283222
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
 

Author Closing Comment

by:Louverril
ID: 40296691
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
The first step to building an amazing About page is to figure out what you want the page to say about your company. You then must grab the attention of the reader, boast a bit, tell a story and let others brag about you. With a little bit of thought…
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question