When using nested groups, only the latest data is accessible through api

[theshashipatil]

Our organisation has been using KoBoToolbox for data collection of the past few months and it has been so awesome an experience. Thank you for all the work the KoBoToolbox team has done in creating such a wonderful service.

For a certain purpose, we require use of nested repeats in the form. I have tried using the XLSForm given here to create one:

nested_repeat.xlsx

Here’s how the form looks: Enketo Express for KoBo Toolbox

However, when I try to download the live data with labels, data from only the latest repeat group is downloaded. Data from previous nested groups within the same submission is not visible in the data.

Why that would be the case?

Please help.

[Kal_Lam]

Welcome to the community, @theshashipatil! Would you also mind sharing with us your API so that the community could add to it if there is anything updated?

[theshashipatil]

Sorry I am not a very technical person but I followed this method shown here:

API to GET Kobo submissions using 'label' rather than value

After making your data public: Settings–> Sharing–> [image] USE THIS GENERAL STRUCTURE: Default Language: https://kc.humanitarianresponse.info/“USER_ACCOUNT”/reports/“FORM_ID”/export.csv Or other instance… EXAMPLE of FORM_ID_IN_KOBOTOOLBOX: a5n9jp9qxyiKPfRNYq7KAt If “english” is one of your languages… https://kc.humanitarianresponse.info/ USERNAME /reports/ FORM_ID_IN_KOBOTOOLBOX /export.csv ?lang=english

Accordingly, I am using this API link to connect live data to Power BI:
https://kc.kobotoolbox.org/theshashipatil/reports/a6EeDXCBhKJuP2WZd3gsi3/export.xlsx

In the repeat_B file, only the latest data is displayed, Previously entered data in this repeat group is not displayed, You can observe that index in the repeat_B file starts from 3. Index number 1 and 2 are missing.

and here’s the actual form if you would like to try making some entries: Enketo Express for KoboToolbox

Thank you for taking a look at this:)

[theshashipatil]

@Kal_Lam Please have a look at this if there is a solution to this problem. Thank you

[Kal_Lam]

Have you gone through this post, it should also be helpful:

Managing repeat groups with Power BI

This is quite off-topic from this thread, it would be better if you started a new thread. One possible solution would be using the Power Query Editor (Home ribbon, Transform data button). Select all the other columns (besides lat and lon), then choose Group By. In the Group By pop-up choose Advanced. Choose Add aggregation, then choose New column name = lat, Operation = Max and Column = lat. Repeat for lon. You can delete or ignore the default Count aggregation. It should then summarise the …

[theshashipatil]

Thank you for the link @Kal_Lam . I went through the link and it doesn’t seem to address the issue I am facing.

When I manually download the data from the KoBoToolbox, I get the data from all the repeat groups entered. Same is the case when I connect Excel or Power BI with REST API from this link: https://kc.kobotoolbox.org/api/v1/data

However, it is only when I try to get the live data with labels that earlier entered repeat groups disappear.Nested repeats with labels.xlsx (407.3 KB) nested_repeat_-latest_version-labels-_2021-03-11-09-09-23.xlsx|attachment (6.8 KB)

I have attached the two files above. Please check the repeat_B sheets in both files.