topic Re: Eventstream and Azure Event Grid - how to get record/array instead of in Eventstream

Eventstream and Azure Event Grid - how to get record/array instead of

foks — Thu, 27 Nov 2025 10:03:02 GMT

Hello,

I created an evenstream (enhanced) and connected to Azure Event Grid.

My JSON payload looks like this:

Schema:

I managed to parse string into json record

But now I would like to get separate columns based on that payload

I expected to see a dropdown list with columns to select. But unfortunately it doesn't work. How I can handle this?

Re: Eventstream and Azure Event Grid - how to get record/array instead of

Mauro89 — Sun, 30 Nov 2025 18:44:56 GMT

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!

Re: Eventstream and Azure Event Grid - how to get record/array instead of

svelde — Sun, 07 Dec 2025 18:21:37 GMT

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.

Re: Eventstream and Azure Event Grid - how to get record/array instead of

v-sshirivolu — Mon, 12 Jan 2026 06:43:59 GMT

Hi foks ,
I would take a moment to thank svelde , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

Re: Eventstream and Azure Event Grid - how to get record/array instead of

v-sshirivolu — Fri, 16 Jan 2026 07:35:26 GMT

Hi foks ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.