Automapper: converting JSON to a list of objects
Original Object (JSON, using JSON.NET if it matters):
{
"conum" : 1001,
"name" : "CLN Industries Corporation",
"agencyName" : "Murphy, Holmes & Associates, LLC",
"sAA" : [{
"code" : 247,
"description" : "Mechanic\u0027s lien - Bond to Discharge - Fixed penalty - where principal has posted Performance and Pa"
}, {
"code" : 277,
"description" : "Mechanic\u0027s lien - Bond to Discharge - Open Penalty - where principal has posted Performance and Paym"
}, {
"code" : 505,
"description" : "Indemnity Bonds - Contractor\u0027s Indemnity Against Damages where there is a performance bond and addit"
}
]
}
Destination (C #):
public class CorporateRatesInfo
{
public string Conum { get; set; }
public string Name { get; set; }
public string AgencyName { get; set; }
public List<SaaCode> SaaCodes { get; set; }
}
public class SaaCode
{
public string Code { get; set; }
public string Description { get; set; }
}
Automapper config and mappings:
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap<JObject, CorporateRatesInfo>();
cfg.AddProfile<CorporateRatesProfile>();
});
//config.AssertConfigurationIsValid();
_mapper = config.CreateMapper();
public class CorporateRatesProfile : Profile
{
protected override void Configure()
{
CreateMap<JObject, CorporateRatesInfo>()
.ForMember("SaaCodes", cfg => { cfg.MapFrom(jo => jo["sAA"]); })
.ForMember("Conum", cfg => { cfg.MapFrom(jo => jo["conum"]); })
.ForMember("Name", cfg => { cfg.MapFrom(jo => jo["name"]); })
.ForMember("AgencyName", cfg => { cfg.MapFrom(jo => jo["agencyName"]); });
}
}
Everything works except the SaaCodes conversion where Automapper converts each record to an empty SaaCode object (all properties are set to zero).
How / where can I tell the automapper how to convert the items in this JSON field to its destination type?
+2
source to share
1 answer
Try it -
public class CorporateRatesInfo
{
public string Conum { get; set; }
public string Name { get; set; }
public string AgencyName { get; set; }
public List<SaaCode> SaaCodes { get; set; }
}
public class SaaCode
{
public string Code { get; set; }
public string Description { get; set; }
}
public class CorporateRatesProfile : Profile
{
protected override void Configure()
{
CreateMap<JObject, SaaCode>()
.ForMember("Code", cfg => { cfg.MapFrom(jo => jo["code"]); })
.ForMember("Description", cfg => { cfg.MapFrom(jo => jo["description"]); });
CreateMap<JObject, CorporateRatesInfo>()
.ForMember("SaaCodes", cfg => { cfg.MapFrom(jo => jo["sAA"]); })
.ForMember("Conum", cfg => { cfg.MapFrom(jo => jo["conum"]); })
.ForMember("Name", cfg => { cfg.MapFrom(jo => jo["name"]); })
.ForMember("AgencyName", cfg => { cfg.MapFrom(jo => jo["agencyName"]); });
}
}
class Program
{
static void Main(string[] args)
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap<JObject, CorporateRatesInfo>();
cfg.AddProfile<CorporateRatesProfile>();
});
//config.AssertConfigurationIsValid();
var mapper = config.CreateMapper();
var jsonText = @"
{
""conum"" : 1001,
""name"" : ""CLN Industries Corporation"",
""agencyName"" : ""Murphy, Holmes & Associates, LLC"",
""sAA"" : [{
""code"" : 247,
""description"" : ""Mechanic\u0027s lien - Bond to Discharge - Fixed penalty - where principal has posted Performance and Pa""
}, {
""code"" : 277,
""description"" : ""Mechanic\u0027s lien - Bond to Discharge - Open Penalty - where principal has posted Performance and Paym""
}, {
""code"" : 505,
""description"" : ""Indemnity Bonds - Contractor\u0027s Indemnity Against Damages where there is a performance bond and addit""
}
]
}
";
var jsonoObj = JObject.Parse(jsonText);
CorporateRatesInfo dto = mapper.Map<CorporateRatesInfo>(jsonoObj);
}
}
+4
source to share