how to deserialize the property which has xml value but rest are json values

Question

I have an azure function and which receives the request as below . One of the property has xml value . But when I desearialize it to json ,i'm getting the error.

{
    "policyVersionedApiName": "petstoreoperationpolicyapi",
    "operationPolicies": [
        {
            "policyFormat": "rawxml",
            "operationId": "createUsersWithArrayInput",
             "policyValue": "<policies> <inbound> <base/> <ip-filter action="allow"> <address>10.100.7.1</address> </ip-filter> </inbound> </policies>",
        }
       
    ]
}

please share more detail about the error – Richard Jul 15 '22 at 04:07 — Richard, Jul 15 '22 at 04:07

Serge · Answer 1 · 2022-07-15T12:15:53.067

0

you have to replace double quotes inside of json string by escape double quoutes

json = json.Replace("\">", "\\\">").Replace("=\"", "=\\\"");

If you need , you can convert xml to json too

    var jsonParsed = JObject.Parse(json);

    XmlDocument xmlDoc = new XmlDocument();
    xmlDoc.LoadXml((string)jsonParsed["operationPolicies"][0]["policyValue"]);
    XmlNode node = xmlDoc.SelectSingleNode("policies");

    jsonParsed["operationPolicies"][0]["policyValue"] = JObject.Parse(JsonConvert.SerializeXmlNode(node));
    
    json = jsonParsed.ToString();

a new json

{
  "policyVersionedApiName": "petstoreoperationpolicyapi",
  "operationPolicies": [
    {
      "policyFormat": "rawxml",
      "operationId": "createUsersWithArrayInput",
      "policyValue": {
        "policies": {
          "inbound": {
            "base": null,
            "ip-filter": {
              "@action": "allow",
              "address": "10.100.7.1"
            }
          }
        }
      }
    }
  ]
}

edited Jul 15 '22 at 12:15

answered Jul 15 '22 at 10:42

Serge

40,935
4
18
45

Thanks. But I’m looking for generic solution because it changes in every request . – Ramesh Baddam Jul 15 '22 at 12:01
@RameshBaddam It is a generic solution. – Serge Jul 15 '22 at 12:01
Sorry for making you confused . I wanted xml value to be as is . I do not want to split into individual properties . But the string should be as is – Ramesh Baddam Jul 15 '22 at 12:13
@RameshBaddam You don't need to split it, just use the first line of my code. – Serge Jul 15 '22 at 12:14
its not working all the xml content. Moreover the policy can contain c# code as well – Ramesh Baddam Jul 18 '22 at 03:18
one more example – Ramesh Baddam Jul 18 '22 at 03:26
@RameshBaddam I can create a string analisator to fix it, but it is a big job, and I am not a free coder to do it for you. Much easier to fix this json in the place where it is created. – Serge Jul 18 '22 at 05:19

how to deserialize the property which has xml value but rest are json values

1 Answers1