Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

TOS_DI-win-x86_64_cNr8PEmfkf.png

 

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?

Labels (3)
1 Reply
Anonymous
Not applicable
Author

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