My SOAP call returns null or empty response. I followed all steps from PTC white paper.

Is this issue resolved? If yes, please mark correct and helpful answers to help other members know that this Thread has a solution.

A

ankigupta

5-Regular Member

It seems that the xml received contains the <!DOCTYPE> tag.

You must be getting following error in script logs while running this service:

Execution error in service script [Thing1 Readxml] : Wrapped org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 10; DOCTYPE is disallowed when the feature "http://apache.org/xml/features/disallow-doctype-decl" set to true. Cause: DOCTYPE is disallowed when the feature "http://apache.org/xml/features/disallow-doctype-decl" set to true.

In order to prevent XML External Entity (XXE) attacks, ThingWorx explicitly restricts the use of the <!DOCTYPE> tag in XML processing calls.

Any XML document retrieved by the ContentLoaderFunctions.GetXML() service must not contain a <!DOCTYPE> tag.

I hope it helps.

Author

1-Visitor

Hi Ankit,

Thanks for your valuable reply but I called some other service which does not included >!DOCTYPE> tag, but it also returns empty response. Can I add WSDL description in above snippet? I paste my updated code with WSDL. I also try below code without WSDL. But doesn't work for me. Please add your comments.

var content = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:hs="http://www.holidaywebservice.com/HolidayService_v2/">\
<soapenv:Body>\
<hs:GetHolidaysAvailable>\
<hs:countryCode>UnitedStates</hs:countryCode>\
</hs:GetHolidaysAvailable>\
</soapenv:Body>\
</soapenv:Envelope>';

var params = {
proxyScheme: undefined /* STRING */,
headers: undefined /* JSON */,
ignoreSSLErrors: undefined /* BOOLEAN */,
useNTLM: undefined /* BOOLEAN */,
workstation: undefined /* STRING */,
useProxy: undefined /* BOOLEAN */,
withCookies: undefined /* BOOLEAN */,
proxyHost: undefined /* STRING */,
url: "http://www.holidaywebservice.com//HolidayService_v2/HolidayService2.asmx?wsdl" /* STRING */,
timeout: undefined /* NUMBER */,
proxyPort: undefined /* INTEGER */,
password: undefined /* STRING */,
domain: undefined /* STRING */,
username: undefined /* STRING */
};

// result: XML
var result = Resources["ContentLoaderFunctions"].GetXML(params);

//var result = xmlPage.*::soapenv.GetHolidaysAvailable.countryCode;

var params2 = {
infoTableName : "InfoTable",
dataShapeName : "SOAP_DataShape"
};

// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(SOAP_DataShape)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params2);

for each(var tag in xmlPage.channel.item){
// SOAP_DataShape entry object
var newEntry = new Object();
newEntry.Description = item.Description; // STRING
newEntry.HolidayCode = item.HolidayCode; // STRING
result.AddRow(yourRowObjectHere);
}

A

ankigupta

5-Regular Member

I tried this a bit and i was able to read some data using following code. Please make changes as per your requirement.

StringDataShape is a datashape with a String field named StringValue

var params = {
proxyScheme: undefined /* STRING */,
headers: undefined /* JSON */,
ignoreSSLErrors: undefined /* BOOLEAN */,
useNTLM: undefined /* BOOLEAN */,
workstation: undefined /* STRING */,
useProxy: undefined /* BOOLEAN */,
withCookies: undefined /* BOOLEAN */,
proxyHost: undefined /* STRING */,
url: "http://www.holidaywebservice.com//HolidayService_v2/HolidayService2.asmx?wsdl" /* STRING */,
timeout: undefined /* NUMBER */,
proxyPort: undefined /* INTEGER */,
password: undefined /* STRING */,
domain: undefined /* STRING */,
username: undefined /* STRING */
};
// result: XML
var resultXML = Resources["ContentLoaderFunctions"].GetXML(params);
var params = {
  infoTableName : "InfoTable",
  dataShapeName : "StringDataShape"
};
// CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(StringDataShape)
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);
var newRow = new Object();
for each (var tag in resultXML.*::portType.*::operation.*::documentation) {
    newRow.StringValue = tag;
    result.AddRow(newRow);
}

I hope it helps.

Author

1-Visitor

Here is my output.

A

ankigupta

Answer

5-Regular Member

Is this issue resolved? If yes, please mark correct and helpful answers to help other members know that this Thread has a solution.

Author

1-Visitor

Hi Ankit Gupta,

Can we consume xml from localhost. i.e if our Thingworx application and source machine in same network, in such case can we consume XML from localhost?

I am trying to call my local xml file on at "http://localhost:8087/ws/hello?wsdl" in same network but following error occurred:

Wrapped org.apache.http.conn.HttpHostConnectException: Connect to localhost:8087 [localhost/127.0.0.1, localhost/0:0:0:0:0:0:0:1] failed: Connection refused (Connection refused) Cause: Connect to localhost:8087 [localhost/127.0.0.1, localhost/0:0:0:0:0:0:0:1] failed: Connection refused (Connection refused)