Forum Discussion
How to handle a column error and avoid loosing all previously calculated data
Hello everyone, I have built an Excel file that gets data from REST API using the web.contents function. The result of the API (Json) is developed in order to have some of the content of the data...
PhilipTreacy
Super User
Super UserHi stephdurand
Hard to give advice without seeing the code and data but you might be able to use try ... otherwise to check what the API returns and take appropriate action.
This might explain how to use try ... otherwise
IFERROR in Power Query Using TRY OTHERWISE • My Online Training Hub
Regards
Phil