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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
DBLONDEL1643728674
Contributor III
Contributor III

tSoap + tXMLmap

Bonjour,

I am doing maintenance in a job but something is no longer working.

I have a tSoap getting a XML output structure. This XML structure is key value based so the XML structure has not been define in input.

Let me show you a exemple of the XML :

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

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body>

<GetOccurrencesResponse xmlns="http://www.ApiProvider.com/ApiProviderWebServices/v1.2/">

<GetOccurrencesResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">

<Occurrence>

<DataFields>

<DataField>

<ControlType>DateEdit</ControlType>

<DataType>Date</DataType>

<DisplayLabel>UTC date</DisplayLabel>

<ElementIdentifier>F408404caa4834a728628e1bcc7cfe109</ElementIdentifier>

<Name>UTC_Date_AttrID_477</Name>

<ReferenceListName/>

<Value>3/21/2022 7:00:00 PM</Value>

</DataField>

... and then other <DAtaField>

</Occurrence>

... and then another <Occurrence>

0695b00000QCyEpAAL.png0695b00000QCyEkAAL.png

in the tXMLMap I can find :

0695b00000QCyFJAA1.png

In the output I get zero result !!! what is not clear is the syntax of output capure in the tXMLmap vs my xml content I copy / past :

[resp_soap1.Soap:/s:Envelope/s:Body/GetOccurrencesResponse/GetOccurrencesResult/Occurrence/DataFields/DataField/ControlType]

Any idea of what is wrong ?

Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi

tSOAP returns a string type, not a Document, you should use tExtractXMLFields to extract data from the response.

Regards

Shong

View solution in original post

1 Reply
Anonymous
Not applicable

Hi

tSOAP returns a string type, not a Document, you should use tExtractXMLFields to extract data from the response.

Regards

Shong