Best way to dynamically add large amounts of choices to a drop down

Best way to dynamically add large amounts of choices to a drop down

Hello, I've got  Zoho Creator app and I have a drop down that I'd like to be able to choose from my items list in Zoho Books. The issue with this is that we have thousands of items and my current method takes too long for the data to be fetched.

Here is my current method:
  1. list getItems()
  2. {
  3. conList = List();
  4. list = {1,2,3,4,5,6,7,8,9,10};
  5. for each  li in list
  6. {
  7. resp = invokeurl
  8. [
  9. url :"https://books.zoho.com/api/v3/items?page=" + li + "&per_page=200"
  10. type :GET
  11. connection:"books"
  12. ];
  13. for each  rec in resp.get("items")
  14. {
  15. conList.add(rec.get("item_name") + " SKU: " + rec.get("sku"));
  16. }
  17. }
  18. return conList;
  19. }

I'd like to not use a lookup field as this would require duplicate data to be made in Creator.

Any ideas are appreciated.