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.

86 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
1answer
691 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 ...
3
votes
0answers
677 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 ...
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 ...
2
votes
0answers
744 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
487 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
76 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
938 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
359 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
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
335 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
0answers
41 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
50 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 ...
1
vote
0answers
73 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 ...
1
vote
0answers
34 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 ...
1
vote
0answers
199 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 ...
1
vote
2answers
30 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 ...
1
vote
0answers
189 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 ...
1
vote
1answer
434 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
165 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
598 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
58 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
282 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
525 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
1k 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
163 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
212 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
135 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
111 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
64 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
980 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
91 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
219 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
292 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
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,...
1
vote
0answers
647 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
0answers
15 views

addContentType to default view JSON template

Ok I have been messing around with this JSON template for awhile now, just dove into content types and got them to work after some help. Now I can get the content type to populate in the library ...
0
votes
1answer
39 views

JSON Sharepoint - validating dates across several columns with boolean column

I'm beginner/intermediate when it comes to SharePoint JSON, and I've been trying all sorts of conditional logic to make an empty column txtContent show 'Yes' or 'No'. There are 7 columns (all date ...
0
votes
2answers
48 views

Sharepoint online list view formatting DefaultHoverView using forEach

I am using Sharepoint list JSON view-formatting and want a list of names to each show their live persona card on hover. I can get this to work for just one name, but when I use forEach I cannot get ...
0
votes
0answers
15 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 ...
0
votes
1answer
32 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", "...
0
votes
0answers
45 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
91 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
35 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 ...
0
votes
1answer
43 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 ...
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 ...
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 ...
0
votes
0answers
57 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 ...