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
7 votes
2 answers
41k 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
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
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
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
5 votes
2 answers
33k 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
4 votes
2 answers
14k 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
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,435
2 votes
2 answers
3k views

Highlighted Content Column Creation

Our SharePoint tenant is host to multiple Client sites, all of which are structured more or less the same and with access to each Client site given to ourselves and the respective client. Each site ...
Guero's user avatar
  • 21
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
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
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
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
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
2 votes
1 answer
416 views

Get Field Data Types (SPFieldType?) as JSON

I'm building some python programs that transfer data from SharePoint 2010 to and from a database. Previously, I've been receiving REST queries as XML and parsing through it in order to first get the ...
Eric Ed Lohmar's user avatar
1 vote
2 answers
2k views

Convert text to fluent icons in multi-value field

I have SPO list with a multi-value field, which is filled by a lookup list (other list on the same SharePoint). The values are the names of MS Fluent Icons. Now I want the names in that field to be ...
Der_Fab's user avatar
  • 177
1 vote
2 answers
8k views

SharePoint Online JSON format phone column to display (555) 444-3333 or 444-3333

Brand new to SharePoint Online and I want to test out JSON to format a telephone column instead of an extra calculated column. I'm attempting to display entries: 5554443333 as (555) 444-3333 and ...
RogueVeggie's user avatar
0 votes
2 answers
4k views

Working With Column Formatting using JSON - Rounding Decimal values

I have been working with customizing SharePoint Columns and using the pre defined Microsoft list view edits. The trouble I am experiencing is that the formatting is working, however it is adding 50 ...
GLG's user avatar
  • 37
0 votes
1 answer
407 views

How can I create a Cascade within a Cascade in SharePoint Online (modern or classic)?

So my customer has these two lists (one classic and one modern) in which they'd like me to create a cascade within another cascade. Here's a snapshot of one of the lists: As you can see, they tried &...
Chris's user avatar
  • 393
0 votes
1 answer
742 views

Add web parts to JSON template sharepoint online

Is it possible to add web parts to a JSON template so that when a page is created certain web parts automatically display?
hittle08's user avatar
0 votes
0 answers
361 views

What is correct variable in a flow to store a big JSON string

I have a JSON file and need to copy and paste it to a variable in MS flow, what is the best variable for doing this? I prefer not to call an API to read a file.
Mohsen Sichani's user avatar
0 votes
1 answer
2k views

How can JSON column formatting be used to highlight duplicate entries in a column a list?

Column formatting is used in SharePoint Online to customize how fields in lists are displayed. Microsoft provide documentation regarding the use of JSON for column formatting. As is described in the ...
Ashton's user avatar
  • 103
0 votes
3 answers
5k views

read data from list with REST + Javascript : Error : unable to get property d of undefined or null reference

I am trying to get item from SharePoint list by passing a parameter with the ID to the list and retrieving the item. My code is this: $.ajax({ url: 'http://mysite:5555/_api/web/lists/getbytitle("my ...
SharePoint Freak's user avatar
0 votes
1 answer
478 views

Retrieving List<T> collection from a REST method within a SharePoint 2013 Workflow

Here is the deal.. I have a REST method that returns Generic.List<DTOSupervisor> which has to be retrieved by using a HTTP Send and GetDynamicValueProperties components. My REST method ...
Muhammedh's user avatar
  • 1,157
0 votes
1 answer
588 views

PowerBI in Sharepoint 2013

Has anybody of you experience with integrating PowerBI Dashboards/Tiles into SharePoint ? For my case I am searching a solution, where I can get Dashboards/Tiles via JSON File. Iframe is not a ...
SaSH_17's user avatar
  • 209