{"id":24477,"date":"2022-12-03T06:41:04","date_gmt":"2022-12-03T01:11:04","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/"},"modified":"2022-12-03T06:41:04","modified_gmt":"2022-12-03T01:11:04","slug":"solved-foreach-on-json-based-on-value-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/","title":{"rendered":"[Solved] Foreach on Json based on value [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-48105912\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"48105912\" data-parentid=\"48105792\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Here is a crude example, that uses the <code>Newtonsoft.Json<\/code> nuget package, you can work from and use as inspiration perhaps. It groups by table name and then gets the list for each one. You may want to do it differently I&#8217;m not sure.<\/p>\n<pre><code>var o = JsonConvert.DeserializeObject&lt;root&gt;(json);\nvar groups = o.tabla.GroupBy(t =&gt; t.nombretabla);\n\nforeach (var group in groups)\n{\n    var tableName = group.Key;\n\n    var tabla = group.FirstOrDefault();\n    if (tabla != null)\n    {\n        var list = tabla.campostabla.campo.ToList();\n\n        foreach (var item in list)\n        {\n            Console.WriteLine(item);\n        }\n    }\n}\n<\/code><\/pre>\n<p>Boiler plate classes that you should change as required&#8230;<\/p>\n<pre><code>public class root\n{\n    public Tabla[] tabla { get; set; }\n}\n\npublic class Tabla\n{\n    public string nombretabla { get; set; }\n    public CamposTabla campostabla { get; set; }\n    public string filtro { get; set; }\n}\n\npublic class CamposTabla\n{\n    public string[] campo { get; set; }\n}\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">0<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Foreach on Json based on value [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Here is a crude example, that uses the Newtonsoft.Json nuget package, you can work from and use as inspiration perhaps. It groups by table name and then gets the list for each one. You may want to do it differently I&#8217;m not sure. var o = JsonConvert.DeserializeObject&lt;root&gt;(json); var groups = o.tabla.GroupBy(t =&gt; t.nombretabla); foreach &#8230; <a title=\"[Solved] Foreach on Json based on value [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\" aria-label=\"More on [Solved] Foreach on Json based on value [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[324,356,540],"class_list":["post-24477","post","type-post","status-publish","format-standard","hentry","category-solved","tag-c","tag-json","tag-list"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Foreach on Json based on value [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Foreach on Json based on value [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Here is a crude example, that uses the Newtonsoft.Json nuget package, you can work from and use as inspiration perhaps. It groups by table name and then gets the list for each one. You may want to do it differently I&#8217;m not sure. var o = JsonConvert.DeserializeObject&lt;root&gt;(json); var groups = o.tabla.GroupBy(t =&gt; t.nombretabla); foreach ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-03T01:11:04+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Foreach on Json based on value [closed]\",\"datePublished\":\"2022-12-03T01:11:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\"},\"wordCount\":70,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"c++\",\"json\",\"list\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\",\"name\":\"[Solved] Foreach on Json based on value [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-03T01:11:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Foreach on Json based on value [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Foreach on Json based on value [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Foreach on Json based on value [closed] - JassWeb","og_description":"[ad_1] Here is a crude example, that uses the Newtonsoft.Json nuget package, you can work from and use as inspiration perhaps. It groups by table name and then gets the list for each one. You may want to do it differently I&#8217;m not sure. var o = JsonConvert.DeserializeObject&lt;root&gt;(json); var groups = o.tabla.GroupBy(t =&gt; t.nombretabla); foreach ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-03T01:11:04+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Foreach on Json based on value [closed]","datePublished":"2022-12-03T01:11:04+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/"},"wordCount":70,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["c++","json","list"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/","name":"[Solved] Foreach on Json based on value [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-03T01:11:04+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-foreach-on-json-based-on-value-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Foreach on Json based on value [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/24477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=24477"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/24477\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=24477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=24477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=24477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}