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.

127 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
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
1 answer
1k views

Add Text to Body of SharePoint List Using JSON

Is there a way to add text for instructions in the body of a list without PowerApps? I would like to change up this JSON code to make it possible. I'm aware that there is a "Description" ...
Nanu's user avatar
  • 57
2 votes
0 answers
1k 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 ...
benhorgen's user avatar
  • 121
2 votes
0 answers
726 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 ...
Cherubel's user avatar
  • 563
2 votes
0 answers
1k 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 ...
Dale M's user avatar
  • 133
2 votes
0 answers
536 views

Performance issues when using Jquery Datatable in Sharepoint

I am currently using Jquery Datatable in Sharepoint, where I am not using ajax in datatable as I am fetching data from multiple tables and after doing than I am joining the list and converting it to ...
user68141's user avatar
2 votes
1 answer
81 views

Returning results from a SharePoint list using Javascript code

Going round in circles. I'm trying to return results from two columns on a SharePoint list pictured, which will return the results to a HTML page which is being created by a different JavaScript ...
Dazza's user avatar
  • 767
2 votes
1 answer
2k 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. ...
Benjamin Snider's user avatar
2 votes
1 answer
403 views

Send JSON Payload in RequestContent of HttpSend with POST in SharePoint 2013 Workflow in Visual Studio

I have a SharePoint 2013 Workflow in Visual Studio. I need to call an external Web API using POST and send some JSON payload. I couldn't find any proper documentation to achieve it. Can anyone please ...
Ven's user avatar
  • 1,147
2 votes
0 answers
28 views

Hybrid mobile SP2013 client

I already have a native iOS app that uses SP rest api without issues. My plan is to port this app into a hybrid one and make it cross platform using Cordova. Basically I want to mimic the native ...
user623396's user avatar
2 votes
0 answers
371 views

Sharepoint 2013 Hosted App. Access-Control-Allow-Origin - Access Denied

I am working with SharePoint 2013 and I developed some app parts to show information in our intranet. These app parts get data from WEB API using jQuery, It works fine in Chrome, Firefox, but in ...
Rafael RLD's user avatar
1 vote
0 answers
51 views

Using Data from another Column to Populate Name (of employees without email)

I have created a list of all employees with the Primary column set to "Person / Group". Of course, all employees that have an active email address are registered in the Active Directory, but ...
Krisda Linsey's user avatar
1 vote
0 answers
2k views

How to get Key Value Pair value from valid JSON string in PowerApps?

I am working with the requirement in PowerApps where I have a JSON string like below { "Created": "2022-08-29T16:40:19", "IsCurrentVersion": true, "VersionId&...
Aakash Maurya's user avatar
1 vote
1 answer
678 views

Reducing decimal places on percentage

I would like to reduce the number of decimal places in a calculated column with some JSON formatting. I would like to reduce this to 101%. The JSON code I have written is shown below: { "$...
Carson's user avatar
  • 11
1 vote
1 answer
984 views

SharePoint JSON footer - How to add multiple links below footer - I can only do one and need to show 5 more

SharePoint JSON footer - How to add multiple links below footer - I can only do one and need to show 5 more. Current JSON: { "$schema": "https://developer.microsoft.com/json-schemas/...
Patty's user avatar
  • 11
1 vote
1 answer
695 views

JSON Failure: not found on the data object for SharePoint Online column formatting

I can't get SharePoint Online to recognize my field name. I know I could use @currentfield where I have [$2021_Q3] but I want to create a more complex formula and can't even get this basic one to ...
Patricia Fifield's user avatar
1 vote
2 answers
253 views

Format column using JSON

I want to format a column if there is a date in the column, otherwise leave it blank. This is the code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting....
llrinct's user avatar
  • 11
1 vote
4 answers
4k views

Wrap text on title and hyperlink columns

I'm trying to import a list from Sharepoint On-Premise to Sharepoint Online. In the old list, the text was wrapped for both the title and the hyperlink column which gave the list an organized and ...
Joseph's user avatar
  • 11
1 vote
1 answer
717 views

JSON column HyperText where @currentField needs to be in the Middle of the URL

I am trying to use Microsoft's Sharepoint List Dev document to do a "Turn field values into hyperlinks (basic). My code looks like this: { "$schema": "https://developer....
user95233's user avatar
1 vote
1 answer
709 views

How do you display text on different lines within a Sharepoint forms header using JSON?

I am attempting to recreate a word document type form on Sharepoint. I have been successful in creating a list and formatting the body of the form to a level where questions are in the appropriate ...
Robert Redmayne's user avatar
1 vote
1 answer
306 views

How to use Site Design to remove default items from new sites?

very new to SharePoint and I've been asked to set up new site design templates for SharePoint online. While I've managed well enough to create and add new site designs, I'm struggling with the ...
Rofter4's user avatar
  • 11
1 vote
0 answers
572 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 ...
Wicket_IV's user avatar
1 vote
0 answers
70 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 ...
Noman's user avatar
  • 151
1 vote
0 answers
1k 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 ...
Soul Eater's user avatar
1 vote
2 answers
97 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 ...
Sergiu Manta's user avatar
1 vote
1 answer
2k 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 ...
Emiel's user avatar
  • 99
1 vote
0 answers
485 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 ...
Nyxero's user avatar
  • 11
1 vote
2 answers
1k 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 ...
BWieland86's user avatar
1 vote
0 answers
97 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 ...
CHRSharePointDev's user avatar
1 vote
0 answers
475 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 ...
Jason's user avatar
  • 71
1 vote
0 answers
784 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 ...
JustMe's user avatar
  • 141
1 vote
1 answer
2k views

Format date in a list with quarter and year using JSON on the column

I have a list of projects with planned start dates. I want to use the JSON field formatter, the documentation to which is here, in order to format the date as 'Year'-Q'quarter'. I have a calcualted ...
Nigel Johnson's user avatar
1 vote
0 answers
191 views

Add Angular.js to SharePoint when .json files are blocked

The boss wants AngularJS, and the SharePoint Farm Nannies won't remove the restriction that prevents uploading .json files. There appears to be a manifest.json in every folder, and then an errors and ...
Steve Clark's user avatar
1 vote
0 answers
253 views

Unable to access values from Json Rest api result in SharePoint Workflow 2013

I'm calling rest API in SharePoint workflow in SharePoint designer. I'm looping through the results and trying to access the values using key and trying to put them in email body . I'm using "Get d/...
user2864496's user avatar
1 vote
0 answers
166 views

How do I get all ExtendedManagers from a DynamicValue

I am creating a custom workflow action to be used for building SharePoint 2013 workflows in SharePoint Designer. I use the GetPropertiesFor REST API to get all of a user's information. Is there ...
user3147083's user avatar
1 vote
2 answers
118 views

Updating single list item in Objective C

I am trying to update a single list item in SharePoint from an iPhone App. Here is the code. If I change the X-HTTP Method to DELETE the item is deleted, so I know my Digest Value and authentication ...
user59138's user avatar
1 vote
0 answers
76 views

SharePoint Designer 2013 Send e-mail with specified FROM address

I tried to recreate a workflow in SPD2013 following advice there link It was Call HTTP Web service action that recreates JSON code. When I run this site workflow, I don't get any e-mails. I traced the ...
Mariya's user avatar
  • 21
1 vote
2 answers
1k 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 ...
Oxossi's user avatar
  • 644
1 vote
1 answer
1k 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"...
Patrick's user avatar
  • 111
1 vote
0 answers
92 views

Read user field via Javascript/REST: Some users are NULL

I have a simple list with a simple user field. I can assign users, save the item and everything was working fine... ...until I tried to access the list via REST call within a Javascript. Some of the ...
Dave's user avatar
  • 617
1 vote
0 answers
426 views

Increase Length of Stream Data from Client to Sharepoint Custom List

I am trying to update a column in a SharePoint 2013 Custom list but I am getting this error The maximum number of bytes allowed to be read from the stream has been exceeded. After the last read ...
maitiest's user avatar
1 vote
2 answers
365 views

SP2013 Toolbar keeps loading invalid http json response headers for commandui.ashx

Dear smart people out there, we published SP2013 via UAG 2010 sp4. The toolbar keeps showing 'Loading ...' In javascript there is a Deserialization error. My http response for the commandui.ashx ...
AllWorkNoPlay's user avatar
1 vote
0 answers
2k views

Syntax for including maxJsonLength in a standalone web.config for a Sharepoint Farm solution?

We encountered the following error in Javascript in a Sharepoint project: Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the ...
SNag's user avatar
  • 149
1 vote
0 answers
1k views

How to configure SharePoint REST API to return JSON by default?

I'm using a 3rd party HTTP client to retrieve data from SharePoint. I want to get the result in JSON format. I know one method is to add the header "Accept": "application/json; odata=verbose" However,...
KennyC's user avatar
  • 191
1 vote
0 answers
683 views

how to pares search api odata json result in C#

i'm using that search query string siteUrl = "<site>"; string queryText ="Path:\"pathTosearch/*\" IsDocument:1"; string rowlimit = "10"; string sortExpression = "Write:descending"; ...
Hager Aly's user avatar
  • 131
1 vote
0 answers
51 views

Exporting document content from SP2013 to external webapp

How should I do to make a document viewable on a webpage, that is exported from SP2013 document library. A user should be able to, through a webpage send a request to view the content of a specific ...
Skaft's user avatar
  • 526
0 votes
0 answers
10 views

I need to show the results of a calculated field on the NEW ITEM Sharepoint list form...thoughts?

So, I have a calculated field that is calculated based on how other columns are populate on the NEW ITEM SharePoint list form. I am new but I understand that calculated field will not show on the form....
Jason L. Shaw's user avatar