We have a process in which we receive data from multiple customers where the data comes in multiple ways. There is not a template that they all use, nor can we make that happen. The data typically comes in as “columns”. By this I mean visually looks like columns, but it is not all the same from the bot point of view - some use spaces to make it look like columns, some tabs, some copy in an excel table, etc.
Coding has been a nightmare. Our developer had coded the bot to read the emails in and parse them out into a table format so that they can all use the same code after the parsing is done. The issue we have is that each customer comes in differently so we are trying to make the code work for all customers.
Is there a better approach or is this process better suited for API?