Wednesday, May 23, 2012

Convert Notes View into JSON using URL

In our mobile or web application, we need our standard Lotus Notes view in the format of JSON(JavaScript Object Notation). So we can use the following URL to get our notes in JSON format.
URL: 
http://servername/databasepath/viewname?readviewentries&outputformat=JSON
Example:
http://localhost/MyDocumentation.nsf/vw_Employee?readviewentries&outputformat=JSON

Note: It will give all the data about the view and the documents it contains. I will also give lot of information which we actually don't need. For that we will write an LotusScript agent to construct the JSON from the view.
We will see this example in the next post.

2 comments:

  1. Hi,
    If you want to convert notes view into xml, use the following url.
    http://servername/databasepath/viewname?readviewentries&outputformat=XML

    ReplyDelete