Skip to main content

Questions tagged [json]

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.

Filter by
Sorted by
Tagged with
13 votes
3 answers
14k 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 ...
America's user avatar
  • 233
11 votes
4 answers
5k 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 ...
Christophe's user avatar
  • 5,301
7 votes
2 answers
42k 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 ...
geostima's user avatar
  • 175
7 votes
3 answers
24k 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 ...
Rajkumar Jayachandran's user avatar
7 votes
1 answer
21k 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 ...
Hell.Bent's user avatar
  • 1,299
7 votes
1 answer
11k 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 '...
Karthik Jaganathan's user avatar
7 votes
3 answers
9k 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(...
Hell.Bent's user avatar
  • 1,299
7 votes
1 answer
11k 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 ...
tiMbeRdroP's user avatar
6 votes
3 answers
55k 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: ...
Imen Turki's user avatar
  • 2,183
6 votes
1 answer
1k views

What is the json syntax to insert an item to a list?

I'm trying to insert an item to a list and I keep getting bad request so it's probably because my json is wrong? Here's what my json looks like: { "securit_x00e9_":"test", "column":"test", ...
Tanaka J.'s user avatar
  • 143
5 votes
3 answers
5k 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. ...
rds's user avatar
  • 256
5 votes
2 answers
35k views

Get other field value in JSON column formatting

I've been looking into the new nice JSON column formatting functionality in SharePoint Online. I cannot find a way to include values from other columns in my display result. This should be a very ...
Gil Roitto's user avatar
5 votes
2 answers
5k 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({ ...
Stacker's user avatar
  • 55
4 votes
4 answers
23k 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: {'...
SharePoint Freak's user avatar
4 votes
2 answers
68k 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"...
user17274's user avatar
4 votes
2 answers
15k views

JSON control if @currentfield is empty

I'm using JSON to format a hyperlink column in SharePoint online. If the column @currentfield isn't filled in, there shouldn't be a link. Can anyone help me? { "$schema": "https://developer....
Evy Wa's user avatar
  • 41
4 votes
3 answers
17k views

How to Convert SharePoint list Data to JSON Format?

I have to get the data from SharePoint(Online) List and put the data to JSON format and create a JSON file in Local drive or SharePoint list. I am new to SharePoint online and JSON can anyone help me ...
Elina's user avatar
  • 369
4 votes
3 answers
294 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 ...
Nathan Kamenar's user avatar
3 votes
5 answers
593 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 ...
Christophe's user avatar
  • 5,301
3 votes
2 answers
1k views

Formatting column with multiple conditions

I'm having trouble formatting the JSON for a column called "SLA Day Counter". This column just counts the days between when the request was received and when it was actually handled. The ...
rilakkuma's user avatar
3 votes
2 answers
967 views

How to increase font size of displayname titles when it comes to JSON formating?

With SharePoint Online, is there a way for us to increase the font size of the displayname titles that we incorporate with JSON? For instance, here is my JSON formatting on a specific list... As you ...
klewis's user avatar
  • 1,353
3 votes
2 answers
2k views

How do I hide blank fields/divs on lists' card/gallery view?

I have a sharepoint list being used in a visual way with the "Gallery/Cards" view format: Let's say for example I have a field in an entry that doesn't need to have information and another ...
Mmmake_my_day's user avatar
3 votes
4 answers
13k views

When I open my list on sharepoint, it always opens in quick edit mode. How can I fix this?

When I open my list on SharePoint, it always opens in quick edit mode, how can I fix this?
Brandon's user avatar
  • 31
3 votes
1 answer
979 views

How to style custom formatted column to inherit height of row

I have a custom formatted column in a Sharepoint List that changes the background color based on the content of the field. When the content of another field in it's row is too large the background ...
MJ12358's user avatar
  • 143
3 votes
5 answers
12k views

Submitting input from HTML Form to a SharePoint list without using Infopath

I created a blank form on a HTML webpage through my Sharepoint site called http://.../testform.html. <form> <input type='text' id='name'> <input type='submit' id='submitdata' ...
ShanayL's user avatar
  • 151
3 votes
4 answers
467 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-...
bgmCoder's user avatar
  • 3,581
3 votes
1 answer
3k views

What is JSON code to display boolean value as "yes" or "no"?

This code works but rather than display the words "true" or "false" I want it return "yes" or "no" based on what is in @currentField. { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
Ken Florian's user avatar
3 votes
2 answers
7k views

Column formatting with json

On a standard Date field that is inputted, can I display a full data format (example Friday, 23 March 2018 instead of 23/03/18) with Json to place in the column settings? Please advise
susan's user avatar
  • 2,678
3 votes
3 answers
1k views

Is JSON Light supported for the SharePoint Search REST API?

I read about JSON Light support for SharePoint REST APIs and tried to use it to save some bytes when calling the SharePoint Search REST API (/_api/search). I get unexpected behavior with nearly all ...
Heinrich Ulbricht's user avatar
3 votes
1 answer
64 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? ...
astropringles's user avatar
3 votes
2 answers
2k 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'/&...
Dinerdo's user avatar
  • 769
3 votes
1 answer
1k views

What is the correct way to create a custom action using REST API in SharePoint Online?

I'm trying to use Microsoft Flow and the Send an HTTP request to SharePoint action to deploy an SPFx application customizer to a modern team site. I'm able to use the /_api/Site/UserCustomActions ...
Petter Skodvin-Hvammen's user avatar
3 votes
0 answers
1k views

Search the document library using rest api in Sharepoint including its content

I dont require sharepoint search answers.I require using JS/Json/Web service/rest api.If i type anything in search box in top nav it should go to another page and show the results.Is there any way to ...
Sz4's user avatar
  • 67
3 votes
1 answer
385 views

Displaying an image from a SharePoint list using Javascript on a HTML page

I have a JavaScript page which queries a SharePoint list. I used an InfoPath form to add a jpg to an item. Now I want to display the image on a HTML page with the rest of the results. The jpg url is ...
Dazza's user avatar
  • 767
3 votes
2 answers
1k 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 ...
RageCube's user avatar
2 votes
5 answers
8k views

How to GetListItems as JSON using Powershell with SharePoint Online?

I need to output the items in a SharePoint list into a *.json file for our web development team. I've successfully connected to and loaded the list using Powershell, but I'm unsure what the best ...
Michael A's user avatar
  • 1,425
2 votes
1 answer
5k views

Updating SPFX breaks gulp

So i tried installing a webpart from scratch & added React as a framework. All good, but the version of @microsoft dependencies is 1.5.1 AND the latest is actually 1.6.0. I've tried updating ...
Dante R.'s user avatar
  • 569
2 votes
2 answers
4k views

How to display Persona Card on hover in list using Sharepoint Online view formatting?

When in an unformatted sharepoint list you can hover over a person's name to get more information about them, I believe this is called their persona card. How can I keep this functionality having ...
Wicket_IV's user avatar
  • 137
2 votes
2 answers
2k views

Fetching json content of a File in SharePoint Library

I have started with the following code to retrieve the List Items for JSON files found in my document library: Try { #Connect to PNP Online Connect-PnPOnline -Url $siteUrl -UseWebLogin $...
Sayaman's user avatar
  • 197
2 votes
1 answer
3k views

Using JSON Formatting Inside Web Parts

Have been attempting to integrate JSON formatting into a SharePoint WebPart List. Using a Kanban styled approach with a table containing several list view web parts. Need to be able to designate the ...
GLG's user avatar
  • 47
2 votes
1 answer
622 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....
Anil Pal's user avatar
  • 1,079
2 votes
3 answers
3k views

How to update list item with lookup (People and Group) column using REST post method

I want to update a list item with People and Group column. The list has 4 columns: Title Description ProsessOwner ProsessContributer I am not able to add/update through a REST POST method, since ...
user3629354's user avatar
2 votes
1 answer
3k 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 ...
Shrout1's user avatar
  • 545
2 votes
2 answers
2k 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 ...
Blue Murphy's user avatar
2 votes
1 answer
1k 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) { ...
Jignesh Rajput's user avatar
2 votes
3 answers
23k views

Date format in JSON view formatting

I'm formatting the view of a large list in SharePoint. One of the many columns is a date column. I'm using the following code: { "elmType": "span", "txtContent": "[$...
Bart Vandamme's user avatar
2 votes
2 answers
3k views

Set column height equal to height of record in List

I have a SP list where one of the columns is multi-line I have therefore set the style of this specific column as "height":"auto" which works perfectly for this column. I then have other formatted ...
GFinlay's user avatar
  • 23
2 votes
1 answer
566 views

How to convert CAML query results to JSON with JSOM without looping

Below JSOM code is iterating through sharepoint list items. This will not be efficient if the CAML query results are in thousands. Is there any way to convert the query results directly into JSON ...
user17274's user avatar
2 votes
1 answer
1k views

Displaying an image from a SharePoint list using Javascript building strings

I have a JavaScript page querying a SharePoint list. It's displaying the results on a HTML page. Now I need to display an image for each item. I've uploaded an image to a Library called Device Images ...
Dazza's user avatar
  • 767
2 votes
2 answers
99 views

Is there a way to query two SharePoint Choice columns in the same list?

I have a SharePoint list that I'm querying using Javascript and JSON. I have two choice columns called LifeCycleStatus and Priority. The results for LifeCycleStatus is coming back fine, but for ...
Dazza's user avatar
  • 767

1
2 3 4 5
7