Extract property values from the JSON array

Question

I have the following JSON being sent from Postman to my Web API.

[
    {
        "salesId": "SO002494"
    },
    {
        "salesId": "SO002496"
    } 
]

Sales Model

public class Sales
{
    public string[] salesId { get; set; }
}

[HttpGet("postRouteOrder")]
public async Task<ActionResult<string>>PostRouteOrder([FromBody] Object json)
{
    Sales sales = new Sales();

    sales.salesId = Newtonsoft.Json.JsonConvert.DeserializeObject<dynamic>(json.ToString());
           
    //string[] data = { "SO002604", "SO002606" };               
}

I want sales.salesId to be like data.

And it's weird that you post an object via [HttpGet]. You should use [HttpPost]. — Yong Shun
– Yong Shun, Commented Apr 8, 2022 at 11:07
This is because my web API is an interface between an application and a SOAP API server. The SOAP API will do the [HttpPost] — Toxic
– Toxic, Commented Apr 8, 2022 at 11:22

Toxic · Accepted Answer · 2022-04-09 17:44:10Z

1

Would suggest changing the request body parameter type to List<SaleInput>.

using System.Linq;

[HttpPost]
public async Task<ActionResult<string>> PostRouteOrder ([FromBody] List<SaleInput> saleInputs)
{

    string[] data = saleInputs.Select(x => x.SalesId).ToArray();
}

public class SaleInput
{
    public string SalesId { get; set; }
}

Apart from that, instead of deserializing as dynamic, you should deserialize as List of objects and take the SalesId as an array.

List<SaleInput> saleInput = Newtonsoft.Json.JsonConvert.DeserializeObject<List<SaleInput>>(/* JSON */);

sales.salesId = saleInputs.Select(x => x.SalesId)
        .ToArray();

edited Apr 9, 2022 at 17:44

Toxic

1058 bronze badges

answered Apr 8, 2022 at 10:56

Yong Shun

54.6k6 gold badges38 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extract property values from the JSON array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related