Json Data into Excel file

Question

Hi Everyone,I have a table with one column type as JSON datatype and using to save the data through write to records. Now I have to export this table data into excel file and share it everyday so I have created a CDT for that table.In CDT it is defaulted to text even I have given longtext datatype. Now there is an issue with the data as the database table have more than 4000 characters the CDT is not allowing more the 4000 so my data into excel is not exceeding more than 4000 characters.Please suggest how to handle this or any alternate better approach.

mathieud0001 · Accepted Answer

Just created a table and created a data type from the table and this is the XSD that it generated.

Seems like it used LONGTEXT.


  
    
      @Table(name="S_JSON")
    
    
      
        
          @Id @GeneratedValue @Column(name="id", nullable=false, unique=true, columnDefinition="INT")
        
      
      
        
          @Column(name="jsonText", columnDefinition="LONGTEXT")

mathieud0001 · Answer

You need to manually update the XSD to use @Column(columnDefinition = "TEXT") for the desired column.

Sign up

Login with SSO

Login to the community

Login with SSO