Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

How to get VisualName from report.json pbip file?

Hi,

 

after saving report as project I am getting json like here:

      "visualContainers": [
        {
          "config": "{\"name\":\"664d9c068b02cb6d0e93\",\"layouts\":[{\"id\":0,\"position\":{\"x\":28.730650154798763,\"y\":22.786377708978332,\"z\":0,\"width\":347.7399380804954,\"height\":682.6006191950465,\"tabOrder\":0}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"VolumesDes.Topology\",\"active\":true},{\"queryRef\":\"VolumesDes.Tier\",\"active\":true}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"v\",\"Entity\":\"VolumesDes\",\"Type\":0}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"Topology\"},\"Name\":\"VolumesDes.Topology\",\"NativeReferenceName\":\"Topology\"},{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"v\"}},\"Property\":\"Tier\"},\"Name\":\"VolumesDes.Tier\",\"NativeReferenceName\":\"Tier\"}]},\"expansionStates\":[{\"roles\":[\"Values\"],\"levels\":[{\"queryRefs\":[\"VolumesDes.Topology\"],\"isCollapsed\":true,\"identityKeys\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"VolumesDes\"}},\"Property\":\"Topology\"}}],\"isPinned\":true},{\"queryRefs\":[\"VolumesDes.Tier\"],\"isCollapsed\":true,\"identityKeys\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"VolumesDes\"}},\"Property\":\"Tier\"}}],\"isPinned\":true}],\"root\":{\"identityValues\":null,\"children\":[{\"identityValues\":[{\"Literal\":{\"Value\":\"'DB2'\"}}],\"isToggled\":true,\"children\":[{\"identityValues\":[{\"Literal\":{\"Value\":\"'DB2'\"}}],\"isToggled\":true},{\"identityValues\":[{\"Literal\":{\"Value\":\"'NFS'\"}}],\"isToggled\":true}]},{\"identityValues\":[{\"Literal\":{\"Value\":\"'HANA'\"}}],\"isToggled\":true,\"children\":[{\"identityValues\":[{\"Literal\":{\"Value\":\"'NFS'\"}}],\"isToggled\":true}]},{\"identityValues\":[{\"Literal\":{\"Value\":\"'NetWeaverMSSQL'\"}}],\"isToggled\":true,\"children\":[{\"identityValues\":[{\"Literal\":{\"Value\":\"'AAS'\"}}],\"isToggled\":true}]}]}}],\"drillFilterOtherVisuals\":true,\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Basic'\"}}}}}],\"general\":[{\"properties\":{\"orientation\":{\"expr\":{\"Literal\":{\"Value\":\"0D\"}}}}}],\"selection\":[{\"properties\":{\"strictSingleSelect\":{\"expr\":{\"Literal\":{\"Value\":\"false\"}}},\"selectAllCheckboxEnabled\":{\"expr\":{\"Literal\":{\"Value\":\"true\"}}}}}],\"header\":[{\"properties\":{\"text\":{\"expr\":{\"Literal\":{\"Value\":\"'ServerClass by Topology and Tier'\"}}},\"textSize\":{\"expr\":{\"Literal\":{\"Value\":\"16D\"}}}}}]}}}",
          "filters": "[]",
          "height": 682.60,
          "width": 347.74,
          "x": 28.73,
          "y": 22.79,
          "z": 0.00
        },

Id for visual is easy: 

 

but how to find title? 

Best,
Jacek

 

 

3 Replies