CODEWITHSUNDEEP
jsonsapui5
zerocool985
zerocool985

Reputation: 13

SAPUI5 access getProperty() of Json Model (undefined). The Model itself is accessible

I can't access my JSON model which has been defined in the manifest.json.

My JSON data "zCatsTestJ" looks like this:

{
    "d": {
        "results": [{
            "status": "30",
            "skostl": "6210",
            "catshours": "2.50",
            "ktext": "-",
            "counter": "000003484040",
            "mandt": "101",
            "pernr": "00015822",
            "usrid": "-",
            "workdate": "\/Date(1477267200000)\/",
            "raufnr": "6000025",
        }, {
            "status": "30",
            "skostl": "6210",
            "catshours": "2.50",
            "ktext": "-",
            "counter": "000003484040",
            "mandt": "101",
            "pernr": "00015822",
            "usrid": "-",
            "workdate": "\/Date(1477267200000)\/",
            "raufnr": "6000025",
        }]

    }
}

The model seems to be accesible as sJsonDate1 is showing me the data in the console but I can't access a single date. In the end I want to loop over those dates and change the formatting.

var sJsonDate1 = this.getOwnerComponent().getModel("zCatsTestJ");
var sJsonDate2 =this.getOwnerComponent().getModel("zCatsTestJ").getProperty("/d/results/1/workdate");
console.log(sJsonDate1);
console.log(sJsonDate2);

Here is the console output where I can see the complete data.

Console sJsonDate1

But when I try to access one datapoint it says undefined

Console sJsonDate2

I have also instatiated the Model directly in the component and it is working fine. When I compare the model object from getOwnerComponent() and the new one they are nearly the same except for the local one having no aBindings

Model comparison in console

Any help will be highly apreciated. Thanks

Upvotes: 0

Views: 3421

Answers (2)

zerocool985
zerocool985

Reputation: 13

Here is the solution. Somehow the JsonModel was too big (667 Data Points) and wasn't loaded on the time of calling it. That's why it has worked with only two entries.

myModel.attachRequestCompleted(function() {
                    var sJsonDate = myModel.getProperty("/d/results/1/workdate");
                    console.log(sJsonDate);
});

Upvotes: 0

Daniel Almeida
Daniel Almeida

Reputation: 362

Your JSON is invalid, status is missing " and you never close the array. I tried it locally after correcting your JSON and it worked fine on my end.

var json = {
    "d": {
        "results": [
        {
            "status": "30",
            "skostl": "6210",
            "catshours": "2.50",
            "ktext": "-",
            "counter": "000003484040",
            "mandt": "101",
            "pernr": "00015822",
            "usrid": "-",
            "workdate": "\/Date(1477267200000)\/",
            "raufnr": "6000025",
        }, {
            "status": "30",
            "skostl": "6210",
            "catshours": "2.50",
            "ktext": "-",
            "counter": "000003484040",
            "mandt": "101",
            "pernr": "00015822",
            "usrid": "-",
            "workdate": "\/Date(1477267200000)\/",
            "raufnr": "6000025",
        }]

    }
};
            var myModel = new JSONModel(json);
            this.getView().setModel(myModel, "test");
            this.getView().getModel("test").getProperty("/d/results/1/workdate"); "/Date(1477267200000)/"

Upvotes: 1

Related Questions