20
Views
5
Comments
[Excel To Json] Error on converting Excel to Json
excel-to-json
Service icon
Forge asset by Leonardo Pires
Application Type
Service
Service Studio Version
11.54.76 (Build 63581)

Hello,

I have an app to upload an Excel and store it's JSON to later manipulate it on DataGrid.

When I try to upload the file and convert it to JSON, I get this error: "The underlying connection was closed: The connection was closed unexpectedly. "

This error occurs on the PostConvert server action inside the ExcelToJson action. What I gather is that the link to the REST API may be wrong or missing something.

So, I need help to figure out this error and use this component.

Thank you in advance,
Sofia Rodrigues.

2024-10-03 06-30-47
Bharathiraja Loganathan

HI @Sofia Rodrigues 

can u please share me OML to check what wrong it is 


UserImage.jpg
Sofia Rodrigues

Hi Bharathiraja,

I can't share the OML but I can show it to you:

When I run the "ExcelToJson" server action, I get the error I mentioned on the post.

I'm just sending the BinaryData from the file (Excel) I get on the Upload Widget.

Thank you.

2024-10-03 06-30-47
Bharathiraja Loganathan

because i tried now it is working fine 

2024-10-03 06-30-47
Bharathiraja Loganathan

please reconsume that forge component and try it again 

UserImage.jpg
Sofia Rodrigues

Hello again,

I removed the module ExcelToJson_CS and reinstalled it, but I have the same problem.

I believe it has something to do with my dependencies and perhaps not with the component itself.

Thank you for your help.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.