Hi everyone, I need to get two different currency rates (euro and usd) from a website and then insert those values into Oracle application on a daily basis. When the website opens, it displays today’s rates as default and I need to get yesterday’s currency dates (systemdate-1) for Oracle. Because of that, robot selects the yesterday’s date and the page displays yesterday’s rates. What is the best method to copy those two numerical values?
Screen scraping methods did not work for me because the page changes everyday and page reloads with date selection. When I tried data scraping, the excel output of the datatable had wrong format for numbers(For example currency rate is 10,8234 on the website but it came as 108.234 with data scraping to excel, both the number is wrong and I need comma instead of dot). And I’m scared that if the page owners decide to add or remove some rates from their webpage, the automation would not work because I’m specifying to robot which excel cell values it should get.
What method do you suggest for my case? I am new to uipath and I have wasted so much time on this, so I really would appreciate the help, thanks