I'm trying to recover the XML from Content Server from Opentext using url. This is part of the code I'm using. wURL is : https://company.domain/company/cs.exe/?func=ll&objId=999999&objAction=xmlexport.
Set objXMLHTTP = CreateObject("MSXML2.XMLHTTP")
objXMLHTTP.Open "GET", wURL, False
objXMLHTTP.Send
xmldoc.Load objXMLHTTP.responseXML
Set xmlNodeList = xmldoc.getElementsByTagName("llnode")
I get this response :
?objXMLHTTP.responsetext =
<html><body onload="document.forms[0].submit()"><noscript><p><strong>Note:</strong> Since your
browser does not support JavaScript,you must press the Continue button once to proceed.</p>
</noscript><form action=wURL method="post"><div><input type="hidden" name="OTDSTicket" value="
I found out that if I go to the URL via IE prior to executing the function, it loads the XML just fine into xmlNodeList. I tried to automate the process with an IE object that navigate to the URL but it's not viable since I need to look through 500+ XML and eventually IE returns an automation error.
I think by going to the URL before I call my function, I somehow authenticate or create a connection and thus being able to load the XML. I would like to know if it is possible to recreate that authentication by code in a reliable way.
I also tried :
objXMLHTTP.Open "GET", wURL, False, myUserName, myPW
with my credentials but it didn't change anything. Thank you.
Which version are you on? You should try to use the rest api. Available with update 2014-09.