Problem with data display in a grid view

Hi! I’m a new person here and i have a problem with data display in a grid view. I would be glad if you would help me!

I connected my data base through REST API and it’s working fine. Drona receives all the data correct. But when i’m trying to display data at the table most of the data is missing. What do i do wrong?

https://1.downloader.disk.yandex.ru/preview/6dfc937c32579a7536c02d417011bfd2d1b2ced06ec8ad7ffeaec887cf7a2311/inf/HFy7-iNdhfwfAlOdAq_TwzJlipCcRevwNFakLcq65NOteQqNvNO8NXc229G1BshUv8ot8CPeYTMmKPy8TFuA3Q%3D%3D?uid=464710499&filename=2022-11-08_19-43-18.png&disposition=inline&hash=&limit=0&content_type=image%2Fpng&owner_uid=464710499&tknv=v2&size=2478x1257

https://1.downloader.disk.yandex.ru/preview/ef258254e4a993ca22f6d02af3caee7381d1ac418414a8a9ee36d345f84b405c/inf/lWK12XbmCqCEfUzdAN9iwJX3OLySwsoO_lKQsEksHlslefpb4vnbjy7GM_l_ZIjBP8qgIQAUkenMpcwVPnT-uw%3D%3D?uid=464710499&filename=2022-11-08_19-44-25.png&disposition=inline&hash=&limit=0&content_type=image%2Fpng&owner_uid=464710499&tknv=v2&size=2478x1257

@Artemmyrigin

Above link seems to be giving 403 forbidden response. However, above issue usually happens if we select keys belonging to different hierarchy. In that case, you can use transform response to modify the output in a format which will have keys in same level.

{
  "data": [
                {
                  "level_1" : "abc",
                  "inner_data" : [
                         {
                                    "level_2" : "xyz"
                         }
                   ]
                }
  }
}

For example - When binding Tablegrid, you can use - data.level_1 and data.inner_data but you cannot use data.inner_data.level_2 along with the above keys. If you want to use level_2 key then you will have to transform the response using JS Code and make this level_2 key at the same level as level_1 key.

For more info on transform response - refer this

Hope this Helps!

1 Like