Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

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.

0
votes
0answers
9 views

Sharepoint List - How to use various field types in JSON (column formatting) [duplicate]

Some data from other fields can't seem be referenced when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
0
votes
2answers
41 views

Rest API Post Request Returns '403 Forbidden'

I am trying to create a new choice (radio buttons) field using REST API request in my SharePoint Online environment and this is the code I'm using: $.ajax({ url: "https://mydomain.sharepoint.com/...
0
votes
0answers
30 views

Use Sharepoint list fields in JSON column formatting

Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
1
vote
2answers
31 views

O365, I have a Column Named 'Status' to show Green/Red circle but I am struggling

This is from a List and on List setting there are two Columns that involves the problem I am facing. Status (absolute name = ColorStatus) NewCol2 Users will enter in either 0 or 1 in NewCol2 field ...
0
votes
1answer
9 views

Backslash being appended to header variable within dictionary in new workflow

I am trying to make a call to a parent list using a workflow. I need to create a dictionary containing two headers: Accept and Content-Type. Both items should have the value of 'application/json;odata=...
1
vote
1answer
118 views

SharePoint Online - Conditional formatting using JSON

I have a Hyperlink column in my list which I want to apply some custom formatting. the column is not Required, meaning the field might be blank on some rows. How can I check if the field is blank, ...
1
vote
2answers
84 views

Using Javascript REST API to do asynchronous batch POST to multiple SharePoint lists

I'm in a bit of a quandry as I'm just learning how to do development in SharePoint 2016 / SharePoint Online and using Javascript to perform REST calls. I have a form that is using REST to successfully ...
0
votes
1answer
38 views

Modern-UI JSon Total Days Calculation in a custom-list allitems view

I needed to show the day the item is in open status. The days are only displayed in allitem.aspx. I was able to use JSLink to achieve it in classic UI. When the user switches to Modern UI, JSLink does ...
0
votes
1answer
20 views

Copied project “product ID” fault in app catalogue

I have an web part that I have copiedto two examples and modified the other one. However, when I try to upload them both to an app catalogue I get an error (the same product ID exists for the second ...
0
votes
1answer
94 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
0
votes
0answers
15 views

How to create Web API controller in SharePoint 2010 Farm solution

I am trying to build the services in SharePoint 2010 farm solution which would connect to SQL database and return the response in JSON. I tried exploring and all I could find was that I can build Web ...
0
votes
1answer
25 views

Trying to interperet query url

I'm trying to interpret a query url and it's the last bit that I don't understand... What is "1":1033} Additionally.. what does #Default= do? https://Companycom.sharepoint.com/demo-search/SitePages/...
1
vote
1answer
105 views

Sharepoint Online List - Format Column/Row to be Red on certain Condition

I do not know JSON, so I am struggling to figure this out. I have a drop down menu column and if the user selects one of the drop down menus (Lets say its called "Peer Review - Rushed") I would like ...
2
votes
1answer
107 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 ...
0
votes
1answer
84 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 ...
1
vote
1answer
31 views

Sharepoint Ideas help [closed]

It's been a while since I used SharePoint and have now got a chance to improve our SharePoint site it is awful! It is just random documents all over the place and can't find anything. My first idea ...
1
vote
2answers
335 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....
1
vote
2answers
721 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 ...
0
votes
1answer
974 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 ...
3
votes
1answer
299 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/...
0
votes
1answer
47 views

How can I add fields in SharePoint list in single line of text column using JSON

I have 5 columns in a SharePoint list. In order to reduce the number of columns to one, I should have all other 4 fields to be added to one column using JSON. when i try { "status" : "approved" "...
1
vote
0answers
26 views

Async call to REST API in page layout code-behind

Please excuse my ignorance -- I am not sure if this is even correct practice, let alone possible to achieve in SharePoint. My self-taught knowledge of SharePoint development was all learned by ...
1
vote
1answer
641 views

JSON formatting + Calculated columns pic link fixes

I used to have a picture in some calculated columns that function as links based on some of the attributes of an item. We were told to use JSON formatting at that time, but apparently now it seems ...
0
votes
1answer
78 views

JSON not working in Indian regional setting

I have created the Sharepoint List with JSON for conditional formatting. The regional Setting for locale is "English- United States" due to which my current Date format is MM/DD/YYYY. I have added ...
0
votes
1answer
233 views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0
votes
1answer
41 views

How to change like column for list layout Sharepoint

I implemented the like feature on a test column I have but I noticed the icon linked to the like is a little hart. I want to change that hart to a thumbsup or another icon. How can i do that? I would ...
1
vote
1answer
105 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 ...
1
vote
2answers
52 views

How to get ErrorCode value using jQuery from bellow SPServices xml response

How to get ErrorCode value using jQuery from bellow SPServices xml response: <Results xmlns="http://schemas.microsoft.com/sharepoint/soap/"> <Result ID="1,Update"> <ErrorCode>...
0
votes
0answers
36 views

Create a Listview based on Date Groupings and Sorting. Date is a calculated Field

I would like to group a list by Month Year in SharePoint online. I've a calculated field that returns the date as text in the format "YYYYMM¤MMM-YY" e.g. "201806¤Jun-18" to allow sorting in the ...
0
votes
1answer
515 views

Using the JSON results from a SharePoint API search response

I am using the SharePoint REST API to do a search. I am pulling back the JSON results and reading them as follows: HttpWebRequest endpointRequest = (HttpWebRequest)HttpWebRequest.Create(querystring); ...
0
votes
0answers
100 views

Nested JSON data to SharePoint list item

So I've recently been tasked with finding a way to retrieve data from an api call, then upload that data back to a SharePoint list item and all followed by that it has to be pulled back into a PowerBi ...
0
votes
1answer
288 views

JSON column formatting - reference column not in view

Hi we have Sharepoint online site using old template and switched list to use modern experience. Problem is with JSON formatting, because some things do not work as expected. Unable to use/reference ...
2
votes
4answers
512 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?
2
votes
1answer
301 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 ...
1
vote
1answer
506 views

Column Color formatting based on condition

I have a small requirement which can be fulfilled through JSON column formatting but I do not not know how to go about it. Currently I have three columns 1. Consumed quantity : 12(example value) 2. ...
1
vote
0answers
108 views

REST API call Orderby - JSON changes my order!

So the below function, gets data from a list in a certain order - by SortOrder column. If i go to the url in my browser and run it the order is as expected, however the output (JSON) seems to then ...
0
votes
1answer
1k views

Get other field value in JSON column formatting SharePoint Online

I am trying to us column formatting in SharePoint Online and am very new to JSON. I am trying to use conditional formatting based on another column. This was the code I was using when we could do ...
0
votes
2answers
259 views

Format a single line of text using JSON

I have a single line of text column in a sharepoint online list that is being populated with a dynamic value added by a workflow (the value is a url + the current created item ID added to it). And as ...
0
votes
1answer
223 views

SharePoint Online Custom Formatting

I would like to change the background color of a SharePoint calendar list item when a pattern is entered in the title with JSON coding. for example, if "ABC" is used in the title, then the background ...
0
votes
0answers
239 views

Why does the list column text disappear when formatting with JSON? (SharePoint Online)

When I try formatting columns in my SharePoint Online list, the text no longer displays. I've tried a couple of official examples from here https://docs.microsoft.com/en-us/sharepoint/dev/declarative-...
0
votes
0answers
520 views

Formatting column making the column text to disappear in latest Sharepoint online

Formatting column with JSON makes the column text to disappear in latest Sharepoint online. E.g. if I try to use something like that: { "elmType": "div", "txtContent": "@currentField" } saddenly I ...
3
votes
2answers
3k 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
0
votes
2answers
160 views

Create list datasheet view using the REST api

Provided following body content for a SharePoint REST api call: { '__metadata': { 'type': 'SP.View' }, 'Title': 'Awesome View', 'PersonalView': false } This creates a new view named Amesome ...
0
votes
1answer
45 views

REST calls to different items of single lib return responses with different structures

SP 2016 on-prem. I have a test library with bunch of word documents. Calling to part of them return a response like: { "d": { "__metadata": { "id": "716369bb-3f0e-48fb-845f-d4774d6198ac", ...
1
vote
1answer
3k views

Column Formatting using JSON (Sharepoint Online)

I'm trying to inject some life into an old Sharepoint site (classic) by creating a new Progress Bar based on a %Complete field. The new JSON template code provided by Microsoft doesnt seem to want to ...
2
votes
1answer
225 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 ...
0
votes
0answers
295 views

Custom Formatting Modern Lists - Problem using Date Field

I am trying to use the new modern list custom formatting capabilities (in JSON) for an email template (see: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#...
0
votes
1answer
6k views

Change column width in SharePoint 365, using JSON

I have a several lists containing columns with multiple lines of text. The standard column width is too narrow. I'd like to increase the width using the new column formatting functionality. I've never ...
2
votes
2answers
4k 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 ...
1
vote
0answers
281 views

Integrating handlebars and DataTables in SharePoint 2013

I am using Handlebars to display my SharePoint list into a table, which works. But when I try to turn it into a dataTable, it does not transform into a dataTable. I was able to do it in jsFiddle and ...