Create a JSON Model from data in file

[SandipAgarwalla]

Hi

How do we create a JSON Model for the data which is defined in a .json file in the project resources

e.g. my data is stored in data.json file which is under models folder.

Now I need to create a model for it, I tried

var json = new sap.ui.model.json.JSONModel("/models/data.json");
json.setData({modelData:"sampleData"});

json.attachRequestCompleted(oData, function(){
  sap.ui.getCore().setModel("json",json);
     var nLength = json.getData().d.results.length;  
  alert(nLength);
  });

But it didn't work. The data.json has the format

var sampleData = [
{<somedata>},
{<somedata>}
];

Any pointers??

Thanks

Sandip

[former_member91307 · Accepted solution]

Hi Sandip,

JSON format could be validated with JSONLint - The JSON Validator.

Calling method setData is not required.

Below example might help

http://plnkr.co/edit/JMfSKGrA1xUimj9kzamO?p=preview

Thanks and Regards, Venkatesh

[SandipAgarwalla · Accepted solution]

Hi Simon, Venkat

I tried both the approaches, but still get a problem - 4040 Not found

GET http://localhost:8080/<projectName>/models/data.json 404 (Not Found)

So the problem is somewhere else. I tried loading the resources but no help

sap.ui.localResources("<projectName>/models");

BTW, the json defined in the file had a minor issue. that is fxed - thanks venkat

Regards
Sandip

[former_member91307 · Accepted solution]

Hi Sandip,

Please find attched snap shot of project structure.

Thanks and Regards, Venkatesh

[SandipAgarwalla · Accepted solution]

HI Venkat

Still cant get it to work. I have the view defined in a separate folder.

so i tried

var json1 = new sap.ui.model.json.JSONModel("./models/data.json");

<note the period before /model> but error

GET http://localhost:8080/<projectName>/models/data.json 404 (Not Found)

Thanks

Sandip

[former_member91307 · Accepted solution]

Hi Sandip,

Can you post a sanp shot of folder structure.

Could try the following too

1. sap.ui.localResources("<project_name>");

2. var json1 = new sap.ui.model.json.JSONModel("models/data.json");

Thanks and Regards, Venkatesh

[SandipAgarwalla · Accepted solution]

Venkat

I already tried with jQuery.sap.require();

Here is the project structure

I even noticed the same problem if I add any image from the folder e.g. to a button icon

Thanks

Sandip

[former_member182372 · Accepted solution]

Sandip, check the .war file to make sure it contains data.json file. BTW, do you have any servlets in web project?

[SandipAgarwalla · Accepted solution]

Hi maksim

I do not have any servlets...the war file does contain the json file.

Well, the problem was the folders were under the webcontent->projectname, rather than under the webcontent folder

I fixed the folder structure..

Thanks

Sandip