JSON data returned by API not showing in webdatarocks angular

Question

I am trying to display the data returned by REST api in json format using angular but nothing loads on screen. Any idea how to achieve that?

Below is what I am trying to do -

getData() {
   this.service.getData().subscribe((res) => {
     this.result = res;


this.pivotReport = 
         {
     
            "dataSource": {
               "dataSourceType":"json",
               "data":this.result
             },
            "slice": {
                "rows": [
                  {
                     "uniqueName":"Country",
                     "sort":"asc"
                  },
                  {
                     "uniqueName":"Business Type",
                     "sort":"asc"
                  },
                  {
                     "uniqueName":"Category"
                  }
                 ],
                "columns": [
                     // {
                     //    "uniqueName":"Category",
                     //    "sort":"asc"
                     // },
                     // {
                     //    "uniqueName":"Country",
                     //    "sort":"asc"
                     // }
                 ]
}
});
}

more context please, could you share a stackblitz with your example ? — Tim, Mar 29 '22 at 21:53
the data is not enough to help you... you need to share some of your component and related view code. — The Fabio, Mar 29 '22 at 23:31

score 0 · Answer 1 · answered Mar 31 '22 at 13:18

Nothing loads on the screen because you need to pass the report into the pivot component explicitly. You should use the setReport() command to do that.
Find examples of this method in documentation.

Also, your report example seems to display an empty grid even if all data is passed to pivot. You may also try to set measures to aggregate your data, like this:

"slice": {
      "rows": [...],
      "columns": [...],
      "measures": [{
       "uniqueName": "Category",
       "aggregation": "count"
      }]
    }

JSON data returned by API not showing in webdatarocks angular

1 Answers1