How to generate JSON

Comments

3 comments

  • Official comment
    Saurabh Agashe

    Checkout the JSON_MAP function. It takes a json array of keys and a json array of values:

    https://documentation.datameer.com/documentation/current/JSON_MAP

    Comment actions Permalink
  • Saurabh Agashe

    Thank you. TO be more specific - we have to use TOJSON(GROUPCONCAT(AttributeName)) and same for AttributeValue and then have to use JSON_MAP on the outputs. But JSON_MAP is converting quotes in the data to \u0026quot

    I am not sure if there is a way to fix it but this will sure help me to proceed.

    thanks

    0
    Comment actions Permalink
  • Saurabh Agashe

    yeah, I can see that. You can always wrap the additional escaped quotes using REPLACEALL(#colum;"\u0026quot";"")

    0
    Comment actions Permalink

Please sign in to leave a comment.