topic Re: How to use Hmap - JSON to XML in Talend Studio

How to use Hmap - JSON to XML

Anonymous — Sat, 16 Nov 2024 09:25:02 GMT

How to setup HMap to be able to create the XML from the following JSON?

Input JSON

{
	"documentSection":{
		"documentStatus": 1,
		"documentNumber": "9300806055"
	},
	"partnerSection": {
		"partner_role_ag": {
			"partnerRole": "AG",
			"contactFirstName": "Mario"
		},
		"partner_role_lf": {
			"partnerRole": "LF",
			"contactFirstName": "Anna"
		},
		"partner_role_we": {
			"partnerRole": "WE",
			"contactFirstName": "Mia"
		}
	}
}

Output XML:

<ORDER>
	<HEAD>
		<DOC_STATUS>1</DOC_STATUS>
		<DOC_NO>9300806055</DOC_NO>
		<PARTY>
			<PARTNER_ROLE>AG</PARTNER_ROLE>
			<NAME1>Mario</NAME1>
		</PARTY>
		<PARTY>
			<PARTNER_ROLE>LF</PARTNER_ROLE>
			<NAME1>Anna</NAME1>
		</PARTY>
		<PARTY>
			<PARTNER_ROLE>WE</PARTNER_ROLE>
			<NAME1>Mia</NAME1>
		</PARTY>
	</HEAD>
</ORDER>

Re: How to use Hmap - JSON to XML

Anonymous — Sat, 12 Aug 2017 13:19:04 GMT

Hi,

How do you get this JSON input ? Do you read it on a file system ? Does it come from a webservice call ? ...

Eric

Re: How to use Hmap - JSON to XML

Anonymous — Sat, 12 Aug 2017 14:23:32 GMT

web service call, but why does that matter?

Re: How to use Hmap - JSON to XML

Anonymous — Sat, 12 Aug 2017 14:36:47 GMT

I enclosed a map and a job to do this transform.

THMAP_JSON_XML.zip

Re: How to use Hmap - JSON to XML

Anonymous — Sat, 12 Aug 2017 16:33:07 GMT

Are there any good example & documentation on how to use tHMap? I remember that 6 months ago there were almost no examples.