Skip to Content (Press Enter)
2020-10-19 05-14-26
Huyen IT
155Views
2Comments
Solved
[OutSystems Data Grid Web] Binary Data error when send JSON
Question
Data
Forge
Logic
outsystems-data-grid-web
Web icon
OutSystems Data Grid Web (O11)
Forge asset by OutSystems

Hi,

When i tried use Sample_Employee data, it has Binary data and when send JSON,

it generates errors because Binary data is displayed as text and there exceeded length.

Maybe it didn't convert (TextToBinaryData) before send JSON.


How can i fix it?

Regards,

0
0
06 Feb 2020
Copy Link
2026-03-20 01-28-51
Saugat Biswas
Solution

Huyen IT wrote:

Hi,

When i tried use Sample_Employee data, it has Binary data and when send JSON,

it generates errors because Binary data is displayed as text and there exceeded length.

Maybe it didn't convert (TextToBinaryData) before send JSON.


How can i fix it?

Regards,

Hi Huyen,

We had faced similar issue with images. However we took a workaround to resolve it.
Before sending the data with JSON, we converted them to base64 string.

BinaryToBase64()

And later before storing to DB convert back from base64 string to binary if the image datatype is binary.

Base64ToBinary()


Somehow we found issues with BinaryDataToText and TextToBinaryData and hence recommend not using it.

BinaryDataToText()
TextToBinaryData()


Regards,

Saugat


1
0
18 Feb 2020
Copy Link
2020-10-19 05-14-26
Huyen IT

Saugat Biswas wrote:

Huyen IT wrote:

Hi,

When i tried use Sample_Employee data, it has Binary data and when send JSON,

it generates errors because Binary data is displayed as text and there exceeded length.

Maybe it didn't convert (TextToBinaryData) before send JSON.


How can i fix it?

Regards,

Hi Huyen,

We had faced similar issue with images. However we took a workaround to resolve it.
Before sending the data with JSON, we converted them to base64 string.

BinaryToBase64()

And later before storing to DB convert back from base64 string to binary if the image datatype is binary.

Base64ToBinary()


Somehow we found issues with BinaryDataToText and TextToBinaryData and hence recommend not using it.

BinaryDataToText()
TextToBinaryData()


Regards,

Saugat


Thanks Saugat Biswas,

This is the solution, but in my case, it should be handled in Data GridFramework.


0
0
19 Feb 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.