tExtractXMLField is not returning anything.

One Star

tExtractXMLField is not returning anything.

Hi Team,
I have a requirement where i have to export the data present in sharepoint to a excel sheet.
I am using tsoap->main->textractxmlfield->main->tfileoutputdelimited for this.
When i am running my job, I could see that tsoap is sending response to textractxmlfield.But , textractxmlfield is not returning anything.
I would like to know if i have configured anything incorrectly in textractxmlfield.Please check and respond.
I am attaching the job screeenshot,textractxmlfield screenshot and first and last 5 lines of my tsoap response.

 


-----------------------------------------------------------
First 5 lines of my response 

<GetListItemsResponse xmlns="">
<GetListItemsResult>
<listitems xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:z="#RowsetSchema">
<rs:data ItemCount="122">
   <z:row ows_Aligned_x0020_to_x0020_2015_x002="No" ows_Attachments="0" ows_Can_x0020_prior_x0020_PoC_x0020_="Yes" ows_Completion_x0020_Ease="float;#25.0000000000000" ows_Completion_x0020_Ease_x0020_Modi="0" ows_Created="2014-05-16 15:52:29" ows_Created_x0020_Date="1;#2014-05-16 15:52:29" ows_DPO_x0020_approval_x0020_obtaine="No" ows_Data_x0020_Available_x0020_in_x00="Partial" ows_Date_x0020_Submitted="2014-02-21 00:00:00" ows_Description="&lt;div class=&quot;ExternalClass153B0EEA89A94A6EA0F9C23B6D2628DE&quot;&gt;&lt;table width=&quot;373&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; style=&quot;width:280pt;border-collapse:collapse&quot;&gt;&lt;colgroup&gt;&lt;col width=&quot;373&quot; style=&quot;width:280pt&quot; /&gt;&lt;/colgroup&gt;&lt;tbody style=&quot;background-color:#ffffff&quot;&gt;&lt;tr height=&quot;135&quot; style=&quot;height:101.25pt&quot;&gt;&lt;td width=&quot;373&quot; height=&quot;135&quot; class=&quot;xl63&quot; style=&quot;border-bottom:white 0.5pt solid;border-left:white 0.5pt solid;width:280pt;font-family:calibri;background:#ffffff;height:101.25pt;color:black;font-size:10pt;border-top:white 0.5pt solid;font-weight:400;border-right:white 0.5pt solid;text-decoration:none;text-underline-style:none;text-line-through:none&quot;&gt;&lt;p&gt;The question that came to mind was what impact current processing trends have on the actual processing of payments.&lt;br /&gt;For example, if there is a large volume of payments requiring repair 1st thing in the morning, does this lead the processors into a &amp;quot;let's get through it attitude&amp;quot;.&lt;br /&gt;Does this then lead to an increased number of re-repairs?&lt;br /&gt;Does this then lead to an increased number of errors?&lt;br /&gt;If so would introducing a more evenly balanced distribution of repairs lead to a decrease in the error rate?&lt;br /&gt;&lt;span&gt; &lt;/span&gt;&lt;br /&gt;Alternatively. If the users have the capacity to clear a high volume of payments in the morning, is there an opportunity to reduce the number of users in the queue during the middle of the day?&lt;br /&gt;Could the individuals who aren't utilised in this capacity then be uitilised elsewhere to improve processing or increase training?&lt;/p&gt;&#xD;&#xA;&lt;p&gt;Potential Source Systems: CitiFT, Flexcube&lt;/p&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&#xD;&#xA;&lt;p&gt;&lt;/p&gt;&lt;/div&gt;" ows_Editor="35;#Ross, Rebecca A [ICG-OPS]" ows_Exclude_x0020_from_x0020_Flock_x="Yes" ows_Existing_x0020_dashboard_x0020_m="No" ows_FSObjType="1;#0" ows_FileLeafRef="1;#1_.000" ows_FileRef="1;#sites/ttscntrl/OTControlBigDataLab/Lists/Idea Repository/1_.000" ows_Funding_x0020_in_x0020_place_x00="No" ows_Historical_x0020_data_x0020_coll="Yes" ows_ID="1" ows_Idea_x0020_Owner="45;#Kiernan, Niall [ICG-OT_CAO]" ows_LinkTitle="Payment Processing Trends" ows_Modified="2014-12-16 12:15:18" ows_New_x0020_security_x0020_zone_x0="Yes" ows_PermMask="0xb008431061" ows_Primary_x0020_Improvement_x0020_="New Risk &amp; Controls Insights" ows_Primary_x0020_Objective_x0020_Mo="0" ows_Priority_x0020_Rating_x0020__x00="3 (Six Month to Complete)" ows_Region=";#NAM;#LATAM;#APAC;#EMEA;#" ows_Sponsors_x0020_defined_x003f_="No" ows_Status="1 - Reviewed and Archived" ows_Title="Payment Processing Trends" ows_UniqueId="1;#{6072D438-AC12-4A21-8003-91FE583EFEE3}" ows__Level="1" ows__ModerationStatus="0" ows_owshiddenversion="6" />



-------------------------------------------------------------------

Last 5 lines of my response.


<z:row ows_Aligned_x0020_to_x0020_2015_x002="Yes" ows_Attachments="0" ows_Can_x0020_prior_x0020_PoC_x0020_="No" ows_Completion_x0020_Ease="float;#30.0000000000000" ows_Completion_x0020_Ease_x0020_Modi="0" ows_Created="2015-02-12 11:45:49" ows_Created_x0020_Date="123;#2015-02-12 11:45:49" ows_DPO_x0020_approval_x0020_obtaine="No" ows_Data_x0020_Available_x0020_in_x00="No" ows_Date_x0020_Started="2015-02-05 00:00:00" ows_Date_x0020_Submitted="2015-02-12 00:00:00" ows_Description="&lt;div class=&quot;ExternalClassD12F5E34A4804C309DAF3C780D84A808&quot;&gt;&lt;div style=&quot;margin:0in 0in 0pt&quot;&gt;&lt;span lang=&quot;EN-GB&quot; style=&quot;color:#000000;font-size:10pt&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt;&lt;span style=&quot;color:#000000;font-size:10pt&quot;&gt;Creation of risk dashboards based on manually produced risk/losses data in Bahrain. Those dashboards will be used by Bahrain senior management on day-to-day decision making. &lt;/span&gt;&lt;/font&gt;&lt;/span&gt;&lt;span lang=&quot;EN-GB&quot; style=&quot;color:#000000;font-size:10pt&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt;&lt;span style=&quot;color:#000000;font-size:10pt&quot;&gt;Through the use of Manually created data provide visualizations and formulate the value add of Analytics. Industrialization can be performed for all MENA but to be decided at later stage.&lt;/span&gt;&lt;/font&gt;&lt;/span&gt; &lt;div style=&quot;margin:0in 0in 0pt&quot;&gt;&lt;span lang=&quot;EN-GB&quot; style=&quot;color:#1f497d&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt; &lt;/font&gt;&lt;/span&gt;&lt;/div&gt;&lt;/div&gt;&#xD;&#xA;&lt;p&gt;&lt;/p&gt;&lt;/div&gt;" ows_Digital_x0020_Controls_x0020_Tea="1;#Oksel, Erkin [ICG-OPS]" ows_Editor="35;#Ross, Rebecca A [ICG-OPS]" ows_Exclude_x0020_from_x0020_Flock_x="No" ows_Existing_x0020_dashboard_x0020_m="No" ows_FSObjType="123;#0" ows_FileLeafRef="123;#123_.000" ows_FileRef="123;#sites/ttscntrl/OTControlBigDataLab/Lists/Idea Repository/123_.000" ows_Funding_x0020_in_x0020_place_x00="No" ows_Historical_x0020_data_x0020_coll="No" ows_ID="123" ows_Idea_x0020_Owner="13;#Horn, Jonathan [ICG-OPS]" ows_LinkTitle="Bahrain Loss Visualization " ows_Modified="2015-02-12 11:46:40" ows_New_x0020_security_x0020_zone_x0="No" ows_Partners=";#ICG Operations and IT Controls;#" ows_PermMask="0xb008431061" ows_Primary_x0020_Improvement_x0020_="New Risk &amp; Controls Insights" ows_Primary_x0020_Objective_x0020_Mo="0" ows_Priority_x0020_Rating_x0020__x00="3 (Six Month to Complete)" ows_Program="TBD" ows_Region=";#EMEA;#" ows_Sponsors_x0020_defined_x003f_="Yes" ows_Status="2 - Under Evaluation" ows_Title="Bahrain Loss Visualization " ows_UniqueId="123;#{4ADE0D0F-4695-41F0-94F3-BEA618BC6CB2}" ows__Level="1" ows__ModerationStatus="0" ows_owshiddenversion="2" />
   <z:row ows_Aligned_x0020_to_x0020_2015_x002="Yes" ows_Attachments="0" ows_Can_x0020_prior_x0020_PoC_x0020_="No" ows_Completion_x0020_Ease="float;#30.0000000000000" ows_Completion_x0020_Ease_x0020_Modi="0" ows_Created="2015-02-12 11:53:11" ows_Created_x0020_Date="124;#2015-02-12 11:53:11" ows_DPO_x0020_approval_x0020_obtaine="No" ows_Data_x0020_Available_x0020_in_x00="No" ows_Date_x0020_Started="2015-02-05 00:00:00" ows_Date_x0020_Submitted="2015-02-12 00:00:00" ows_Description="&lt;div class=&quot;ExternalClass80F98CD8C8C84C4CA2F9B7764FBC20FE&quot;&gt;&lt;div style=&quot;margin:0in 0in 0pt;color:#000000;font-size:10pt&quot;&gt;&lt;span lang=&quot;EN-GB&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt;&lt;span style=&quot;color:#000000;font-size:10pt&quot;&gt;Creation of operational risk/efficiency and work load dashboards for Market Operations.  &lt;/span&gt;&lt;/font&gt;&lt;/span&gt;&lt;span lang=&quot;EN-GB&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt;&lt;span style=&quot;color:#000000&quot;&gt;Through the use of existing system extracts provide dashboards for Ops management for their daily routine. &lt;/span&gt;&lt;/font&gt;&lt;/span&gt;&lt;/div&gt;&#xD;&#xA;&lt;div style=&quot;margin:0in 0in 0pt;color:#000000;font-size:10pt&quot;&gt;&lt;span lang=&quot;EN-GB&quot;&gt;&lt;font face=&quot;Calibri&quot;&gt;&lt;span style=&quot;color:#000000;font-size:10pt&quot;&gt; &lt;/span&gt;&lt;span style=&quot;color:#000000;font-size:10pt&quot;&gt;&lt;/span&gt;&lt;/font&gt;&lt;/span&gt;&lt;/div&gt;&#xD;&#xA;&lt;p&gt;&lt;/p&gt;&lt;/div&gt;" ows_Digital_x0020_Controls_x0020_Tea="1;#Oksel, Erkin [ICG-OPS]" ows_Editor="35;#Ross, Rebecca A [ICG-OPS]" ows_Exclude_x0020_from_x0020_Flock_x="No" ows_Existing_x0020_dashboard_x0020_m="No" ows_FSObjType="124;#0" ows_FileLeafRef="124;#124_.000" ows_FileRef="124;#sites/ttscntrl/OTControlBigDataLab/Lists/Idea Repository/124_.000" ows_Funding_x0020_in_x0020_place_x00="No" ows_Historical_x0020_data_x0020_coll="No" ows_ID="124" ows_Idea_x0020_Owner="13;#Horn, Jonathan [ICG-OPS]" ows_LinkTitle="Market Operations Risk Dashboard" ows_Modified="2015-02-12 11:53:11" ows_New_x0020_security_x0020_zone_x0="No" ows_Partners=";#ICG Operations and IT Controls;#" ows_PermMask="0xb008431061" ows_Primary_x0020_Improvement_x0020_="New Risk &amp; Controls Insights" ows_Primary_x0020_Objective_x0020_Mo="0" ows_Priority_x0020_Rating_x0020__x00="3 (Six Month to Complete)" ows_Program="Other" ows_Region=";#EMEA;#" ows_Sponsors_x0020_defined_x003f_="Yes" ows_Status="2 - Under Evaluation" ows_Title="Market Operations Risk Dashboard" ows_UniqueId="124;#{7C106053-DECC-4C72-9DC6-69BAABFE3A70}" ows__Level="1" ows__ModerationStatus="0" ows_owshiddenversion="1" />
   <z:row ows_Aligned_x0020_to_x0020_2015_x002="Yes" ows_Attachments="0" ows_Can_x0020_prior_x0020_PoC_x0020_="Yes" ows_Completion_x0020_Ease="float;#45.0000000000000" ows_Completion_x0020_Ease_x0020_Modi="0" ows_Created="2015-03-12 16:02:10" ows_Created_x0020_Date="125;#2015-03-12 16:02:10" ows_DPO_x0020_approval_x0020_obtaine="No" ows_Data_x0020_Available_x0020_in_x00="No" ows_Date_x0020_Submitted="2015-01-02 00:00:00" ows_Description="&lt;div class=&quot;ExternalClass1C052CC2BF744FBA8A5CB245B398CFAC&quot;&gt;&lt;p&gt;Assessment of Germany data 2012-2014 &lt;/p&gt;&#xD;&#xA;&lt;p&gt;Expansion to other countries&lt;/p&gt;&lt;/div&gt;" ows_Digital_x0020_Controls_x0020_Tea="51;#Gillett, Thomas George [ICG-OPS]" ows_Editor="35;#Ross, Rebecca A [ICG-OPS]" ows_Exclude_x0020_from_x0020_Flock_x="No" ows_Existing_x0020_dashboard_x0020_m="No" ows_FSObjType="125;#0" ows_FileLeafRef="125;#125_.000" ows_FileRef="125;#sites/ttscntrl/OTControlBigDataLab/Lists/Idea Repository/125_.000" ows_Funding_x0020_in_x0020_place_x00="No" ows_Historical_x0020_data_x0020_coll="No" ows_ID="125" ows_Idea_x0020_Owner="51;#Gillett, Thomas George [ICG-OPS]" ows_LinkTitle="Tax Reconciliation Expansion" ows_Modified="2015-03-12 16:02:10" ows_New_x0020_security_x0020_zone_x0="No" ows_Partners=";#ICG Operations and IT Controls;#" ows_PermMask="0xb008431061" ows_Primary_x0020_Improvement_x0020_="New Risk &amp; Controls Insights" ows_Primary_x0020_Objective_x0020_Mo="0" ows_Priority_x0020_Rating_x0020__x00="1 (One Month to Complete)" ows_Program="TBD" ows_Region=";#NAM;#" ows_Sponsors_x0020_defined_x003f_="Yes" ows_Status="3 - In scope" ows_Title="Tax Reconciliation Expansion" ows_UniqueId="125;#{2BD56877-8F91-497D-935C-8A3D7387C0FC}" ows__Level="1" ows__ModerationStatus="0" ows_owshiddenversion="1" />
</rs:data>
</listitems></GetListItemsResult></GetListItemsResponse>

One Star

Re: tExtractXMLField is not returning anything.

details.zip_20150726-1620.zip
One Star

Re: tExtractXMLField is not returning anything.

Attaching
  
One Star

Re: tExtractXMLField is not returning anything.

Attaching tExtractXMLField

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now