Manage Learn to apply best practices and optimize your operations.

Using the XMLHTTP object for integration with Domino or any RDBMS back end

This tip demonstrates how to use the XMLHTTP object for integration with Domino or any RDBMS back end.

The XMLHTTP object allows one to open an HTTP connection to a server, send some data, and get some data back, all in a few lines of script. The data exchanged through the XMLHTTP object is usually XML, but it can also be in plain text or binary data. The binary data is particularly useful when uploading files.

The XMLHTTP object can be included on a Notes Form in the JS Header section as a function or directly in the onLoad event of the form. This can also be event driven, i.e., it can be inserted behind a button or image and invoked on click of the respective event handler.

To initialize the object, create a function, 
say 'loadXMLObj()' in the JSHeader of a form.

Function definition
function loadXMLObj()
 var xmlHttp = new ActiveXObject
("Microsoft.XMLHTTP") [Line1] for IE
 var xmlHttp = new XMLHttpRequest(); 
[Line1] for Netscape"GET", "/HTTPAgent?
openagent", false) [Line 2]
 xmlHttp.send() [Line 3]
 xmlStr=xmlHttp.responseText [Line 4]

[Line 1] is the first step wherein you 
initialize the XML object. 
In [Line 2], an HTTP Request is 
sent to the server.
The server in the example above is
 the default Domino server.
The request is like an agent trigger. 
In [Line 3], the Request is sent to the server.
Finally in [Line 4] the Response is 
retrieved and it is in the form of plain text.

The response can be in the form of an
 XML object in which case you will use:

(The XMLDoc in this case is an XML object)

Some of the important properties 
that the XMLObject supports are 
listed below.
readyState – returns the 
loading state of the XMLHTTP object
reponseText – returns the
 request of the object either as a 
string,XML object or binary data
status – returns the status 
of the operation as a code
statusText – return the status
 of the operation as a string

The above properties of the XMLHTTP 
object are particularly useful in order
 to determine
whether the connection to the remote 
server was established successfully or not.

Finally in the onLoad event of the form, 
include the function call 'loadXMLObj()'

Now let us proceed to the agent.

Agent Header

In the beginning of the agent, include 
the following statement:

Print "Content-Type:text/plain"
[Note: This is used if the response 
must be a string]


Print "Content-Type:text/xml"
[Note: This is used if the response 
must be in XML format]   

Agent Body

Here you may include native agent code like-

Dim session as new notessession
Dim db as notesdatabase
[Proceed to initialize all required 
doc handles] ……..

Let us say the requirement is to return 
a field value from a collection of documents.

While not doc is nothing
Print doc.FieldName(0) [Response statement]
 Set doc = DocColl.getNextDocument(doc) Wend

The line marked in Bold is the key command 
wherein the agent 'Response' is sent to the 
This is done using the Print statement.

That's all there is to it. How the agent can be used is left to the Business Requirement.
You can connect to an RDBMS, any third-party application and send the response to the client without page refresh.
The response time is also much faster compared to CGI methods.
Besides agents, you can also use this object to load an XML file and traverse the tree using the XMLDOM.

To use this as a substitute for a 
@Dblookup, you can send the request 
as a 'readviewentries' view command
and the response can be obtained 
in the form of a string.

For example:

var xmlHttp = 
new ActiveXObject("Microsoft.XMLHTTP")"GET", "/SampleView?
false)  [Sorted view]"GET", "/SampleView?
false)  [Categorized view]

Do you have comments on this tip? Let us know.

Dig Deeper on XML and Web Services for Lotus Notes Domino



  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury