thomas_pagel
2 years agoNew Member
Status:
Needs Votes
Event Processing: Derive value from complex JSON
Please allow to derive a value out of a complex JSON which is stored in a single field in your stream
xujx
2 years agoMicrosoft Employee
Thank you, Thomas for your feedback.
May I know what the data type is in the field of the stream? Is it a JSON object or JSON array or JSON-like string?
If it is a JSON object, you can use "Manage field" operator to get the data into a new column.
If it is a JSON array, you can use "Expand" operator to expand these arrays into separate column, then use "Manage field" to get the data into another column.
If it is a JSON-like string, it is not supported yet, but in our roadmap.