Right now there is a missmatch between the ID provided in game and the ID provided by the AH API

ingame-ids.zip

heres the list of in game ids mapped to the english names, now to just map the api ids directly to the in game ids

ok this one takes the in game id and maps it to the id of the connected realm id that we use for the api and db names Archive.zip

keeping this one open for now i gotta fix it in the api too

Ok this is now fixed in the api, now instead of the GetRealmName() we can use somthing like GetRealmID() the api can understand the realm ids or realm name but the json field still needs to be homeRealmName

https://github.com/ff14-advanced-market-search/SaddlebagExchangeWoW/blob/main/main.lua#L100

https://wowpedia.fandom.com/wiki/API_GetRealmID