No announcements
Found 832742 threads
-
0 Votes
Returning JSON Array
Hi HanneSThEGreaT, If you set ResponseFormat:=WebMessageFormat.Json then you will get output as a json array.Answered | 2 Replies | 968 Views | Created by HanneSThEGreaT - Thursday, September 10, 2015 6:36 AM | Last reply by Jimyken - Wednesday, September 16, 2015 8:54 AM -
0 Votes
Sql 2016 returning large JSON of array of objects to C# service
HI Sathya, when my JSON array has lot of objects, SQL splits the result into multiple rows.Answered | 4 Replies | 5684 Views | Created by singhhome - Saturday, February 11, 2017 3:09 AM | Last reply by Albert_ Zhang - Monday, February 13, 2017 11:46 AM -
0 Votes
LogicApp functions - Array of JSON
Hey, i have this array ...Answered | 1 Replies | 604 Views | Created by Karim samir - Friday, January 31, 2020 8:10 AM | Last reply by sujith reddy komma - Friday, January 31, 2020 9:13 AM -
1 Votes
Using Liquid Transform - JSON array to JSON array as simple as possible
I found this article that I think covers my scenario.Answered | 2 Replies | 3248 Views | Created by Roitto Gil - Wednesday, September 12, 2018 12:32 PM | Last reply by Roitto Gil - Friday, September 14, 2018 7:35 AM -
2 Votes
Single element XML to JSON Array
If not, I am missing the brackets for arrays in the @json(xml(Trigger_Body())) call.Answered | 9 Replies | 16019 Views | Created by Tecodo - Brian A. Lemaster - Monday, April 3, 2017 3:16 PM | Last reply by Doug Waterfield - Thursday, September 28, 2017 8:33 PM -
0 Votes
Json array property ingestion
I will assume that there is no other way of transposing child array into columns without pre-processing the json, flattening it and ...Answered | 8 Replies | 1441 Views | Created by deyanp - Friday, February 14, 2020 12:15 PM | Last reply by Mike Ubezzi (Azure) - Friday, February 21, 2020 11:08 PM -
0 Votes
read a json file and return contents
Generally, we don't use return.Answered | 4 Replies | 3110 Views | Created by zidsal - Tuesday, October 30, 2012 6:47 PM | Last reply by jag0 - Friday, July 12, 2013 1:59 PM -
2 Votes
json array to table
Found answer here- http://mtkcode.blogspot.com/2014/08/parse-json-string-by-sql-script.htmlAnswered | 11 Replies | 1185 Views | Created by Papil1 - Sunday, June 3, 2018 3:56 AM | Last reply by Papil1 - Tuesday, June 5, 2018 2:13 AM -
0 Votes
Deserializing a JSON array of mixed types
Hi Mike, In addition to what Juyu mentioned, you should also add the certain custom types(that will be deserialized from the JSON request ...Answered | 3 Replies | 11772 Views | Created by MikeHixson - Monday, October 11, 2010 12:46 AM | Last reply by krisragh - Wednesday, October 13, 2010 4:01 AM -
1 Votes
JSON to C# array of objects
Json is not smart that can recognize these types.Answered | 6 Replies | 8229 Views | Created by scanales - Monday, November 7, 2016 9:23 PM | Last reply by Kristin Xie - Tuesday, December 13, 2016 9:37 AM -
0 Votes
deserializing a JSON object containing array of arrays
You should receive the values to an array of arrays, then convert them into your data type using the OnDeserialized callback for the serializer:Answered | 1 Replies | 7608 Views | Created by JohnnyC - Monday, January 19, 2009 9:27 PM | Last reply by Carlos Figueira - Monday, January 19, 2009 10:10 PM -
2 Votes
Serializing JSON object array when application suspends
JSON.stringify and JSON.parse are standard functions (https://developer.mozilla.org/en/JavaScript/Reference/Global_Objects/JSON/stringify) so you can use them without any external ...Answered | 3 Replies | 3151 Views | Created by Gaurav Mantri - Monday, December 26, 2011 3:39 PM | Last reply by Joe Levy_ - Tuesday, December 27, 2011 7:20 AM -
6 Votes
Nested Arrays JSON Paths
I feel it's the json pathing for the nested arrays I'm just messing up.Answered | 20 Replies | 9375 Views | Created by ElliotParker - Thursday, February 23, 2017 11:41 AM | Last reply by SQLJasonG - Friday, December 21, 2018 8:51 PM -
4 Votes
Splitting JSON Object Array into smaller sized "chunks"
That would then start n runs if you have n records in your array.Answered | 6 Replies | 3671 Views | Created by Faisal Tahiri - Friday, March 23, 2018 2:20 AM | Last reply by sujith reddy komma - Wednesday, April 4, 2018 6:07 PM -
0 Votes
Parsing JSON with arrays RRS feed
convertfrom-json не работает?Answered | 3 Replies | 1971 Views | Created by Denis.Pasternak - Saturday, October 5, 2019 9:10 AM | Last reply by Richard Mueller - Monday, November 4, 2019 2:16 PM -
0 Votes
Issue with converting xml to json - single element array
I have fixed the issue by modifying the xml with adding namespace and attribute to force the array.Answered | 2 Replies | 1573 Views | Created by Vinoth n - Wednesday, September 18, 2019 1:37 PM | Last reply by Vinoth n - Friday, September 20, 2019 9:24 AM -
4 Votes
Reading data from JSON that has arrays.
The weather service I want to use only has json avaliable to me.Answered | 8 Replies | 4635 Views | Created by ArchonTiger - Friday, December 17, 2010 4:34 PM | Last reply by Saad Mahmood - Tuesday, August 13, 2013 7:42 AM -
1 Votes
Modify json array
DECLARE @vJson AS NVARCHAR(4000) = ...Answered | 13 Replies | 1658 Views | Created by Zero3000 - Friday, September 27, 2019 1:57 PM | Last reply by Jingyang Li - Thursday, January 30, 2020 7:25 PM -
2 Votes
Returning arrays
Rtizan[0] is right, the best datatype to replace your array would be: List<type>.Answered | 3 Replies | 3516 Views | Created by mreynol6 - Tuesday, July 22, 2008 2:15 PM | Last reply by Michael Reynolds - Tuesday, July 22, 2008 3:36 PM -
2 Votes
How to create json array as a string with Object list
Up until the recent release, .NET doesn't have JSON support built in.Answered | 2 Replies | 544 Views | Created by Learning Rocks - Thursday, April 23, 2020 12:59 PM | Last reply by CoolDadTx - Thursday, April 23, 2020 2:00 PM - Items 1 to 20 of 832742 Next ›
No announcements