Need to revisit dictionaries

[mso-docs]

The Issue

I noticed that the dictionary for the item IDs is 43,000 lines long, which can make the program run slowly. I want to figure out a way to put this information in a format that is easier to read.

Steps to Reproduce

1. When calling the API, we currently only reference 3 items, which are stagnant. I eventually want to call a database of items, so users can query an item number instead of manually searching the Lodestone for the information and then contacting the API.
2. As it stands now, the user would have to manually input the item name and item ID into the URL to perform the GET request. Unfortunately, this is very time-consuming and defeats the purpose of the API.
3. We created a dictionary of item IDs and item names, which are arranged in chronological order. Unfortunately, this is not the most efficient way to find information, since it is a 43,000 line file.
4. This can make contacting the API slow-- too many lines to go through. Plus, the function we have created to call this information does not work, so for now, our 3 test items are manually mapped to the function, which is great for testing that the API works, but not great for long-term usage.

Suggested Fix

I want to ultimately create a lightweight item database to call to when we need information. I don't want to have to meticulously comb the JSON dictionary I made for items. I want it to be fast and efficient.

Suggested Question

Is it possible to create a database of these items? If so, how difficult would it be for users to simply input the item name into the API?

Other Idea to Consider

Long term, I am also wondering about the feasibility of a GUI for users to type item names into. This may be scope creep, though.

---