33
Views
5
Comments
[Advanced REST] How to set up ObjectPath parameter to JSON_ConvertObjectToKeyValuePairList
advanced-rest
Service icon
Forge asset by Leonardo Fernandes
Application Type
Service

The response from external API looks like:
{"data":[["2023-12-01",[[100,100,32.76099999994767,100,375.6369362411961,351.6,100]]],["2023-12-02",[[100,100,195.20600000004924,100,2105.0454713950326,1234.15,100]]],["2023-12-03",[[100,100,75.41299999997136,100,590.1423730384283,526.1750000000001,100]]]],"AttributeA":["A1234"],"AtributeB":["A","B","C","D","E","F","G"]} 

or formatted by notepad:

{

    "data": [

        [

            "2023-12-01",

            [

                [

                    100,

                    100,

                    32.76099999994767,

                    100,

                    375.6369362411961,

                    351.6,

                    100

                ]

            ]

        ],

        [

            "2023-12-02",

            [

                [

                    100,

                    100,

                    195.20600000004925,

                    100,

                    2105.0454713950327,

                    1234.15,

                    100

                ]

            ]

        ],

        [

            "2023-12-03",

            [

                [

                    100,

                    100,

                    75.41299999997136,

                    100,

                    590.1423730384283,

                    526.1750000000001,

                    100

                ]

            ]

        ]

    ],

    "AttributeA": [

        "A1234"

    ],

    "AtributeB": [

        "A",

        "B",

        "C",

        "D",

        "E",

        "F",

        "G"

    ]

}


How do I define the  ObjectPath parameter  for the above data/structure?


2023-12-16 19-57-03
Sanjay Kushwah

Hi @Mark Wieffer,

If you want to convert from Entity to Object then You can use toObject() function in Outsystems, but vice versa is not possible.

Please look into this POST.

Using toObject to convert entity to object and vice versa | OutSystems

If your JSON is string-JSON then you can deserialize your JSON using JSON deserialize action in outsystems and you can add a structure by this JSON.

Kind regards,

Sanjay Kushwah

UserImage.jpg
Mark Wieffer

Hi Sanjay, thanks for your reply!
I'm specifically looking for assistance on the aforementioned extension. Did you perhaps have any experiences using this?

Kr,

Mark

2023-12-16 19-57-03
Sanjay Kushwah

hi @Mark Wieffer,

surely i can help you with this extension but I I didn't understand what exact issue you are facing by your statement "How do I define the  ObjectPath parameter for the above data/structure?"

Can you elaborate more?

UserImage.jpg
Mark Wieffer

Hi Sanjay, apologies for my very late reply!

Im using the Advanced REST extension, And that extension uses the ObjectPathParameter: 

The ObjectPath Parameter description is as follows

"The path to the object that should be converted into a key/value pair.

This should be a dot-separated string of the property names that should be navigated, from the root until reaching the dynamic object. The special character "*" matches any property name." 
-----------------------------------------------------------------------------------------
My Question is  : 
How do I set the ObjectPath Parameter, based on the above output ?

Thanks for your support! 


 

UserImage.jpg
Mark Wieffer

Anyone that can help on this ?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.