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
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

How to use JSON to make a clickable checkbox like classic view tasks

Can anyone help me with this? I want to be able to click elmtype button and for it to update the row that it's in. For example, I click "Complete" icon in @currentField and it changes [$Status] to ...
3
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
1answer
28 views

'Name' column on view being duplicated on design rerun

I've written the below JSON to create a list (with the doc library template) and create an associated view. { "verb": "createSPList", "listName": "Doc lib name", "...
1
vote
0answers
32 views

SharePoint API search query ignoring “SelectProperties” parameter

I am submitting a request to the search API to return all people whose last name begins with a specified string. I ONLY want their "PreferredName" and "JobTitle" properties; however, while SharePoint ...
1
vote
0answers
49 views

How to control arrangement of view formatted list items?

I have a sharepoint list that uses view formatting. The height of each item depends on the content within it, they are arranged with 4 in each row when the browser is maximised. The columns display ...
0
votes
2answers
169 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 ...
0
votes
1answer
2k 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....
1
vote
1answer
41 views

JSON List View Formatting using “Include File”. Possible?

Is there a way to write my JSON in a single file and then use it in many lists views? My situation is that I have a format that I want to use over and over again (more than a hundred) and the ...
1
vote
1answer
23 views

REST API in 'Send a HTTP Request' returning an error

I'm trying to return an additional SP column in a Flow I've inherited. I've checked the name of the field in the address bar and it's showing as 'BTG%5Fx0020%5FPolicy%5Fx0020%5FOwner'. I've added it ...
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({ ...
1
vote
0answers
52 views

How can I render a Swagger file (OpenAPI Spec) on a SharePoint page

Does anyone know how to render Swagger files (now known as OpenAPI Specs) on SharePoint? If I have a REST API that our internal business groups want to use then it seems to make sense to render it on ...
2
votes
3answers
2k 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 ...
0
votes
1answer
663 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
48 views

Column formatting with JSON add dynamic hyperlink

I want to format a column using JSON to add a Workflow Start LINK but can not change the element ID dynamically. Can someone please help? { "elmType": "a", "txtContent": "", "attributes": ...
10
votes
4answers
4k 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 ...
0
votes
1answer
779 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"...
0
votes
2answers
4k 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 ...
2
votes
1answer
917 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
1k 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); ...
2
votes
0answers
734 views

Column formatting changes vertical alignment

I followed this Microsoft guide on column formatting and made the changes I need to get it to work on 3 of my columns. Specifically I am using the bits on "Conditional formatting based on the value in ...
0
votes
1answer
771 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 ...
2
votes
1answer
56 views

Format columns with numbers right aligned and with fixed decimals

I successfully added conditional coloring of cells in a column of a custom list using JSON. So I have browsed several resources at M$ for formatting options. E.g. column-formatting I wasn't able ...
2
votes
2answers
82 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 $...
3
votes
1answer
673 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 ...
0
votes
1answer
1k 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....
0
votes
1answer
39 views

Serialize and deserialize SharePoint CSOM objects

I want to serialize the objects of CSOM to JSON store them. Later nee to deserialize them. I know there is no direct way to do that it will give an error : "The property or field '----------' has ...
2
votes
1answer
29 views

Is there a way to get the json content of files fetched through a CAML query?

const query = `<Where> <Eq><FieldRef Name="File_x0020_Type"/> <Value Type="Text">json</Value> </Eq> </Where>`; const xml = '<View ...
1
vote
0answers
33 views

Microsoft Flow not outputting the data in the table for the Azure AD column fields

I am looking to get a column data to a table in Microsoft Flow from a SharePoint List but it seems to giving the following error for the Azure AD column output for the table, while I am using the ...
0
votes
2answers
25 views

Linking a SharePoint list to a SharePoint document library

I am teaching myself JSON, but I have a simple questions I haven't found a solution for. I am looking for a JSON to link a SharePoint list to a SharePoint library. It is in the same SharePoint site, ...
0
votes
1answer
276 views

JSON conditional format column based on choice from another column

I am using SharePoint online. I have a choice column and a text column, If the choice "phone" is selected from the choice column, I want the text column to change color. For some reason it wont work - ...
0
votes
1answer
944 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
1answer
972 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
0answers
38 views

How to pass wildcard value with query string using json view formatting

Does anyone know how to filter based on one value in a multiselect? I am using json column formatting in SharePoint online to create a link that will filter a view to all rows where a particular ...
0
votes
1answer
72 views

Python requests post JSON raw data in SharePoint

I want to update some property in a SharePoint ListItem. I'm using this code: body = '{"__metadata": {"type": "SP.Data.Documentos_x0020_compartidosItem"}, "Tarea": "TP 15"}' header = {'...
0
votes
1answer
111 views

Add links to a Quick Links web part using PowerShell and JSON

I am trying to add links to a Quick Links web part on a modern SharePoint site, to do this I am using PowerShell and JSON. I have obtained the web part as a JSON file and have accessed it using the ...
0
votes
1answer
33 views

List layout with json not works as expected

I tried using below json code to make list like tile. It works as expected when open it in the list however, the layout changed when use this list as web part in page. Figure 1 : Open in list ...
1
vote
1answer
144 views

Flow to copy calendar items from one site collection to another

Due to lack of a built-in Modern Calendar interface and our corporation's restrictions on what we can do within the sites in our tenant, I'm trying to build a Flow in Power Automate that copies ...
0
votes
2answers
17k 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 ...
0
votes
1answer
106 views

Manage and Edit JSON in Power Automate

I'm using Get_Flow action in order to get the flow definition, it seems that the format of this definition is JSON My desire is to customise this JSON and change what it must change, and then create ...
1
vote
0answers
160 views

Writing numbers comma separated in JSON

Following a tutorial: SharePoint modern view formatting with JSON I realized that formatting a column with numeric or currency values are shown like strings. In this case I have the "Price" column ...
2
votes
2answers
93 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 ...
0
votes
2answers
92 views

Formatting issue for View

UPDATE::: Sorry everyone I have been clearer. This is supposed to be for the "format my view" feature in the Sharepoint Online custom list. I'm trying to make the entire row change color based on ...
1
vote
2answers
28 views

SharePoint workflow “now” function

I am trying to create a workflow that will automatically update a field based on creation date +3 days;3-5 days; 5> days. How can I tell the flow to calculate if 3; 3-5; 5> days have passed since ...
0
votes
0answers
28 views

Sharepoint online - Guided tours, feature tour, walk throughs

TLDR; Is there a way to create in-app walkthroughs/ guides tours/ feature tours using open source packages like intro.js, chardin.js, joyride, bootstrap, HopScotch, Crumble with Modern SharePoint ...
1
vote
0answers
174 views

SharePoint Online multiline with append - JSON formatting

In SharePoint Online I have a multiple lines of text column that has append checked. Instead of showing "View Entries" in multiple-line text column with append-only checked, will show all entries or ...
0
votes
2answers
35 views

Retrieve fields, fields type, fields values and column names of a Sharepoint Content Type used in a library using Javascript

I created a library that contains documents in Sharepoint Online. Let's call it myLib. I also created a content type, myCT. My objective is to retrieve informations concerning fields I created in a ...
7
votes
2answers
34k 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 ...
0
votes
2answers
202 views

Client Side (inline IDE) editor/app for editing (.js , .json, .css, .html) files in a Document Library

We more and more store data as .json files in a Document Library. Instead of (re)writing our configuration front-end, I would like users to edit the bare .json files. (and while we're at it, all ...
0
votes
0answers
55 views

How to parse JSON to return null as default if complex object empty/null/undefined?

Using HTTP Request to get SP item, having trouble parsing JSON to return anything for null object. Can return null for an empty string column as shown below, how to do so for a more complex object ...

1
2 3 4 5