JavaScript Object Notation, is an open standard format that uses human-readable text to transmit data objects consisting of attribute–value pairs. It is used primarily to transmit data between a server and web application, as an alternative to XML.

learn more… | top users | synonyms

9
votes
3answers
2k views

How to avoid _metadata in a REST response (listData.svc)

I am pulling data from a SharePoint list with listData.svc, and _metadata represent more than half of the response content. Is there a way to return list fields only, without the metadata? Below an ...
6
votes
3answers
18k views

get current user info using jquery ,REST and csom

My goal is to get the login name and picture for the current user. I am using SharePoint 2013 Foundation. I tried three method and non of then worked correctly: This is with jQuery SPServices: ...
5
votes
3answers
2k views

SharePoint REST POST to upload file produces corrupted or empty file

I've got this jquery/REST process that I thought was uploading a PDF file to SPO 2013 Document library, but it's only producing an empty or corrupt. Anybody know why? function ProcessUpload(...
5
votes
1answer
3k views

Copy List items using REST/JSON

I'm very new to REST and JSON, I want to copy list items from one list to another list in the same site on button click, both the lists are of same type but with different column names and they are '...
4
votes
3answers
8k views

ajax call with SharePoint REST API to get JSON response

I am trying to GET list items from SharePoint 2013 using REST API and ajax call.It is returning by default ATOM+XML. I want the response in JSON format. I tried the following however still same XML ...
4
votes
2answers
2k views

Why is upload of JSON files prohibited?

I'm trying to build a lightweight reporting tool consisting of an HTML file that would sit in a document library and consume data from JSON files residing in the same folder. The JSON file type is ...
4
votes
1answer
1k views

Invalid JSON. A token was not recognized in the JSON content

I fetch data from Sharepoint using perl on a linuxmachine. This worked real good as long as I only had to read data from there. Now that I also have to change data on Sharepoint I'm stuck. Altough ...
3
votes
5answers
560 views

Proxy page for Office 365

I am working on an Office 365 (SharePoint Online) website, and I am looking for a way to retrieve data (xml, json) from remote sites that don't necessarily support JSON-P or CORS. I could use an XML ...
3
votes
1answer
6k views

REST post with metadata column?

I have a jquery script that uploads a file to document library. I'm trying to set a choice column in the same call, but can't seem to get it to work. The upload is working, but Col1 is a choice ...
3
votes
4answers
255 views

jQuery library that uses json within a sub-web

In my sharepoint site (Sharepoint Server Enterprise 2010), in IIS(7.5), I have a web-application that runs with Sharepoint as the parent site. Almost. So, I want to use a jQuery library called gg-...
3
votes
3answers
34 views

Changing created through REST

I was having a hard time getting my list items to POST back to the SharePoint list when I discovered if I delete the Modified and Created properties from the JSON it would work. The JSON that is being ...
3
votes
1answer
43 views

Combine SharePoint Lists in a different SharePoint Site

I have a task to create a SharePoint List that is a combination of 2 lists present on another SharePoint site. There is no admin access to this site. Is is possible to get it and manipulate it? ...
3
votes
2answers
240 views

Character escaping in CAML query (REST call)

I use JS to create a CAML query. When it is generated, it looks like this: @v1 = {"ViewXml":"<View Scope='RecursiveAll'><ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/&...
2
votes
4answers
10k views

REST service and JSON

How can I retrieve via REST service in SharePoint item column values in JSON: This is my snippet: $.ajax({ url: '/_api/web/lists/getbytitle("my list")/items/getbyid(3)', type: 'GET', header: {'...
2
votes
1answer
238 views

Get value from JSON from SharePoint REST [closed]

If I use below line, I get output='1'. data.d.results[i].ID; But instead of giving hardcoded ID, Is there any way to pass by variable? I already tried like: var array=["ID","Title"]; data.d....
2
votes
1answer
857 views

Can I use asp.net web service in Sharepoint project?

I had create .asmx webservice in asp.net projects. my doubts that is this able to use this webservice in sharepoint project? suppose this is my code source: function (request, response) { ...
2
votes
2answers
1k views

How to get JSON column names in Javascript

I have the following JSON response: { "d": { "results": [ { "__metadata": { "id": "c55209ae-2af9-4514-ab02-67f222903f6d", "uri": "https://site-...
2
votes
2answers
173 views

Dealing with JSON data in Sharepoint

I'm interviewing for a company and they asked me to put together some demos for them. They have a platform they use on top of Sharepoint and I would be working extensively in it (this is a junior ...
2
votes
2answers
1k views

Creating new items containing lookup field with listdata.svc and json

I'm calling listdata.svc with xmlhttprequest and POST to pass json. The new item is being created, but a new item is being created on the lookup list when I do, even though I am passing an existing ...
2
votes
2answers
6k views

SharePoint Cross Domain Request with jQuery

I've been going around in circles for a couple hours now to no avail. I had thought that what I wanted to do was not possible but some threads that I was reading on SO were saying otherwise so I ...
2
votes
1answer
1k views

SharePoint 2013 REST - Possible to Upload accross Site collections with embeded code or NAPA? SP.AppContextSite 403

Has anybody been able to REST Upload cross site/domain of a file to a document Library with REST on SPO 2013 thru embedded page code or NAPA? Wondering how app security is set on the TargetSite? I ...
2
votes
1answer
426 views

SP2010, Odata, anonymous access

Is anonymous access to listdata.svc possible? I'm trying to just simply get list items and display them using json but I either get asked to login or a 401 unauthorized. It's a claims based site ...
2
votes
1answer
295 views

JSon REST API. Retrieving items in lists. Workflows

Using this: http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=224 I was able to make a workflow that loops through lists. Now I understand adding ?$top=5000 at the end of my URL I can pull more ...
2
votes
0answers
24 views

Hybrid mobile SP2013 client

I already have a native iOS app that uses SP rest api without issues. My plan is to port this app into a hybrid one and make it cross platform using Cordova. Basically I want to mimic the native ...
2
votes
1answer
359 views

Use filtered URL in Ajax call to return JSON data

Currently I am working on sort of a JavaScript function library for all things SharePoint to pass around to some of the SP developers at my work. The idea is to just take some simple features I see ...
2
votes
1answer
491 views

serialize SPListItemCollection through WCF sharepoint 2013

My question is simple, how to get ( or retrieve ) json serialized SPListItemCollection through WCF service ? tried to use NewtonSoft for .Net, but it's throw an exception when try to serialized it. I ...
1
vote
2answers
7k views

Getting an ItemCount with filtering in SP2013 using REST api

I am attempting to return an integer (itemcount) of the items within a SP2013 list. I have done this easily using the stock standard json method. However I have a need of counting the splist items ...
1
vote
3answers
103 views

Tool to inspect json data returned from REST API call to Sharepoint online/Office365 Sites

What tool should I be using to inspect the JSON data returned as a result of making a rest api call to the sharepoint online or Office365 site. The browsers return xml and I am having issues using ...
1
vote
2answers
453 views

Set Managed Metadata Values via REST

I am able to query and get an array of all my term names and guids within a Term Set, but now I want to be able to set these via REST. When I look at the structure in JSON the section with my Managed ...
1
vote
1answer
70 views

Choice field values returning as string with “\n”. How to get collection?

While parsing data returned from REST, the Choice field values are returning as Edm.string with "\n". I want the results in collection(Edm.string). Current result : {"__metadata": {"type":"...
1
vote
1answer
55 views

Retrieve the Item ID from the Task List Related Item column

Using JSOM, I getting all the task details which are not started. Using CAML query i got all the column values including related item column from Task list var relateditm = $(this).attr("...
1
vote
2answers
129 views

Sharepoint 2010 Blog - Order rest query by Category

I've created a blog on Sharepoint 2010 and want to query the list via REST for reporting. I want to order the list by the default field Category (internal name PostCategory). Unfortunately, this is a ...
1
vote
1answer
493 views

Could not load file or assembly Newtonsoft.Json or one of its dependencies. The system cannot find the file specified

I am using Newtonsoft.Json assembly for Deserializing Json response. Solution builds fine, deploys fine. But when the json response is to be deserialized, I get "Could not load file or assembly '...
1
vote
2answers
22k views

Create json data dynamically from list using javascript

Can anyone tell me how to generate json data from SharePoint lists in the below format using java script. var jsonArray = [ { "user": { "id": 100, "screen_name": "d_linq" } }, { "user": { "id"...
1
vote
2answers
2k views

JSON file is not served

In a standard team site, I have a document library that host a static website with html files as well json files loaded asynchronously with javascript. This was working well in SharePoint 2007. ...
1
vote
1answer
2k views

JavaScript in CEWP does not execute

After putting a small script together and pasting it into the Content Editor Web part all my breakpoints show the following warning in IE 8's debugger: "The breakpoint is not valid. No executable code ...
1
vote
1answer
162 views

Sharepoint restful api: json return value is structured differently between simialr scripts

I have some odd behaviour when using REST API to query SharePoint lists. In one example, I have to use data.d.results[0] to get to the data, in another I have to use data.d[0] When I use data.d[0], ...
1
vote
1answer
615 views

SharePoint Online 2013 Page Code Embed and Javascript - output disappears

I noticed I can't embed inline javascript in an SPO 2013 Web Part page, but can reference a library. I'm outputting a table from that js. If I put alerts that table displays but then disappears ...
1
vote
1answer
342 views

JSON Viewer WebPart

Is there a JSON Viewer webpart that functions in a similar manner to XML Viewer? Should I just use a DataView Webpart?
1
vote
1answer
705 views

Create C# web service that returns SharePoint ListCollection

I want to create a WebService that returns the SharePoint ListCollection in JSON format. I have tried by using following code: ClientContext ctx = new ClientContext("mySite"); ctx.Credentials = new ...
1
vote
1answer
847 views

accessing remote web services(cross domain applications) using jquery jsonp

Here is My code ..could anyone please solve this problem..I was struggling from morning..below code is not working.Actually i should get the data when we send jasondata as input..but i am getting ...
1
vote
0answers
17 views

SharePoint Designer 2013 Send e-mail with specified FROM address

I tried to recreate a workflow in SPD2013 following advice there link It was Call HTTP Web service action that recreates JSON code. When I run this site workflow, I don't get any e-mails. I traced the ...
1
vote
2answers
33 views

How can I populate a dropdown with a SP list?

I have a SP List with data that I need to be in a dropdown list. I also need these to have specific classes. I'm trying something like the following but having no luck: $().SPServices({ ...
1
vote
1answer
65 views

Send JSON Payload in RequestContent of HttpSend with POST in SharePoint 2013 Workflow in Visual Studio

I have a SharePoint 2013 Workflow in Visual Studio. I need to call an external Web API using POST and send some JSON payload. I couldn't find any proper documentation to achieve it. Can anyone please ...
1
vote
0answers
56 views

Read user field via Javascript/REST: Some users are NULL

I have a simple list with a simple user field. I can assign users, save the item and everything was working fine... ...until I tried to access the list via REST call within a Javascript. Some of the ...
1
vote
0answers
120 views

Sharepoint 2013 Hosted App. Access-Control-Allow-Origin - Access Denied

I am working with SharePoint 2013 and I developed some app parts to show information in our intranet. These app parts get data from WEB API using jQuery, It works fine in Chrome, Firefox, but in ...
1
vote
2answers
149 views

SP2013 Toolbar keeps loading invalid http json response headers for commandui.ashx

Dear smart people out there, we published SP2013 via UAG 2010 sp4. The toolbar keeps showing 'Loading ...' In javascript there is a Deserialization error. My http response for the commandui.ashx ...
1
vote
0answers
992 views

Syntax for including maxJsonLength in a standalone web.config for a Sharepoint Farm solution?

We encountered the following error in Javascript in a Sharepoint project: Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the ...
1
vote
0answers
479 views

How to configure SharePoint REST API to return JSON by default?

I'm using a 3rd party HTTP client to retrieve data from SharePoint. I want to get the result in JSON format. I know one method is to add the header "Accept": "application/json; odata=verbose" However,...
1
vote
0answers
396 views

how to pares search api odata json result in C#

i'm using that search query string siteUrl = "<site>"; string queryText ="Path:\"pathTosearch/*\" IsDocument:1"; string rowlimit = "10"; string sortExpression = "Write:descending"; ...