Pulling data from SOAP XML file not producing output from tFileInputXML to tFileOutputDelimited

Anonymous — Sat, 16 Nov 2024 03:21:50 GMT

I have a SOAP output file saved from a tSOAP in the format as below.

<?xml version="1.0" encoding="ISO-8859-15"?>
<soap:Envelope
	xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<soap:Body>
		<GetUpdatedClientsWithChangesResponse
			xmlns="http://blablah.net/client">
			<GetUpdatedClientsWithChangesResult>
				<IsSuccessful>true</IsSuccessful>
				<Messages/>
				<UpdatedClients>
					<UpdatedClient>
						<FileNumber>23899813</FileNumber>
						<Statuses>
							<ClientStatus>
								<WorkflowId>fbd</WorkflowId>
								<WorkflowName>Workflow</WorkflowName>
								<StatusId>45</StatusId>
								<Name>Client</Name>
								<UpdatedOn>2019-11-14</UpdatedOn>
								<UpdatedBy>Trick</UpdatedBy>
							</ClientStatus>
							<ClientStatus>
								<WorkflowId>af8</WorkflowId>
								<WorkflowName>Terminations</WorkflowName>
								<StatusId>58</StatusId>
								<Name>120 Days</Name>
								<UpdatedOn>2019-11-15</UpdatedOn>
								<UpdatedBy>lake</UpdatedBy>
							</ClientStatus>
							<ClientStatus>
								<WorkflowId>c791</WorkflowId>
								<WorkflowName>Accounting</WorkflowName>
								<StatusId>25</StatusId>
								<Name>Active</Name>
								<UpdatedOn>2019-11-14</UpdatedOn>
								<UpdatedBy>Trick</UpdatedBy>
							</ClientStatus>
							<ClientStatus>
								<WorkflowId>6d8</WorkflowId>
								<WorkflowName>Status</WorkflowName>
								<StatusId>26</StatusId>
								<Name>Active</Name>
								<UpdatedOn>2019-11-14</UpdatedOn>
								<UpdatedBy>Trick</UpdatedBy>
							</ClientStatus>
							<ClientStatus>
								<WorkflowId>611</WorkflowId>
								<WorkflowName>Consultant</WorkflowName>
								<StatusId>46</StatusId>
								<Name>Complete</Name>
								<UpdatedOn>2019-11-14T</UpdatedOn>
								<UpdatedBy>diaz</UpdatedBy>
							</ClientStatus>
						</Statuses>
						<Assignees/>
						<Properties>
							<ClientProperty>
								<Name>Id</Name>
								<Value>6036</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>CreatedOn</Name>
								<Value>11/14/2019</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Reason</Name>
								<Value>Program Issue</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>StatusMacro</Name>
								<Value>Active</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Balance</Name>
								<Value>$0.00</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Name</Name>
								<Value>CARDalue>
							</ClientProperty>
							<ClientProperty>
								<Name>PaymentDate</Name>
								<Value>2/1/2020</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Rep</Name>
								<Value>Lake</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Phone</Name>
								<Value>390</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Name</Name>
								<Value>Lake</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Email</Name>
								<Value>com</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>Macro</Name>
								<Value>Lake</Value>
							</ClientProperty>
							<ClientProperty>
								<Name>PhoneMacro</Name>
								<Value>390</Value>
							</ClientProperty>
						</Properties>
						<Assets>
							<Asset>
								<AssetId>a69</AssetId>
								<AssetTypeId>000</AssetTypeId>
								<Name>23899</Name>
								<Description/>
								<Type>file</Type>
								<IsDeleted>false</IsDeleted>
								<UpdatedOn>2019-11-14</UpdatedOn>
								<UpdatedBy>caw</UpdatedBy>
							</Asset>
						</Assets>
					</UpdatedClient>
				</UpdatedClients>
			</GetUpdatedClientsWithChangesResult>
		</GetUpdatedClientsWithChangesResponse>
	</soap:Body>
</soap:Envelope>

I'd created an xml metadata file with the FileNumber to be pulled (I want to pull as much as possible).
In the component view for my tFileInputXML I have the following setup, I've tried it with a Repository and Built-In schema.

There are many records in my input file but I am not getting any output from this and am not sure how to move forward.
Also is it possible to feed a tSOAP component directly into a tFileOutputDelimited?

Re: Pulling data from SOAP XML file not producing output from tFileInputXML to tFileOutputDelimited

Anonymous — Mon, 10 Feb 2020 03:45:57 GMT

Hi
tSOAP returns a string with XML format, you need to use a tExtractXMLField after tSOAP to extract data from the response, take a look at the component documentation and learn this component.

Regards
Shong

topic Pulling data from SOAP XML file not producing output from tFileInputXML to tFileOutputDelimited in Talend Studio

Pulling data from SOAP XML file not producing output from tFileInputXML to tFileOutputDelimited

Re: Pulling data from SOAP XML file not producing output from tFileInputXML to tFileOutputDelimited