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

7
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 ...
5
votes
3answers
15k 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
1k 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 ...
5
votes
1answer
2k 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
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
557 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
3answers
7k 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 ...
3
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 ...
3
votes
4answers
249 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 ...
3
votes
3answers
33 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
167 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 ...
2
votes
4answers
9k 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
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 ...
2
votes
1answer
839 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
796 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": ...
2
votes
2answers
161 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
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
423 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
172 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
23 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
300 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
455 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
5k 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
2answers
394 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
2answers
114 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
2answers
19k 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": { ...
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
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 ...
1
vote
1answer
134 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
579 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
316 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
668 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
822 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
1answer
29 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
46 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
92 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
132 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
921 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
448 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" ...
1
vote
0answers
371 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"; ...
1
vote
0answers
41 views

Exporting document content from SP2013 to external webapp

How should I do to make a document viewable on a webpage, that is exported from SP2013 document library. A user should be able to, through a webpage send a request to view the content of a specific ...
0
votes
3answers
313 views

Problems while Accessing SharePoint List items in SharePoint 2013 using REST API in NAPA tool

I am trying to access the list item using an APP in my office 365 share point hosted trial environment.It seems like the call REST call is failing, the alert in error function is getting executed. ...
0
votes
1answer
666 views

Return JSON rather than XML in a Sharepoint 2013 App (JSOM)

Is it possible to return JSON when using the following code. Trying to integrate DynaTable into app to handle all the sorting and filtering and I think JSON might get it to work. // This function ...
0
votes
2answers
80 views

Is JSON disabled in SP 2013?

I have this code to display a share price which we embed in a script editor webpart and it works fine on SP2010 but not SP2013 - it just simply never refreshes. Is Json blocked by default? BTW I've ...
0
votes
2answers
206 views

How to elevate permission in JSOM code to access SharePoint list?

How to elevate permission in JSOM code to get permission to do Add/Edit/Update operation on SharePoint list? (similar to RunWithElevatedPriviledges in SSOM). If elevation is not possible then my ...
0
votes
2answers
652 views

How to use SharePoint 2013 REST service to retrieve data from lookup field

I have two lists: 'Company' and 'Customer'. In 'Customer', I have an auto look up field called 'parent'. Then I tried to use Rest to retrieve data from customer like this: ...
0
votes
3answers
1k views

jquery client object model to return json: what about caml vs. js filtering?

trying to learn client object model (ecma/js/jquery) approach to returning json data and working with that. below I will supply a quick example, but my question is basic context of how would I go ...