How to extract a value from a list of nested records

[Anonymous]

Hello everyone,

I am currently struggeling with a column that contains a list of nested records.

I get it only done with a list of records but dont know how to do it with a list of nested records. I am almost trying to find a solution for about a few days...

The JSON structur looks likes this:

RED: List of Records

BLUE: first nested Record

GREEN: second nested Record

I want to extract the email address. I dont know why I dont get this running.

I hope somebody can help me out.

Thanks,

Fabz

EDIT:

I don't know what was wrong with me - but I have found the solution. Once again, the solution was quite simple.

each Text.Combine(List.Transform([Column1.node.subscriptions.edges], each Text.From(_[node][user][email])), ";")

[lbendlin · Accepted solution]

good that you found the solution - yes, it is standard JSON parsing.