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
1answer
452 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
1k 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
444 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
681 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
165 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
2k 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
384 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
271 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
632 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
269 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
50 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
4k 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
283 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
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 ...
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
0answers
383 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 ...
2
votes
0answers
524 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
271 views

How to add checkboxes in filters

I have a jQuery data table individual column searching. I want a select list with checkboxes in each column, which would be driving the filtering options, something visually like what ColVis does (...
1
vote
0answers
807 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 ...
0
votes
1answer
305 views

Individual column searching using Data table in SharePoint 2013

I just want to use custom search data table for each fields. I do have the following code. But, I'm facing to search the footer search,cause it does search, but no result. NB: When I tried to ...
1
vote
0answers
134 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 ...
0
votes
1answer
89 views

Copy attachment from subsite list to main site list

I need to copy attachments from list in subsite to list in main site. I dont have any idea how to start and as far I know and what I have search, you cant use wf because it wont work. So does ...
2
votes
1answer
188 views

Get Field Data Types (SPFieldType?) as JSON

I'm building some python programs that transfer data from SharePoint 2010 to and from a database. Previously, I've been receiving REST queries as XML and parsing through it in order to first get the ...
3
votes
5answers
6k views

Submitting input from HTML Form to a SharePoint list without using Infopath

I created a blank form on a HTML webpage through my Sharepoint site called http://.../testform.html. <form> <input type='text' id='name'> <input type='submit' id='submitdata' ...
3
votes
0answers
533 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
683 views

Unexpexcted end of JSON input error

I am updating a SharePoint list item in SharePoint framework web part, with the below code my item is getting updated, but it gives me the following error at the end : Unexpected end of JSON input ...
2
votes
0answers
372 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
178 views

Displaying an image from a SharePoint list using Javascript building strings

I have a JavaScript page querying a SharePoint list. It's displaying the results on a HTML page. Now I need to display an image for each item. I've uploaded an image to a Library called Device Images ...
1
vote
1answer
37 views

Swapping an object into an image using Javascript onload

I have a JavaScript page which is querying a SharePoint list. I'm getting the result of column called DevicePriority which is either Red, Amber or Green. The results are returned to a HTML page. I ...
2
votes
2answers
63 views

Is there a way to query two SharePoint Choice columns in the same list?

I have a SharePoint list that I'm querying using Javascript and JSON. I have two choice columns called LifeCycleStatus and Priority. The results for LifeCycleStatus is coming back fine, but for ...
3
votes
1answer
146 views

Displaying an image from a SharePoint list using Javascript on a HTML page

I have a JavaScript page which queries a SharePoint list. I used an InfoPath form to add a jpg to an item. Now I want to display the image on a HTML page with the rest of the results. The jpg url is ...
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 ...
1
vote
0answers
174 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/...
0
votes
1answer
54 views

How to copy columns name from a list(form) to a library using SPD 2013?

I have a form in SPD which has 2 columns PM & DM , how will i copy same column names from the form to library using javascript JSON so that on form submits the library column name automatically ...
0
votes
2answers
615 views

Get SharePoint parent ID with REST API

This is my code at the moment. With this I get the information of a site. And of the requested site I want to get the parent ID. I found a query: _api/Web/Lists/getByTitle('TaskListName')/items(3)/...
2
votes
4answers
3k views

How to GetListItems as JSON using Powershell with SharePoint Online?

I need to output the items in a SharePoint list into a *.json file for our web development team. I've successfully connected to and loaded the list using Powershell, but I'm unsure what the best ...
0
votes
1answer
207 views

Build JSON : POST With array

Hi i want make a Json for my POST with a array who contain all my modifications like : var tabname = ["test 1", "Test 2", "Test 3"]; var tabID = [1, 2, 3]; to build at the end a json ...
1
vote
0answers
107 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 ...
2
votes
1answer
585 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
2answers
73 views

How do I define assign the results of an ajax call to an object property using defineProperty?

I am trying to assign the results of an ajax call to an object property that I created using the JavaScript defineProperty method. var myArray = getArrayOfListsForObjects(); //returns an array of ...
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
2answers
43 views

Two part question concerning AJAX / OData

So in a custom .aspx form, I use an AJAX call to get current list item data. When I copy "MYSITE" into my browser, I get a page that looks like a blank RSS feed. Any idea as to why this is? The code ...
1
vote
1answer
312 views

Sharepoint with WCF Service HTTP request

I have a Sharepoint solution with a WCF Service and a simple get method that returns a "Hello world". When making the request however, it doesn't return anything and I don't get any error either. Any ...
2
votes
3answers
574 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
302 views

extract group membership from JSON (SharePoint Designer)

I have created a workflow that calls https://site.sharepoint.com/sites/site/_api/Web/CurrentUser and stores the user ID in a variable called userId. I am then passing that userId into another call /...
0
votes
1answer
62 views

How to update a column with result of calculating a column in another list

Using SharePoint Online, I have 2 lists: A and B. There are 2 columns in A: EmpCode, Sum There are 2 column in B: EmpCode, Number I want to update Sum in List A with the sum of Number in List B ...
0
votes
2answers
163 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
1answer
2k views

Create list from JSON

I know JSON is the returned value structure from REST calls but I want to go the other way... I want to create a list from a JSON blob using REST. Is it possible? Edit 1: I was pretty vague above so ...
1
vote
2answers
95 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 ...