Trying to figure out the datasrc parameter

Trying to figure out the datasrc parameter

flyboytylerflyboytyler Posts: 4Questions: 2Answers: 0
edited March 2023 in Free community support

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

Answers

Sign In or Register to comment.