I have a requirement where we need to send data from tables to PUB/SUB API in JSON formate . for this i tried fetching data from tables using queryentity then converting data to json .While sending we also converting that data to encodebase64string and touniformstring . here the issue is we are unable to send large amount of data because encodebase64string has limit on characters . Is there any alternate way to send data .
Thanks,
Discussion posts and replies are publicly visible
Do you have to encode it in base 64? What's wrong with just sending the json?
yes we need to encode in base64 . because body of json is expected to enocde to there API
There is a way but it is somewhat convoluted.
First you need to store the json in the Database and then query it back using a stored procedure and TO_BASE64 MariaDB function.
mariadb.com/.../
It's possible to build a Base64 encoding expression rule using OOTB functionality only, if you need it.
Can you be more specific please. Also is there any references we can go through?