Hi,
JsonExtract is not able to read second record of root array element. Below is data and extraction mapping,
Data :
Extraction Mapping :
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 ?
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 ?
-
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, -
Thank you. With the above changes working as expected.
Please sign in to leave a comment.
Comments 2