Event Grid Topic: How to filter array values?

Question

Event Grid Topic: How to filter array values?

Leonid Andreev 21

I created a subscription for Event Grid Topic and want to filter events by Advanced Filter.

as we see in the documentation the key can be an array.

My event looks like with data.Data[] array:

So I want to figure out how can I filter events if data contains array values.

such filters don't work for me (I even try something like data.data.[].status, data.Data.status, data.data.[*].status and so on):

Is it really possible to filter events by array values?

Accepted answer

0 additional answers

Your answer

Answer 1

MayankBargali-MSFT 70,936 Moderator

@Leonid Andreev Thanks for reaching out. As of now Event Grid doesn't support filtering on an array of values today. If an incoming event has an array value for the advanced filter's key, the matching operation fails. The incoming event ends up not matching with the event subscription.

The same is documented here.

Leonid Andreev 21 Reputation points

2022-09-05T08:26:11.793+00:00

@MayankBargali-MSFT thanks! but then we need to fix the documentation because it's a bit tricky when I see that key can be an array :/
https://learn.microsoft.com/en-us/azure/event-grid/event-filtering#key
MayankBargali-MSFT 70,936 Reputation points Moderator

2022-09-06T05:58:14.313+00:00

@Leonid Andreev Thanks for your response and feedback. We only support filtering on arrays containing primitive values like String, Number, Boolean. Filtering on arrays containing another array or object is not supported (as in your case). In document it is called out of supporting array only for event data (like data.key1).

I will reach out to my content team to see if this needs more clarification in the document.
Leonid Andreev 21 Reputation points

2022-09-06T07:22:12.977+00:00

@MayankBargali-MSFT Many thanks for the clarification!
Roman Kiss 2,246 Reputation points

2022-09-06T15:11:48.74+00:00
Hi,

As mentioned it by @MayankBargali-MSFT , the advanced filtering supports very simply filtering on the single array key with a value type limitation such as the Text, Number and Boolean. The following is an example:

sample of the data object in the event message:

"data": { "make":"Ducati", "model":"Monster", "options":[ "ab", 123, true ] }

samples of the advanced filtering:

It will be nice, if the AEG team will implement something similar like we have for SQL query such as the ARRAY_CONTAINS where the value is an expression.

Thanks
Roman

Share via

Event Grid Topic: How to filter array values?

0 additional answers

Your answer