Web API returns empty json array

Question

I've traced through the my method (below) at run time. Below the code I've included a screenshot of the Debug examination of the Portfolios list just before the return statement. I've expanded a couple of the list entries. As you can see, each Portfolio object contains bona fide data - a numeric Id and a string name.

Yet, here's what comes back to the Chrome browser, or postman, no difference.

[{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]

What's happening to all the data? Thanks for your help!

    // GET: api/Portfolio
    [HttpGet]
    public List<Portfolio> Get()
    {
        List<Portfolio> Portfolios = new List<Portfolio>();

        using (SqlConnection cn = new SqlConnection(conn))
        {
            SqlCommand cmd = cn.CreateCommand();
            cmd.CommandText = sqlSelectPortfolios;
            cn.Open();
            SqlDataReader rdr = cmd.ExecuteReader();
            Portfolio pf;

            while (rdr.Read())
            {
                pf = new Portfolio
                {
                    id = (int)rdr["PortfolioId"],
                    name = (string)rdr["PortfolioName"]
                };

                Portfolios.Add(pf);
            }
        }

        return Portfolios;
    }

Debug:

If id and name are fields and you're using System.Text.Json.JsonSerialiser than it won't serialise them as of Nov 2019. — tmaj
– tmaj, Commented Nov 10, 2019 at 2:03
Does this answer your question? How to use class fields with System.Text.Json.JsonSerializer? — tmaj
– tmaj, Commented Nov 10, 2019 at 2:04

tmaj · Accepted Answer · 2019-11-10 02:07:29Z

9

The id and name need to be public and properties. As of 3.0 System.Text.Json.JsonSerializer does not serialize fields.

public class Portfolio 
{
public int id {get; set;}
public string name {get; set;}
}

answered Nov 10, 2019 at 2:07

tmaj

35.9k12 gold badges108 silver badges143 bronze badges

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

2 Comments

Yossi G. Over a year ago

Thank you!! I had them as public but not defined as properties. As soon as I redefined these as properties I got the expected results.

tmaj Over a year ago

The issue is logged as JsonSerializer should support field as well as properties #36505

Collectives™ on Stack Overflow

Web API returns empty json array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related