Using WebApi create Json format not in propery format

Question

OutPut:

{
  "$id": "1",
  "_MenuList": [
    {
      "$id": "2",
      "parentId": 3,
      "menuName": "Details"
    },
    {
      "$id": "3",
      "parentId": 1,
      "menuName": "No of Details"
    }
  ]
}

In output "$id" autogenerate how to remove this.

Format Code Controller :

 [Route("MenuController/getMenuList/input")]
    [HttpPost]
    public ReportMenu getMenuList([FromBody]LoginModel input)
    {
        DataTable reportvalue = new DataTable();
        try
        {
            using (SqlConnection dataConnection = ConnectionString.getConnection())
            {
                SqlCommand command = new SqlCommand("USP_ReportMenu", dataConnection);
                command.Parameters.AddWithValue("@userName", input.userName);
                command.Parameters.AddWithValue("@password", input.password);
                command.CommandType = CommandType.StoredProcedure;
                using (SqlDataAdapter reportAdapter = new SqlDataAdapter(command))
                {

                    reportAdapter.Fill(reportvalue);

                }
            }
        }
        catch (SqlException ex)
        {

        }
        return getJson(reportvalue);

    }

public ReportMenu getJson(DataTable tb)
{
        ReportMenu menu = new ReportMenu();
        List<MenuModel> listMenu = new List<MenuModel>();
        for (int i = 0; i < tb.Rows.Count; i++)
        {
            MenuModel obj=new MenuModel();
            obj.parentId = Convert.ToInt16(tb.Rows[i]["parentId"].ToString());
            obj.menuName = tb.Rows[i]["reportName"].ToString();
            listMenu.Add(obj);


        }

        menu._MenuList = listMenu;
        return menu;
    }

I want To this Type of ouput:

{"_MenuList": [
    {
      "parentId": 3,
      "menuName": "Details"
    },
    {
      "parentId": 1,
      "menuName": "No of Details"
    }
  ]
}

Kindly help for us.. I am new in Web API.

This looks like your json serializer settings, without the code it's difficult to say: but check this out: http://stackoverflow.com/a/23461179/4045532 — Corporalis
– Corporalis, Commented Sep 12, 2016 at 11:41
I use JsonSerilizer class but auto generate $id which i don't requried. — Hemina
– Hemina, Commented Sep 12, 2016 at 12:23

Corporalis · Accepted Answer · 2016-09-12 12:56:34Z

2

Based on the comments, what you'll need to do (as per the article I added in the comments) is replace:

json.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;

With this:

json.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;

That will then ignore any reference handling, but you will get your desired result.

answered Sep 12, 2016 at 12:56

Corporalis

1,0721 gold badge9 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Using WebApi create Json format not in propery format

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