Hi All,
I’m new to UIPath and have been self-learning. One of my tasks was to call an API, which provides the following order data. It has nested elements as: Orders → OrderDetails → URLs. I would like to “filter out” Orders, where the “URLs” value contains “bestbuy”. I would then loop thru this “updated” JsonArray to place an order.
I’ve tried to determine if LINQ can be used, but I’m not familiar enough with that to get that done. Is there a good solution to this?
Original JsonArray
[
{
“RequestNo”: “100”,
“Name”: “John Smith”,
“OrderDetails”: [
{
“OrderDetailId”: 1,
“ItemCode”: “A1”,
“Qty”: 1,
“URLs”: [
“test.url/A1-Product”
]
}
]
},
{
“RequestNo”: “101”,
“Name”: “Mary Smith”,
“OrderDetails”: [
{
“OrderDetailId”: 2,
“ItemCode”: “B1”,
“Qty”: 1,
“URLs”: [
“bestbuy.url/B2-Product”
]
}
]
}
]
After filtering, the desired json output below excludes RequestNo “101” because the URLs contained “bestbuy”
[
{
“RequestNo”: “100”,
“Name”: “John Smith”,
“OrderDetails”: [
{
“OrderDetailId”: 1,
“ItemCode”: “A1”,
“Qty”: 1,
“URLs”: [
“test.url/A1-Product”
]
}
]
}
]