JsonExtract could not read second record of root array

madan_clover3

• January 31, 2019 00:00

• Answered

Follow

Hi,

JsonExtract is not able to read second record of root array element. Below is data and extraction mapping,

Data :

[{
  "id": "1",
  "name": "emp1"
},{
  "id": "2",
  "name": "emp2"
}]

Extraction Mapping :

<Mappings>
  <Mapping element="json_array" outPort="0" xmlFields="{}id;{}name" cloverFields="id;name"/>
</Mappings>

JsonExtract is producing only first record, second one is missing. Please suggest if I am missing any configuration. It its a bug any work around ?

• 

  Vladimir Barton

  • February 08, 2019 14:42

  0

  Comment actions Permalink

  Hello,
  in order to extract both fields from the array, try using this mapping:
  

  
  <Mappings>
  	<Mapping element="json_array">
  		<Mapping element="json_array" outPort="0"
  				xmlFields="{}id;{}name"
  				cloverFields="id;name">
  		</Mapping>
  	</Mapping>
  </Mappings>
  

  
  Attached is a graph where this is demonstrated.
  Best,

  • JSONExtract.grf
• 

  madan_clover3

  • February 13, 2019 07:13

  0

  Comment actions Permalink

  Thank you. With the above changes working as expected.

Please sign in to leave a comment.