Forum Discussion
Eventstream and Azure Event Grid - how to get record/array instead of
Hi foks,
maybe you can solve this by adding a step with a KQL query transformation. There you could parse the json e.g. with the function here:
https://learn.microsoft.com/en-us/kusto/query/parse-json-function?view=microsoft-fabric
Hope this helps!
Best regards!
Hello foks,
welcome to this community forum.
The text in the nested data field is not recognized as JSON so the UI cannot support it directly.
Getting to the separate fields is possible when you use the SQL operator. Using this low-code approach, you can 'program' to get to the values.
As Mauro89 mentioned, the alternative is just passing the Data field on as-is to an Eventhouse and using KQL to get to the separate fields. This can be done both using 'event processing before processing' (the table columns are created for you) and 'direct ingest' (an additional step is offered for mapping the message to a table format of your choice).
If this answer helps you, a thumbs-up or marking it as accepted answer is appreaciated.