JsonExtract could not read second record of root array

CloverDX Platform
1

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 ?

2

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,

3

Thank you. With the above changes working as expected.