Generate a pattern to fetch values from JSON

Help Studio
, ,
1

Hello Experts,

I need to fetch values from JSON .Can anyone please suggest a pattern how can I fetch values…
The output has to be from catch :

10% discount with Coupon on Outlet Sneakers
Coupon valid and Bindings Outlet_sneakers Count >= 1
setDiscountPerItemV2
Outlet_sneakers
10% off per item
([Item.Quantity] * [Item.Price]) * 10%

below is the Input:

                                  "id": "b7a309df-3de0-4175-ae28-10d23fcb4540",
                "title": "10% discount with Coupon on Outlet Sneakers",
                "condition": [
                    "and",
                    [
                        "couponValid"
                    ],
                    [
                        "catch",
                        false,
                        [
                            ">=",
                            [
                                ".",
                                "Bindings",
                                "Outlet_sneakers",
                                "Count"
                            ],
                            1
                        ]
                    ]
                ],
                "effects": [
                    [
                        "catch",
                        [
                            "noop"
                        ],
                        [
                            "setDiscountPerItemV2",
                            [
                                "concat",
                                "10% off per item"
                            ],
                            [
                                "*",
                                [
                                    "*",
                                    [
                                        ".",
                                        "Item",
                                        "Quantity"
                                    ],
                                    [
                                        ".",
2

The selectToken / SelectTokens method using JSONPath could be a good starting point

JSONPath:
https://goessner.net/articles/JsonPath/

3

can u please assist in generating for my json query

4

we will just wait till you have done with the requirement descriptions
Just share the JSON as Textfile with us

Once you have done we will check for the next steps

5

you shared a JSON snippet, so we were forced

  • to fix the JSON
  • assume that shown part is surrounded with other parts

So we used SelectToken/s within a relative form

General Preperations
grafik

Some patterns from the retrieval
grafik
grafik
grafik

For effects:
grafik

So we just applied the path/structures and retrieve the values

6

Thank you so much but can you please share the xaml of this?

7

prototyping was done within the debugging panel - immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

So there is no XAML present

But you can port it from prototype to your modeling when using an Assign Activity

myValueVar = myJObject("…