从 FTP 服务器位置，我的逻辑应用程序正在获取可以容器的 zip 文件夹包含“N”号。示例结构的 xml 文件
我可以通过将 xml 文件解析为 JSON 来读取 for-each 循环中的内容
3. 现在，我希望我的逻辑应用程序将 JSON 中的多个 xml 文件合并到单个 xml 文件中
请建议我如何实现上述第 3 点。 我有集成帐户来存储映射文件。
输入文件 1：-
<?xml version="1.0"?>
<orderQuote>
<order_id>AZS000001</order_id>
<user_request>
<app_user>
<username>varunxxxxxxxxxxxx</username>
<user_first_name>Varun</user_first_name>
<user_last_name>Thakur</user_last_name>
<user_email>[email protected] /cdn-cgi/l/email-protection</user_email>
</app_user>
</user_request>
<quote_id>345678</quote_id>
<rate_id>ABC001</rate_id>
<contract_id>SR_ABC_XYZ</contract_id>
<amendment_id>2019062401</amendment_id>
<price> 10</price>
<rate_effective_date>01-Jul-2019</rate_effective_date>
<rate_expiration_date>30-Sep-2019</rate_expiration_date>
<origin_trade></origin_trade>
<destination_trade></destination_trade>
<origin_city>Haiphong</origin_city>
<origin_country>VIETNAM</origin_country>
<destination_city>Atlanta</destination_city>
<destination_country>USA</destination_country>
<ordermentType>XYZ</ordermentType>
<ordermentSize>XYZ</ordermentSize>
<ordermentSizeType>DC</ordermentSizeType>
<currency>USD</currency>
<order_dt>17-Sep-2019</order_dt>
<customer>CompanyName RM Team</customer>
<quote_creation_dt>17-Sep-2019</quote_creation_dt>
</orderQuote>
输入文件 2：-
<?xml version="1.0"?>
<orderQuote>
<order_id>AZS000001</order_id>
<user_request>
<app_user>
<username>varunxxxxxxxxxxxx</username>
<user_first_name>Varun</user_first_name>
<user_last_name>Thakur</user_last_name>
<user_email>[email protected] /cdn-cgi/l/email-protection</user_email>
</app_user>
</user_request>
<quote_id>8975545</quote_id>
<rate_id>ABC002</rate_id>
<contract_id>SR_A83Z</contract_id>
<amendment_id>20134362401</amendment_id>
<price>60</price>
<rate_effective_date>01-JAJ-2019</rate_effective_date>
<rate_expiration_date>30-DEC-2019</rate_expiration_date>
<origin_trade></origin_trade>
<destination_trade></destination_trade>
<origin_city>Haiphong</origin_city>
<origin_country>VIETNAM</origin_country>
<destination_city>Atlanta</destination_city>
<destination_country>USA</destination_country>
<ordermentType>XYZ</ordermentType>
<ordermentSize>XYZ</ordermentSize>
<ordermentSizeType>DC</ordermentSizeType>
<currency>USD</currency>
<order_dt>17-Sep-2019</order_dt>
<customer>CompanyName RM Team</customer>
<quote_creation_dt>17-Sep-2019</quote_creation_dt>
</orderQuote>
预期输出文件
<?xml version="1.0"?>
<orderQuote>
<order_id>AZS000001</order_id>
<user_request>
<app_user>
<username>varunxxxxxxxxxxxx</username>
<user_first_name>Varun</user_first_name>
<user_last_name>Thakur</user_last_name>
<user_email>[email protected] /cdn-cgi/l/email-protection</user_email>
</app_user>
</user_request>
<quotationCollection>
<quotation>
<quote_id>8975545</quote_id>
<rate_id>ABC002</rate_id>
<contract_id>SR_A83Z</contract_id>
<amendment_id>20134362401</amendment_id>
<price>60</price>
<rate_effective_date>01-JAJ-2019</rate_effective_date>
<rate_expiration_date>30-DEC-2019</rate_expiration_date>
<origin_trade></origin_trade>
<destination_trade></destination_trade>
<origin_city>Haiphong</origin_city>
<origin_country>VIETNAM</origin_country>
<destination_city>Atlanta</destination_city>
<destination_country>USA</destination_country>
<ordermentType>XYZ</ordermentType>
<ordermentSize>XYZ</ordermentSize>
<ordermentSizeType>DC</ordermentSizeType>
<currency>USD</currency>
<order_dt>17-Sep-2019</order_dt>
<customer>CompanyName RM Team</customer>
<quote_creation_dt>17-Sep-2019</quote_creation_dt>
</quotation>
<quotation>
<quote_id>345678</quote_id>
<rate_id>ABC001</rate_id>
<contract_id>SR_ABC_XYZ</contract_id>
<amendment_id>2019062401</amendment_id>
<price> 10</price>
<rate_effective_date>01-Jul-2019</rate_effective_date>
<rate_expiration_date>30-Sep-2019</rate_expiration_date>
<origin_trade></origin_trade>
<destination_trade></destination_trade>
<origin_city>Haiphong</origin_city>
<origin_country>VIETNAM</origin_country>
<destination_city>Atlanta</destination_city>
<destination_country>USA</destination_country>
<ordermentType>XYZ</ordermentType>
<ordermentSize>XYZ</ordermentSize>
<ordermentSizeType>DC</ordermentSizeType>
<currency>USD</currency>
<order_dt>17-Sep-2019</order_dt>
<customer>CompanyName RM Team</customer>
<quote_creation_dt>17-Sep-2019</quote_creation_dt>
</quotation>
</quotationCollection>
</orderQuote>
由于您想要合并多个 xml(json) 文件的部分内容，并且您的示例很复杂，所以我简化了它们。
您的要求相当于合并xml文件
<orderQuote>
<order_id>AZS000001</order_id>
<quote_id>345678</quote_id>
<rate_id>ABC001</rate_id>
</orderQuote>
and
<orderQuote>
<order_id>AZS000001</order_id>
<quote_id>8975545</quote_id>
<rate_id>ABC002</rate_id>
</orderQuote>
to
<orderQuote>
<order_id>AZS000001</order_id>
<quotationCollection>
<quotation>
<quote_id>8975545</quote_id>
<rate_id>ABC002</rate_id>
</quotation>
<quotation>
<quote_id>345678</quote_id>
<rate_id>ABC001</rate_id>
</quotation>
</quotationCollection>
</orderQuote>
For this requirement, I initialize four variables at first(the variable "isFirstTime" is used to judge if it is the first loop in for each).
Then I connect to ftp and parse the xml file get from ftp to json format.
Next, I set the variable value with "order_id"(in this step, you may need to set some other variables such as "username", "user_first_name".....)
Next step, I create a "if" condition to do different work.
At bottom of the "For each" loop, we need to set the variable "isFirstTime" to false.
After complete the "For each" loop, we have last two steps.
The expression of "fx concat(...)" is
concat(concat(concat(concat('{"orderQuote":{"order_id":"', variables('order_id')), '","quotationCollection":['), variables('jsonstring')), ']}}')
之后我们就可以得到json格式的结果文件。
{
"orderQuote": {
"order_id": "AZS000001",
"quotationCollection": [
{
"quotation": {
"quote_id": "345678",
"rate_id": "ABC001"
}
},
{
"quotation": {
"quote_id": "8975545",
"rate_id": "ABC002"
}
}
]
}
}
By the way, we'd better to do some settings before we use "For each" loop, click the "…" icon beside the "For each" action --> click "Settings" and then enable "Concurrency Control" and change the "Degree of Parallelism" to 1.
