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.

73 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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({ ...
3
votes
0answers
571 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 ...
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 ...
2
votes
1answer
488 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 ...
2
votes
0answers
569 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 ...
2
votes
0answers
395 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 ...
2
votes
1answer
73 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 ...
2
votes
1answer
610 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. ...
2
votes
1answer
313 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 ...
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 ...
2
votes
0answers
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 ...
2
votes
0answers
324 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 ...
1
vote
1answer
95 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 ...
1
vote
0answers
54 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 ...
1
vote
2answers
222 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
0answers
48 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
0answers
184 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 ...
1
vote
0answers
407 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 ...
1
vote
0answers
833 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 ...
1
vote
0answers
144 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 ...
1
vote
0answers
177 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/...
1
vote
0answers
110 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 ...
1
vote
2answers
99 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 ...
1
vote
0answers
61 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 ...
1
vote
1answer
866 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 ...
1
vote
0answers
89 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 ...
1
vote
0answers
187 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 ...
1
vote
2answers
267 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 ...
1
vote
0answers
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 ...
1
vote
0answers
977 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,...
1
vote
0answers
640 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"; ...
1
vote
0answers
48 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 ...
0
votes
1answer
22 views

SharePoint modern view formatting with JSON

My style is accepted but it overrides the ATTRIBUTES: Class. How would you suggest I take advantage of incorporating the if(indexOf(@currentField inside the STYLE - which will allow me to do a ...
0
votes
1answer
42 views

Help with JSON to format column to show picture instead of URL

I have a contact list created in SharePoint Online. My list has a column called "Picture URL". The "Picture URL" column is formatted as "Single line of Text". I have formatted the "Picture URL" ...
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 ...
0
votes
0answers
32 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
0answers
49 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
61 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
134 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 @...
0
votes
0answers
18 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 ? ...
0
votes
0answers
20 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
0answers
25 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 ...
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
1answer
98 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
284 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
27 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
65 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" "...
0
votes
1answer
116 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
466 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
68 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 ...