Query a SharePoint list with JavaScript

Question

I am a new SharePoint developer, and I am finding SharePoint to be a bit difficult. I have been looking for a way to query a SharePoint 2013 list with JavaScript for a while now, and I can't find an clear solutions.

What I am trying to do is to validate if an entered email address exists in my "subscription list". This will occur every time a certain button is clicked. The validation will happen in a modal view which I am yet still trying to create.

Some of the posts I have seen online talk about the sp.js file which I am not sure where I will find. Also, are the some good tutorials for SharePoint 2013.

Ever tried camelotjson.codeplex.com?

Eric Herlitz
– Eric Herlitz

2014-05-04 07:59:04 +00:00
Commented May 4, 2014 at 7:59 — Eric Herlitz
– Eric Herlitz, Commented May 4, 2014 at 7:59

Community · Accepted Answer · 2017-04-13 12:41:19Z

2

Include SP.js, SP.Runtime.js and Microsoft.Ajax.js. Your JavaScript could look like this (using jQuery for convenience ...):

$.ajax({
  url: "http://<DomainName>/<PathToWeb>/_api/web/lists/GetByTitle('<ListTitle>')/items",
  type: "GET",
  headers: {
    "accept": "application/json;odata=verbose",
  },
  success: function(data){
      $.each(data.d.results, function (key, value) {
        $("#ParentContainerId").append($("<pre></pre>")
                              .html(value.Title);
      });
  },
  error: function(error){
    alert(JSON.stringify(error));
  }
});

n.b. If you need other fields than ID or Title, you must include them in a select statement at the end of the request URL using the InternalName as described here:

?$select=FileLeafRef

There are more examples on how to retrieve and work with SharePoint ListItems using REST in the MS TechNet and a good documentation of the REST API in MSDN.

edited Apr 13, 2017 at 12:41

CommunityBot

11 silver badge

answered May 4, 2014 at 13:26

Markus

3,4116 gold badges38 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrei Over a year ago

Please add more details to your answer, even if it is copy-pasted and quoted from that link. A short description would work also. As it is not it is a link-only answer and it is not admitted.

Yevgeniy.Chernobrivets · Accepted Answer · 2014-05-04 08:53:01Z

1

There are two major ways to query SharePoint data using javascript: 1) Javascript Client Object Model. In this case you will need to add SharePoint javascript libraries which are located on SharePoint server in layouts virtual folder. 2) REST services.

answered May 4, 2014 at 8:53

Yevgeniy.Chernobrivets

3,1942 gold badges15 silver badges14 bronze badges

Comments

stockholmux · Accepted Answer · 2014-05-03 23:30:07Z

0

I used SPServices successfully for years (although I don't do Sharepoint currently and I have only worked with 2007/2010).

I believe you are looking for GetListItems more specifically.

answered May 3, 2014 at 23:30

stockholmux

1,22513 silver badges25 bronze badges

Collectives™ on Stack Overflow

Query a SharePoint list with JavaScript

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related