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

Retrieving arguments of a specified function in PHP

Place an element in relation to the vertical size of a div that includes written content

There is a delay in updating ng-if/ng-hide in real time on the HTML page

What steps should be taken to effectively integrate Amplify Authenticator, Vue2, and Vite?

Is there a way to incorporate both max-width and min-width in a matchMedia query effectively?

Ways to retrieve a specific value from a JSON dataset

Custom JavaScript clock designed for the Lockscreen of jailbroken iPhones

Using useState props in React Native navigation screens with React Navigation

Struggling with updating state using splice method within an onClick event in React Hooks

Develop a fresh button using either JavaScript or PHP

Utilizing JQueryMobile, JSON, and transferring data to a fresh webpage

Utilizing 'nestjs/jwt' for generating tokens with a unique secret tailored to each individual user

Unable to retrieve HTML code from a webpage using its URL address

Why am I unable to make a selection in the dropdown menu?

What is the best way to update the color of a v-select component?

Aggregate data by various categories and compute a total sum

Exploring the implications of Content Security Policy in conjunction with mod_pagespeed evaluations

Is It Possible to Use Separate Stylesheets for Different Web Browsers?

I am having trouble establishing a connection to the JavaScript MQTT server

Creating an array of objects sorted in alphabetical order