Trying to figure out the datasrc parameter

flyboytyler

The HCL Domino server outputs this native JSON format. I am trying to figure out the datasrc parameters to populate a table with this data.

{
    "@timestamp": "20230304T172928,93Z",
    "@toplevelentries": "9",
    "viewentry": [
        {
            "@position": "1",
            "@unid": "C78DC6D4CA8C2D1E8525896200778001",
            "@noteid": "DFA",
            "@siblings": "9",
            "entrydata": [
                {
                    "@columnnumber": "0",
                    "@name": "LastName",
                    "text": {
                        "0": "Dill"
                    }
                },
                {
                    "@columnnumber": "1",
                    "@name": "FirstName",
                    "text": {
                        "0": "Tina"
                    }
                },
                {
                    "@columnnumber": "2",
                    "@name": "EMailAddress",
                    "text": {
                        "0": "TDill@fake.com"
                    }
                },
                {
                    "@columnnumber": "3",
                    "@name": "Country",
                    "text": {
                        "0": "UNITED STATES"
                    }
                }
            ]
        },
        {
            "@position": "2",
            "@unid": "A702AEA388F642CA8525896300521B41",
            "@noteid": "E0E",
            "@siblings": "9",
            "entrydata": [
                {
                    "@columnnumber": "0",
                    "@name": "LastName",
                    "text": {
                        "0": "Exchange"
                    }
                },
                {
                    "@columnnumber": "1",
                    "@name": "FirstName",
                    "text": {
                        "0": "Test"
                    }
                },
                {
                    "@columnnumber": "2",
                    "@name": "EMailAddress",
                    "text": {
                        "0": "TExchange@fake.com"
                    }
                },
                {
                    "@columnnumber": "3",
                    "@name": "Country",
                    "text": {
                        "0": "UNITED STATES"
                    }
                }
            ]
        }
    ]
}

This table would be:
Dill Tina TDill@fake.com UNITED STATES
Exchange Test TExchange@fake.com UNITED STATES

Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide

kthorngren

See if this Nested data source example helps. Assuming you are using ajax.dataSrc I think you will want to set it like this:

  "ajax": {
    "url": "myUrl",
    "dataSrc": "viewentry.entrydata"
  }

Kevin

flyboytyler

I’ll give it a shot, and thanks for the formatting info.