A Notes database with updated XMLExportPaging Agent
updated 9/4/2009
File to download --->

This is a generic web agent that returns XML data from any Notes database by using URL parameter.
for example:

http://www.msdomino.net/orders.nsf/XMLExportpaging?open&orders.nsf!VIEW!complete customer orders!orderID!CustomerID!

This URL call with parameters will open the "orders.nsf" database and collect all the documents in the View called "complete customer Orders" and return and XML version of the field values fro "orderID" and " CustomerID". You can add shipCity or shipCountry.

If you add a Page parameter:
http://www.msdomino.net/orders.nsf/XMLExportpaging?open&orders.nsf!VIEW!complete customer orders!orderID!CustomerID!Page=10,15

Page=10,15 means return the 10th page with a per page size of 15. This way we only get one page at a time making it very fast when dealing with large databases.

You can also use the Search command to select documents:
http://www.msdomino.net/orders.nsf/XMLExportpaging?open&orders.nsf!search!form="order"%20&%20ShipCity="London"!orderID!CustomerID!OrderDate!Freight!ShipAddress!ShipCity!shipCountry

This URL opens the order.nsf database and searches for documents with the "form" item that equals "order" and the item ShipCity equals "London". One these documents are selected, we output XML for the list of field name listed.


The Agent is in the attached database. Give it a try.