How to load json data dynamically in external_choices

[Ashish_Mishra]

Hello, community. I am new in ODK forms. I just want to ask how can I load JSON data in my external_choices at run time dynamically.
Example: I want to load data based on district_id. In my one district, there are 2000 villages, and I have 40 districts in my state. Feeding 40*2000=80000 villages in external_choices and loading it at run time is very ram consuming. So in my case, I'll just want to pass the district_id in my query parameter and villages belonging to that district will be fetched from JSON and loaded into external_choices. Can anybody help how I can achieve it?

[Grzesiek2010]

Hi @Ashish_Mishra
welcome to the forum! Please introduce yourself here!

Answering your question: it's not possible to load json data. You need to convert into it to csv and then filter using your ID and search function

[Ashish_Mishra]

@Grzesiek2010 thank you for your response. Do you have any examples of it? Because I am new into it so not able to understand it. Thank you

[Grzesiek2010]

Maybe I have something but I'm being on vacation now writing this from my phone so can't check but if you don't understand in you can watch this video https://youtu.be/eEXa8GK4yE4
Or browse this forum, I'm sure there are some similar topics here.

[dicksonsamwel]

Hi @Ashish_Mishra,

There are many threads that can help you with this. You can start by checking out this

How to make it easier to select an item in a very long list of choices inside a select_one_external in a repeat in ODK collect

1. What is the problem? Be very detailed. Inside a repeat, I have a select_one_external of species names. It cannot be avoided that this list contains more than a thousand items. In Enketo, this is no problem because autocomplete works. In ODK app, the users are forced to scroll the entire list especially when the species names start with letters S or T, for example. This problem is made more difficult because the repeat loop typically contains at least 5 repetitions, sometimes it my have more…

Also this

Hide select one external on repeat

What is the problem? Please be detailed. I have a select one based on an external csv. For example. when you enter a room number "T0001", It looks through the csv and pullout a list of T0001/1, T0001/2 and T0001/3 which are also select one. I want when the user select T0001/1 and answer the question under that and next it repeats the list T0001/1, T0001/2 and T0001/3. When the repeat happens it should hide T0001/1 since it has already been answered. What ODK tool and version are you using? And…