Maybe you should take the problem on the other side. Try to list all VMs, retrieve for each vApp and Datastore.
Once you have it in a table, you can parse it as you want
Another thing to keep in mind : "vApp (vCloud) = Folder (vCenter)". You can try with this too 
Regards
DC