How to generate JSON

Follow

Saurabh Agashe

• April 16, 2015 17:55

I am having hard time generating valid JSON from a Excel file with Keys and values. Here is the sample input and expected output. Please send your suggestions.

Input:
    id  attributename   attributevalue
    1   merged             FALSE
    1   haschildrencode    {"Value":1}
    1   owninguser         {"Id":"100","LogicalName":"systemuser","Name":null}

    Output:
ID  JSON OUTPUT
1   {
    "merged":"FALSE",
    "haschildrencode":{"Value":1},
    "owninguser":{"Id":"100","LogicalName":"systemuser","Name":null}
    }

Thank you for the help.

0

• Official comment

  

  Saurabh Agashe

  • April 16, 2015 17:55

  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

  • April 16, 2015 17:55

  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

  • April 16, 2015 17:56

  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.