remove columns/adjust model in API MVC[Answered] RSS

• • Reply
  alexi

  Member

  3 Points

  16 Posts

  remove columns/adjust model in API MVC

  Apr 29, 2020 02:19 PM|alexi|LINK

  I built a simple API to get some data I use in JavaScript code on a different page. I'm a bit new to MVC framework, (an inspired convert from ASP.NET forms), so not sure exactly how do I adjust the columns that it spits out. This is my code:

   [Route("api/[controller]")]
      public class GetUserDefaultsAPIController : Controller
      {
          private readonly ApplicationDbContext _context;
  
          public GetUserDefaultsAPIController(ApplicationDbContext context)
          {
              _context = context;
          }
  
          [HttpGet] 
          public async Task<ActionResult<MyMVC.Models.UserDefaults>> GetDefaultsAPI()
          {
  
              int ProfileId = GetSelectedProfileIdfromCookie(); // custom function  
              var UserDefaultsModel = await _context.UserDefaults.FirstOrDefaultAsync(m => m.cId == ProfileId);
              if (UserDefaultsModel == null)
              {
                  return NotFound();
              }
  
              return UserDefaultsModel ;
          }

  This code then spits out a nice JSON which I can directly use (based on UserDefaultsModel row with a certain Id). The problem is that it has a few fields that are not necessary (like Id, among some others). At this stage I manually use JavaScript to delete those, but it would be nice if I could do it first server-side so don't have to do this client side?

  Much appreciated

• • Reply
  bruce (sqlwo...

  All-Star

  56344 Points

  14701 Posts

  Re: remove columns/adjust model in API MVC

  Apr 29, 2020 03:05 PM|bruce (sqlwork.com)|LINK

  In the model you can use the [JsonIgnore] attribute to suppress fields, but it is better to create a response model that only has what you want. 
  
  

  bruce (sqlwork.com)
• • Reply
  DA924

  Contributor

  4623 Points

  3898 Posts

  Re: remove columns/adjust model in API MVC

  Apr 29, 2020 03:27 PM|DA924|LINK

  You can use a DTO.

  https://en.wikipedia.org/wiki/Data_transfer_object

  https://docs.microsoft.com/en-us/aspnet/web-api/overview/data/using-web-api-with-entity-framework/part-5

  If you find the post has answered your issue, then please mark post as 'answered'.