I have one field in PSQL DB Table from where I am extracting data from the server, that field contains data in JSON format.
After extraction that field shows empty values and length is zero, but it contains data, on using SQL Select field from table using LIB Connect to the server, no values is shown, after applying length to that field value is in the range of 13000-14500 characters, applied left(field,length(field) got to see the JSON data but it seems to limit data as on copying the cell value and pasting in notepad it shows unfinished syntax of JSON. USED JSON_EXTRACT no results function seems to be invalid error is JSON_EXTRACT(text,unknown) like this.
