CODEWITHSUNDEEP
c#apiasp.net-core
sgrysoft
sgrysoft

Reputation: 628

How to return a Json from a list in an api without the properties names in netcore

for some legacy code, I need to return a list of rows than come from a list of the element, but, the client needs it without the property name.

This is what I need. (I know that inside this JSON return, it's an array list then it's not a valid JSON, but is the way that needs to be received by the front end I don't know why

{ "success":true,"msg":"","draw":"1","recordsTotal":14,"recordsFiltered":14,
{ "data": 
[
["Xiaomi","Redmi 8","10","6.0.1","","sadsadasd"],
["Xiaomi","Redmi 8","10","6.0.1","","sadsadasd"],
]
 }

This is what I got now

{"success":true,"msg":"","draw":"1","recordsTotal":14,"recordsFiltered":14,
  "data" :[
    {"Brand":"Xiaomi","Model":"Redmi 8","Version":10,"App":"4.3.3","Phone":"","AsignedUSer":"ceererer"},
    {"Brand":"Xiaomi","Model":"Redmi 8","Version":10,"App":"4.3.3","Phone":"","AsignedUSer":"ceererer"},
     ]
    }

And this is the code how I am retrieving the data

 return new JsonResult(new { success = true, msg = "",  draw ="1", recordsTotal = listToReturn.Count(),  recordsFiltered = listToReturn.Count() , 
   data =   listToReturn , 
            });

Upvotes: 1

Views: 808

Answers (2)

Crowcoder
Crowcoder

Reputation: 11514

You could project your list into arrays to extract the property values:

var data = listToReturn
.Select(d => new string[]{d.Brand, d.Model, d.Version, etc..})
.ToList();

Upvotes: 2

rafakwolf
rafakwolf

Reputation: 23

Note that a "JSON" content without the property names will be a not valid JSON document. What you need seems to be more like a CSV-like response. Have you tried to format the result as CSV?

Upvotes: 0

Related Questions