title: How to render JSON using Stream Analytics Query
body: <p>I have Inputs in the form of JSON stored in Blob Storage
  I have Output in the form of SQL Azure table.</p>
  
  <p>My wrote query and successfully moving value of specific property in JSON to corresponding Column of SQL Azure table.</p>
  
  <p>Now for one column I want to copy entire JSON payload as Serialized string in one sql column , I am not getting proper library function to do that.</p>
  
  <pre><code>SELECT
       CASE 
          WHEN GetArrayLength(E.event) &gt; 0
              THEN GetRecordPropertyValue(GetArrayElement(E.event, 0), 'name')
          ELSE ''
      END AS EventName 
      ,E.internal.data.id as DataId
      ,E.internal.data.documentVersion as DocVersion
  
      ,E.context.custom As CustomDimensionsPayload
  
  Into OutputTblEvents
  FROM InputBlobEvents E
  </code></pre>
  
  <p>This <strong>CustomDimensionsPayload</strong> should be a JSON actually</p>