JSON Deserializer to Table Error

Hi @MK101280,

The error message “For input string: ‘95.0’” suggests that the deserializer is trying to convert the string “95.0” into a different data type, likely an integer, which is causing the exception

Here are a few steps you can take to troubleshoot and resolve this issue:

1. Check Data Types: Ensure that the data types in your JSON string match the expected data types in your table. For example, if the table expects an integer but receives a float (like “95.0”), it will cause an error.

2. Modify JSON Structure: If possible, modify the JSON structure to ensure that numeric values are in the correct format. For instance, you can change “95.0” to “95” if an integer is expected.

3. Use String Operations: Before deserializing, use string operations to manipulate the JSON string and convert any float values to integers if necessary.

4. Review the Log File: Check the bot_launcher.log file for more detailed information about the error. This log file can provide insights into what specifically is causing the issue

Hi @Tamil Arasu10 , unfortunately I can’t remove the decimal points on these numbers; they have to stay. I tried adding quotations around all of the numbers in the JSON string, but that didn’t work either. Do you know where the bot_launcher.log typically is located? I also saw that I am able to use the convert to dictionary, just not the convert to table.

Hi @MK101280,

C:\ProgramData\AutomationAnywhere\BotRunner\Logs

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/working-with-automation-tasks/analyze-bot-agent-logs.html