Skip to main content

Hi,

 

How can I broken the attached JSON file into attributes?

 

 

Thank´s

Have a look at the JSONFlattener transformer.

That is built to take a JSON fragment and create attributes from it.


Have a look at the JSONFlattener transformer.

That is built to take a JSON fragment and create attributes from it.

@erik_jan,

you are correct, but some attributes have values between square brackets and I cannot extract them correctly.

 

Look below:

 


@erik_jan,

you are correct, but some attributes have values between square brackets and I cannot extract them correctly.

 

Look below:

 

Those will become a list, that you can pick apart using the ListExploder transformer.

Hope this helps.


Hi @mr_fme,

Thanks for visiting LiveChat yesterday. Here's the workspace template I put together and also a small tweak to the sample data you provided as I added data for "risk" & "symptoms" to show the full workflow to get all attributes returned.

JSON_From_HttpCaller_Example.fmwt


Hi @mr_fme,

Thanks for visiting LiveChat yesterday. Here's the workspace template I put together and also a small tweak to the sample data you provided as I added data for "risk" & "symptoms" to show the full workflow to get all attributes returned.

JSON_From_HttpCaller_Example.fmwt

Thank´s @steveatsafe.

 

I´m glad for your attention


Reply