Skip to main content
April 23, 2024
Solved

How can I have more than 5000 choiceValue from api

  • April 23, 2024
  • 8 replies
  • 0 views

I have a dropdownfield whose choiceValue are from an api, the records from api are more than 5000, but pagingInfo only allows 5000 at max for batchSize, how can I do to put all choiceValue in this dropdownfield?

    Best answer by stefanhelzle0001

    Not!

    If you need to support a user selecting items from > 5k elements, please implement a custom picker field that queries the API in the background.

    8 replies

    stefanhelzle0001
    Brainy
    April 23, 2024

    Not!

    If you need to support a user selecting items from > 5k elements, please implement a custom picker field that queries the API in the background.

    April 23, 2024

    Got it, thank you, will look into custom picker field

    stefanhelzle0001
    Brainy
    April 23, 2024

    A custom picker can be a challenge. Make sure to perform the actual data fetching inside the suggest function, forwarding the user search text to the API to return only matching items.

    venkatrea696188
    April 23, 2024
    I have a dropdownfield whose choiceValue are from an api, the records from api are more than 5000

    IMHO if the choice values count is more i go with picker fields. 

    And I suggest you to use filters on source rather than getting all the data

    rohitm7223
    April 23, 2024

    For handling such a large dataset, it is recommended to use a custom picker.

    Additionally, it is advisable to begin entering a few characters, and only after, for example, three characters have been inputted, should the suggestion function be executed.

    April 23, 2024

    How can I set that limit?

    dhananjayk3480
    April 23, 2024

    You run your API only when user enters atleast 3 characters

    harshk1671
    April 23, 2024

    Try this SAIL recipe to switch between dropdown and picker fields conditionally.
    docs.appian.com/.../recipe-configure-an-array-picker-with-a-show-all-option.html