tExtractXMLFields extracting paths correctly

Cherichoc- — Fri, 15 Nov 2024 23:05:49 GMT

I am trying to extract data from an API that setup like the below pic. I am only trying to extract the logs data. How would I go about Mapping on tExtractJsonFields. I keep getting Trying to output non-whitespace characters outside main element tree (in prolog or epilog) error

<?xml version="1.0" encoding="UTF-8"?>

<root><status>success</status>

<data>

<name>Atlas</name>

<type>assessment</type>

<app><ID>pioneer</ID>

</app>

</story>

</status>

</logs>

<logs><firstname>Peter</firstname>

</status>

</logs></data><hash>1fda</hash><response_time>0.22277402877807617</response_time></root>

Re: tExtractXMLFields extracting paths correctly

Cherichoc- — Wed, 23 Mar 2022 15:31:44 GMT

To access logs directly, I used

"//logs" or "/root/logs

To access complete, I used

"./status/complete"

I also had to select Body instead of string under textractXMLfield xmlfield

topic tExtractXMLFields extracting paths correctly in Talend Studio

tExtractXMLFields extracting paths correctly

Re: tExtractXMLFields extracting paths correctly