Solved: Re: How to use Hmap - JSON to XML - Qlik Community

Anonymous · ‎2017-08-12

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>

Anonymous · ‎2017-08-12

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

THMAP_JSON_XML.zip

View solution in original post

Anonymous · ‎2017-08-12

Hi,

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

Eric

Anonymous · ‎2017-08-12

web service call, but why does that matter?

Anonymous · ‎2017-08-12

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

THMAP_JSON_XML.zip

Anonymous · ‎2017-08-12

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

How to use Hmap - JSON to XML

Other