oData Service for NetworkGraph OrgChart

[christoph_buehlmann]

Dear Experts

There is a great blog on SDN explaining how to use the NetworkGraph control to draw an OrgChart in SAPUI5. And an example can be found in the Demo Kit.

We could implement the frontend path easily in WebIDE and are using mockdata to show some employees. All good.

But now we would like to use this for real and replace the mock Data with live Data through an oData Service, and that's where I struggle.

Can anybody give me some input what the oData Service needs to look like to deliver JSON Data like requested by the frontend control?

In the sample application I can see the following JSON:

I guess My oData Service needs three entities (with their respective properties):

lines, nodes and attributes.

But how do they need to be called and connected together ($expand?) to get the data of the three entities in one JSON as in the sample application?

Thanks a lot for your feedback

Regards
Christophe