Download data with filter by custom column

Hi team.

I’d like to ask if it is possible to make link for downloading data with certain data in custom column?

Thank you in advance

Welcome to the community, @oksana_ch! Did you mean you wanted to drop some of the variables when downloading the data in XLS format?

If this is what you are looking for, then you can download your data as outlined in this support article Exporting and Downloading Your Data. Be sure to go through the Advanced Options and Select questions to exported:

Hi, Kal_Lam

No, I mean if I can do a link like this example
https://kc.kobotoolbox.org/api/v1/data/1314.xls?start=20_12_03_00_00_00&end=20_12_03_23_59_59

from topic Date filters for downloading - User Support / Data Management - KoboToolbox Community Forum

But I need filter not by date but by my custom field.

Hi, @Kal_Lam . Would you please help with my question?

Hi @oksana_ch , what do you mean by custom column? is it text? is it select one? you need to give more details so we can help

1 Like

Hi @osmanburcu It is text column

Hi again,
You can use the structure below, it works. If you would like to filter the data in .csv version, replace the .json with .csv. If you are using an API, you can delete the .json part.

One point you need to make sure you include the group name to field name section, and field names should be in XML value.

https://kc.humanitarianresponse.info/api/v1/data/{ Your form ID number, example: 1523411}.json?query={“field name”:“Value to filter”}

Yo

1 Like

@osmanburcu, :clap: :heart: :partying_face:

@oksana_ch, FYR …