Sathish Ramanujam
Rank: #1353
18Views
3Comments
JSON Deserialization
Question

HI OutSystems Team ,

                    Let me know how to DE serialize  the following JSON String . Am not able to DE serialize the JSON String .

"[{""WoEntry"":4190,""WoNum"":4593,""U_DocDate"":""16-09-2020"",""U_ItemCode"":""RSS-PL-25ARUL-W"",""U_ItemName"":""ModelNo:RE-25ARConven 4 Zone Agent Release FACP White with 2 Release Module-UL Listed"",""WOQty"":25.000000}]"



Regards,

Sathish

0
0
on 2020-10-13
Copy link to comment
João Marques
Rank: #67

Hi Sathish,


First, you need to create a structure that can take this structure (be careful to remove the "" by "):


When you do that you will end up with the structure that matches the JSON:



And now you just drag the JSON Deserialize action with the DataType of the structure you created (in my case MyStructure).



Hope it helps.


Cheers,

João

0
0
on 2020-10-13
Copy link to comment

Thanks for your reply Mr.Marques , actually i already created this process . But my issue was due to JSON String getting from JSON as follows :


[{""WoEntry"":4190,

""WoNum"":4593,

""U_DocDate"":"16-09-2020",

""U_ItemCode"":"RSS-PL-25ARUL-W",

""U_ItemName"":"ModelNo:RE-25ARConven 4 Zone Agent Release FACP White with 2 Release Module-UL Listed",""WOQty"":25.000000}]



not able to Convert as follows :


[{"WoEntry":"4190",

"WoNum":"4593",

"U_DocDate":"16-09-2020",

"U_ItemCode":"RSS-PL-25ARUL-W",

"U_ItemName":"ModelNo:RE-25ARConven 4 Zone Agent Release FACP White with 2 Release Module-UL Listed",

"WOQty":"25.000000"}]


Regards,

R.Sathish Ramanujam


João Marques wrote:

Hi Sathish,


First, you need to create a structure that can take this structure (be careful to remove the "" by "):


When you do that you will end up with the structure that matches the JSON:



And now you just drag the JSON Deserialize action with the DataType of the structure you created (in my case MyStructure).



Hope it helps.


Cheers,

João

 

 

0
0
on 2020-10-13
Copy link to comment
João Marques
Rank: #67

Hi Sathish,


So then your problem is the double-quote "" ?

In that case, you can use the action Regex_Replace from Text extension to "clean" your input text.


Like this, to replace the "" by ".

And then you use the output of the Replace as an input to the JSON Deserealize action.


Hope it helps.


Cheers,

João

0
0
on 2020-10-13
Copy link to comment