Eclipse Community Forums: Eclipse Process Manager (Stardust) » JSON string to structured data type conversion.

Home » Archived » Eclipse Process Manager (Stardust) » JSON string to structured data type conversion.(JSON string to structured data type conversion.)

JSON string to structured data type conversion. [message #1708981]

Wed, 23 September 2015 02:38

Eclipse User

HI,

I am looking for an example source or help to convert JSON string to structured data type.

I am using IPP browser modeller and making a call to web service which returns me a JSON string

e.g.
[{"Id":5,"Name":"abc","eMail":"abcd@abc.com","isActive":1},
{"Id":6,"Name":"def","eMail":"pqr@abc.com","isActive":1}]

And I want to convert it into structured data type named

Student - which having all four fields.
Id, Name, eMail, isActive.

Which application type will help to covert the JSON string to Structure data. Or any example source or any pointer.

Thanks in advance.

Re: JSON string to structured data type conversion. [message #1709110 is a reply to message #1708981]

Thu, 24 September 2015 03:06

Eclipse User

Hi,

Do you see this defined SDT changing (business object), or will remain the same? If static there could be a straight forward conversion to SDT, or else if the JSON/format is changing it could be you will have to use the Script invocation app and write a custom script.

Re: JSON string to structured data type conversion. [message #1709127 is a reply to message #1709110]

Thu, 24 September 2015 05:43

Eclipse User

Hi,

Attached is the testModel which converts the JSONdata to SDT.

The model takes the input as a PrimitiveData(String) as follows:
{"Students":[{"Id":5,"Name":"abc","eMail":"abcd@abc.com","isActive":1},
{"Id":6,"Name":"def","eMail":"pqr@abc.com","isActive":1}]}

which Stores the result in the SDT Data "Students". Model uses GenericCamel Application for the Conversion.

Hope this helps!!

-Cheers
Ashish