I'm not that familiar with the terminology of JSON but I guess it's a combination of object and array, with a lot of "key/value" pairs included. You can simply reach out to your colleagues from the D365 F&O team and ask them for a sample of what they deliver as a "data change event" (I can provide you with a sample as well if there's any good way how to transfer it safely)... It's really quite complex and I would like to be safe for schema changes etc. so not working with indexes but more with "keys" to identify the values I would like to have from that JSON. I think it would be just great if you can use Fabric as a sink for events out of D365, the current sync mechanism you have with Data Lake have a latency of about 1h (at least currently). With events you would be able to bring that down to a minute or so. This would enable you to react on something going on in D365 in near real-time what is not possible with other data communications right now. This idea is also connected to the one where I ask for CUD support in Event Processing. If that would work you would be able to sync tables (entities to be precise) from D365 through events, nothing would be more real-time and open up use-cases with Data Activator etc. ...
Please allow to derive a value out of a complex JSON which is stored in a single field in your stream
