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
2
votes
1answer
595 views

Why is my Ajax call returning a 500 Server Error?

I'm currently building an application page for a SharePoint 2010 site. One of the methods on this application page retrieves the User Profile information from the server and displays it to the client. ...
0
votes
1answer
660 views

REST API return encoded Multiline Textfield but show it correctly

I save a JSON string in my SharePoint list. This looks like: {"columns":[{"name":"A","visible":true,"width":200,"sort":{},"filters":[{}],"pinned":"left"},{"name":"B","visible":false,"width":150,"sort"...
1
vote
2answers
22 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
0
votes
1answer
868 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
1answer
687 views

SharePoint Workflow 2013 Get Item From Nested Dictionary

I have a sharepoint workflow dictionary in which I have following data: Userlist: [{"Id":3,"Value":"Tim Meier"},{"Id":2,"Value":"Hans Müller"}] This is what I get when I run the log and choose ...
1
vote
1answer
31 views

Get certain field from returned JSON object

I am editing a SharePoint List using JS Link. Within a SharePoint-Column, I would like to display information from another SharePoint column. The source is a SharePoint Person Column (Entliehenan). ...
1
vote
0answers
8 views

C# api upload to SharePoint [closed]

I want to read and upload on SharePoint, anyone can help me ? I use C# api. I try by Cloudinay and Api works.
0
votes
1answer
546 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....
2
votes
2answers
3k 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
2answers
9k 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 ...
1
vote
1answer
31 views

JSON datetime tracking custom formatting

I am trying to format a sharepoint list with JSON so that the From/To column highlights the current phone number when todays date falls into the timespan given. I have managed to have past on future ...
1
vote
1answer
854 views

How can I loop through a json result by substituting field/column names with a variable

How can I loop through a json result by substituting column names for a variable End result: I'm building a table from a list (~25 columns). I want to attach custom classes to each cell based on the ...
0
votes
1answer
34 views

Reference Metadata field with JSON Formatting

I am unable to capture the Managed Metadata field within my JSON formatting. I can reference other fields by their Internal names but how would I go about grabbing that MMD value? { "elmType": "a", ...
0
votes
2answers
1k views

Using REST: Security invalid error with SharePoint Add-in

Currently getting an error when using REST to upload a file within SharePoint. Error reads "The security validation for this page is invalid and might be corrupted. Please use your web browser's Back ...
0
votes
0answers
14 views

List View JSON warning if date is 1 month away

I would like a row on my list view to show red if a date is one month away. Very new to JSON, this is what I've started with: I think where I have typed ONE MONTH AWAY I need a calculation but just ...
2
votes
2answers
1k 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....
2
votes
2answers
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 ...
0
votes
0answers
25 views

Provisioning Quicklinks

I have a request to create a template that includes a QuickLinks web part. I noticed that PNP exports the web part like this: </pnp:CanvasControl> <pnp:CanvasControl WebPartType="QuickLinks" ...
0
votes
1answer
59 views

SharePoint online site script

I'm havin' trouble with adding a managed metadata column trough JSONsitetemplate. When adding a 'self-made' column I get an error 'parameter Internalname references a resource that coud be found' ...
0
votes
0answers
40 views

JSON column format not working for Rating Scale questions

When adding JSON column formatting to a 'Rating Scale' question it does not appear in the survey. When I use the same JSON column formatting on a list however it does work. The purpose of the JSON is ...
0
votes
1answer
1k views

How can I add all contents of a dynamic html table to a SharePoint list?

So my table is 1 row where rows can be added, although it does not have unique id's for each row. I'd imagine this is the issue. $('#submitdata').click(function(){ var table = document....
0
votes
1answer
65 views

Resolution for SharePoint: Uncaught TypeError: Cannot read property of undefined?

Successfully grabbing values for person columns with multiple selections allowed. Looking at the call in the browser I see the info I need: function dChange() { $.ajax({ url: xurl + "/_api/web/...
5
votes
2answers
4k 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({ ...
0
votes
1answer
53 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
0
votes
0answers
88 views

SP Lists - JSON Conditional formatting based on other columns

I am trying to set up conditional formatting for my SharePoint list, based on the value from different columns. Here is what I was trying to set up: (1) IF @ColumnName1 = "status 4" THEN @...
2
votes
3answers
583 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 ...
0
votes
1answer
431 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 ...
1
vote
1answer
85 views

SharePoint Online Version Column Formatting via JSON

I am trying to archive the following within a document library modern experience on SharePoint Online: All minor version (everything .1-9) the background should have the color red or similar All ...
0
votes
1answer
351 views

How to utilize if/else condition for JSON column formatting in SharePoint?

I am trying to format the color of a column based on the selection of another column in the same View. But, I am having trouble writing the JSON to check for multiple values in the other column. Here ...
0
votes
0answers
17 views

How to loop through array of objects grouped by date?

I want to get the properties of array including its length to get the count and the requested date of each objects inside the array which is grouped by date. Can anyone please help me on this ? ...
1
vote
1answer
79 views

Export Modern Team site as a JSONfile

I'm about to set up a new SPO env. In the env I should have 5 custom templates, which powerusers can select in the dropdown list when creating a new teamsite. I tried different tutorial and PS ...
0
votes
0answers
19 views

JS script to convert repeated section from XML to HTML - help required

I found this script, see below, which converts the XML format generated from the repeated section within a sharepoint list and renders it in HTML format. <script type="text/javascript"> ...
0
votes
1answer
343 views

REST API How to retrieve the ID of a newly created file

Using the Sharepoint Online REST API I have successfully created a new file using a POST request - https://company.sharepoint.com/_api/lists/getbytitle('MyTitle')/Files/add(name='test.jpg',overwrite=...
0
votes
0answers
24 views

How to get data from Status field using Json?

I have a requirement to get the count of Requested and Completed items in a particular date in SharePoint. I was using json to retrieve the data from SharePoint list. Status is a SharePoint List ...
1
vote
1answer
29 views

Dynamically Constructed JSON/Javascript Object Will Not Stringify

I am trying to take selected listed items and pack specific data values from them into either an array or JSON "object" to then stringify and store in local browser session storage so I can pass it to ...
0
votes
1answer
48 views

Ajax is being called in Chrome but not IE

I'm using Ajax calls to pull in data for a table and I have successfully been able to pull in data for Chrome and everything shows up perfectly fine, but my table is not wanting to show up in IE at ...
1
vote
0answers
40 views

SharePoint 2016 - Polygon in SVG (clickable)

at the moment I try to develop a SharePoint 2016 Visual Web Part project (my first time). I define the content from this Visual Web Part withe JavaScript, becaue I have to build a SVG element by ...
0
votes
0answers
13 views

when i updated any other column, its repeating and apend same values and showing in list version code below

Hi I am using the following below code, but when I updated any other column, it's Repeating/Appending and showing this: function getAllnotesList(requestId){ $().SPServices({ operation: "...
0
votes
2answers
922 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
19 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....
3
votes
2answers
6k 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
2answers
40 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
18 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=...
0
votes
1answer
483 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 ...
1
vote
2answers
201 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 ...
1
vote
1answer
338 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, ...
0
votes
1answer
94 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
22 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
272 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
25 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 ...