Attached file is the custom formula. I have added column L (Letter Code) with formula. Can this be converted to be used in the API and what position it should be placed in?
Have you watched the IOM API video? It might be a helpful introduction to the subject: