如何在自适应对话框HttpRequest中从xml转换为json? [英] How to convert from xml to json within Adaptive dialog HttpRequest?

问题描述

我是Bot Framework和C#的新手.我正在使用带有核心航班预订模板( adaptive-dialog/03.core-bot ).我想进行API调用以获取天气信息.此OpenWeather API可以返回JSON，XML或HTML格式的数据.当响应为JSON格式时，很容易访问键值对.但是，当响应为XML格式时，所有内容都将转换为字符串并在响应中另存为内容"，我必须将其转换为JSON或Dictionary，以便访问详细信息.而且我需要将API响应另存为对话框中的一个属性，以供以后参考.

I am new to Bot Framework and C#. I am building a chatbot using Adaptive Dialog with the Core Flight Booking Template (adaptive-dialog/03.core-bot). I want to make an API call to get the weather information. This OpenWeather API can return data in JSON, XML, or HTML format. When the response is in JSON format, it is easy to access the key-value pairs. But when the response is in XML format, everything will be converted into a string and saved as 'content' in the response, I have to convert it into either JSON or a Dictionary so that I can access the detailed information. And I need to save the API response as a property in the dialog for later reference.

我知道我们可以使用下面的代码将XML转换为JSON，但是问题是如何在自适应对话框中做到这一点.我试图将以下代码包含在HttpRequest块中，但出现错误"XmlDocument是一种类型，在给定的上下文中无效." 看来您无法添加自己的自定义代码在自适应对话框中，您只能使用模板提供的功能，但是现在HttpRequest类没有用于解析XML响应的选项.谁能给我一些指导吗?谢谢！

I know we can use the following code to convert from XML to JSON, but the question is how to do it in the adaptive dialog. I tried to include the following code in the HttpRequest block but got the error "XmlDocument is a type, which is not valid in the given context." It seems like you cannot add your own customized codes in the adaptive dialog, what you can do is only using what the template can offer, but right now the HttpRequest class does not have an option for parsing XML response. Can anyone please give me some guidance on this? Thanks!

XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);

string json = JsonConvert.SerializeXmlNode(doc);

在自适应对话框中创建HttpRequest的代码:

Codes to make the HttpRequest in the adaptive dialog:

new IfCondition()
{
    Condition = "conversation.Id != null",
    Actions = new List<Dialog>()
    {
        new HttpRequest()
        {
            Url = "http://api.openweathermap.org/data/2.5/weatherq=Detroit&mode=xml&appid=appid={your api key}",
            ResultProperty = "dialog.httpResponse",
            Method = HttpRequest.HttpMethod.GET,
            ResponseType = HttpRequest.ResponseTypes.Json
        },
        new Send Activity("${dialog.httpResponse}"),
        new Send Activity("${dialog.httpResponse.content}")
    }
}

下面显示了HttpRequest响应的样子. OpenWeather API响应(XML格式)将转换为字符串，作为内容"的值.

The following shows what the HttpRequest response looks like. The OpenWeather API response (XML format) is converted into a string as the value of 'content'.

{
    "statusCode": 200,
    "reasonPhrase": "OK",
    "headers": 
    {
        "Server": "openresty",
        "Date": "Tue, 14 Jul 2020 18:57:41 GMT",
        "Connection": "keep-alive",
        "X-Cache-Key": "/data/2.5/weather?mode=xml&q=detroit",
        "Access-Control-Allow-Origin": "*",
        "Access-Control-Allow-Credentials": "true",
        "Access-Control-Allow-Methods": "GET, POST"
    },
    "content": "<?xml version="1.0" encoding="UTF-8"?>\n
                <current>
                    <city id="4990729" name="Detroit">
                        <coord lon="-83.05" lat="42.33"></coord> 
                        <country>US</country>
                        <timezone>-14400</timezone>
                        <sun rise="2020-07-14T10:08:16" set="2020-07-15T01:07:33"></sun>
                    </city>
                    <temperature value="301.11" min="300.15" max="302.59" unit="kelvin"></temperature>
                    <feels_like value="301.1" unit="kelvin"></feels_like> 
                    <humidity value="44" unit="%"></humidity>
                    <pressure value="1019" unit="hPa"></pressure>
                    <wind>
                        <speed value="2.1" unit="m/s" name="Light breeze"></speed>
                        <gusts></gusts>
                        <direction></direction>
                    </wind>
                    <clouds value="75" name="broken clouds"></clouds>
                    <visibility value="16093"></visibility>
                    <precipitation mode="no"></precipitation>
                    <weather number="803" value="broken clouds" icon="04d"></weather>
                    <lastupdate value="2020-07-14T18:57:41"></lastupdate> 
               </current>"
}

推荐答案

您可以使用代码操作.

new IfCondition()
{
    Condition = "conversation.Id != null",
    Actions = new List<Dialog>()
    {
        new HttpRequest()
        {
            Url = "http://api.openweathermap.org/data/2.5/weatherq=Detroit&mode=xml&appid=appid={your api key}",
            ResultProperty = "dialog.httpResponse",
            Method = HttpRequest.HttpMethod.GET,
            ResponseType = HttpRequest.ResponseTypes.Json
        },
        new CodeAction(async (dc, options) =>
        {
            var xml = dc.State.GetValue("dialog.httpResponse.content", () => "<root></root>");
            var doc = new XmlDocument();

            doc.LoadXml(xml);

            var json = JsonConvert.SerializeXmlNode(doc);

            dc.State.SetValue("dialog.json", json);

            return await dc.EndDialogAsync();
        }),
        new SendActivity("${dialog.json}"),
    }
}

这篇关于如何在自适应对话框HttpRequest中从xml转换为json?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！