Getting an error when trying to use the JSON deserializer to Table option. Does anyone know what this error means? Exception Occurred, refer to bot_launcher.log for details For input string: “95.0”. The JSON string is valid.
Hi
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:
-
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.
-
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.
-
Use String Operations: Before deserializing, use string operations to manipulate the JSON string and convert any float values to integers if necessary.
-
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
Hi
C:\ProgramData\AutomationAnywhere\BotRunner\Logs
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.