Hi.
In the data export settings in Kobo Data, there is an option to include or exclude fields or columns from the dataset. What if there were also an option to filter data based on record values using conditional rules like “OR” and “AND” for one or more conditions, whether applied to a single column or multiple columns? These settings could then be saved under a specific name, and when importing data from API endpoints, the filter logic would not appear or include any additional query text—ensuring that the final user cannot remove it and that the API returns all data securely.
The question is about whether there is a way to secure an API that appears without additional filter text, which performs data filtering within kobo, so data is ready for display on any platform without applying any filters from external import sources.
Welcome to the community, @talaldeveloper! Have you had a look at this api documentation?
You should be able to learn more here:
https://kf.kobotoolbox.org/api/v2/docs/ or https://eu.kobotoolbox.org/api/v2/docs/
Kal_Lam.
Thank you for the warm welcome and the response.
I mean creating an export from this page:
https://eu.kobotoolbox.org/#/forms/******///data/downloads
with a filter applied to specific record values, not by including or excluding fields.
Currently, on that interface, there is no option to create an export filtered by record values.
The goal is to obtain a final URL, such as:
https://eu.kobotoolbox.org/api/v2/assets/*****/export-settings/*****/data.xlsx
This URL would normally appear in:
https://eu.kobotoolbox.org/api/v2/assets/*****/export-settings/
but filtered according to specific values in the records, not for the full dataset.
By checking the export settings interface here:
https://eu.kobotoolbox.org/#/forms/******///data/downloads
it is clear that there are no options to create an export filtered by record values.
The goal is to have a ready-to-use final download link, such as:
https://eu.kobotoolbox.org/api/v2/assets/*****/export-settings/*****/data.xlsx
that is filtered, not containing all records.
@talaldeveloper, you may try the following steps until the filter option is built into our system, which is currently only supported through the API:
- Go to
https://kf.kobotoolbox.org/api/v2/docs/ or https://eu.kobotoolbox.org/api/v2/docs/ depending on the server you are using.
- Scroll down to search this part:
- Fill up the parameters as shown in the image below (as per your needs) and then execute:
- Once it’s executed, go back to the DATA>Download page and then refresh the page. You should see a new export ready:
- Download the filtered data.
@Kal_Lam
Thank you for your response and the information provided.
