Removing the column name from a JSON return in C# involves using a variety of techniques

Question

Removing the column name from a JSON return in C# involves using a variety of techniques

Below is a JSON output I have received :

[
    {
        positionCode: "POS1",
        positionName: "POSITION 1",
        positionDescription: "",
        parentPosition: "POS2",
    },
    {
        positionCode: "POS2",
        positionName: "POSITION 2",
        positionDescription: "",
        parentPosition: "POS3",
    }
]

This JSON data is the result of calling my Web API, which has the following structure :

return new JsonResult(query.Select(x => 
new { x.PositionCode, x.PositionName , x.PositionDescription , x.ParentPosition }).ToList());

However, I would like the output to look similar to this image : https://i.stack.imgur.com/9OUuX.png

What changes should I make in either my JavaScript code or C# Web API to achieve the desired outcome? Thank you!

javascript c#arrays json api

Answer 1

Answer №1

Assuming your setup is similar to the following:

var dataList = new List<PositionClass>
{
    new PositionClass { PositionCode = "POS1", PositionName = "POSITION 1", PositionDescription = "", ParentPosition = "POS2" },
    new PositionClass {  PositionCode = "POS2", PositionName = "POSITION 2", PositionDescription = "", ParentPosition = "POS2" }
};

You have two choices available:

Manage it within your C# code

Since you already have linq, convert your List<T> into an array or strings like this:

dataList.Select(data => new[] {data.ParentPosition, data.PositionCode, data.PositionDescription, data.PositionName}).ToArray()

Manage it within your JavaScript code

const response = [{
    positionCode: "POS1",
    positionName: "POSITION 1",
    positionDescription: "",
    parentPosition: "POS2",
  },
  {
    positionCode: "POS2",
    positionName: "POSITION 2",
    positionDescription: "",
    parentPosition: "POS3",
  }
];

const reformatted = response.map(res => Object.values(res))

console.log(reformatted);

Answer 2

Assuming your setup is similar to the following:

var dataList = new List<PositionClass>
{
    new PositionClass { PositionCode = "POS1", PositionName = "POSITION 1", PositionDescription = "", ParentPosition = "POS2" },
    new PositionClass {  PositionCode = "POS2", PositionName = "POSITION 2", PositionDescription = "", ParentPosition = "POS2" }
};

You have two choices available:

Manage it within your C# code

Since you already have linq, convert your List<T> into an array or strings like this:

dataList.Select(data => new[] {data.ParentPosition, data.PositionCode, data.PositionDescription, data.PositionName}).ToArray()

Manage it within your JavaScript code

const response = [{
    positionCode: "POS1",
    positionName: "POSITION 1",
    positionDescription: "",
    parentPosition: "POS2",
  },
  {
    positionCode: "POS2",
    positionName: "POSITION 2",
    positionDescription: "",
    parentPosition: "POS3",
  }
];

const reformatted = response.map(res => Object.values(res))

console.log(reformatted);

Answer 3

Answer №2

To achieve this, JavaScript's Object.values() function can be utilized.

var data = [{ positionCode: "POS1", positionName: "POSITION 1", positionDescription: "", parentPosition: "POS2", }, { positionCode: "POS2", positionName: "POSITION 2", positionDescription: "", parentPosition: "POS3", }]; 

var result = [];

data.forEach(item => {
  result.push(Object.values(item));
});

console.log(result);

Answer 4

To achieve this, JavaScript's Object.values() function can be utilized.

var data = [{ positionCode: "POS1", positionName: "POSITION 1", positionDescription: "", parentPosition: "POS2", }, { positionCode: "POS2", positionName: "POSITION 2", positionDescription: "", parentPosition: "POS3", }]; 

var result = [];

data.forEach(item => {
  result.push(Object.values(item));
});

console.log(result);

Answer 5

Answer №3

When you need an array of string values instead of selecting an anonymous object with string properties, you can modify the code as shown below:

var result = query.Select(x => new string[] { x.PositionCode, x.PositionName, x.PositionDescription, x.ParentPosition }).ToList();
return new JsonResult(result);

Answer 6

When you need an array of string values instead of selecting an anonymous object with string properties, you can modify the code as shown below:

var result = query.Select(x => new string[] { x.PositionCode, x.PositionName, x.PositionDescription, x.ParentPosition }).ToList();
return new JsonResult(result);

Removing the column name from a JSON return in C# involves using a variety of techniques

Answer №1

Answer №2

Answer №3

Similar questions

Upload a binary file as a parameter in JSON format by utilizing multipart/form-data within a curl POST request

In search of an efficient method to verify JSON input using the Play framework

Turning an Array of Objects into a typical JavaScript Object

Guide for accessing and interpreting a random folder arrangement using JavaScript located alongside index.html

How can I display and utilize the selected value from a Rails select form before submitting it?

Reveal concealed fields following the selection of a specific option

% unable to display on tooltip pie chart in highcharts angular js

Passing an array of selected values from Vue.js to a text area and adding them to the existing content

Error in Chart.jsx: Unable to retrieve the length property of an undefined object in the COVID-19 Tracker App

Show a Toast in React without relying on useEffect to manage the state

Extracting data from website's table using JavaScript and opening the link in href

Importing an array into DynamoDB using a JSON string with boto3

Jackson will not convert null values using a personalized Serializer

Using jQuery to combine the values of text inputs and checkboxes into a single array or string

Tips for filling jstree with information in Grails

Tips for modifying environment variables for development and production stages

Click event not functioning correctly in Internet Explorer

What is the jQuery syntax for targeting a specific element within an object?

Using TypeScript's type casting functionality, you can easily map an enum list from C#

Assign Monday as the selected day of the week in the MUI Datepicker 6