We have a requirement where we have one csv file which contains around 30K records of data and need to extract complete row based on data values passed as an API or search parameter. Each time there can be different data values passed.
What is the best and efficient way of achieving this. I was reading about KV store which might be able to give desired result.
Can I can use KV store or CSV lookup to test this? How this is achievable?