Accessing Double Nested Fields

[felipestarling]

Hello,

How do you access doubled nested fields? For example, how do you access the fields under object "Contacts" in the below screenshot?

I've tired using dot-notation, #each, @root, and #with but not luck. When the export is only set up to pull the "Contacts" fields, dot-notation works, however once I add in the "Account" level fields to the export the "Contacts" fields become double nested.

This is apart of a integration between Salesforce and BigQuery.

[felipestarling]

Btw...I'm trying to map fields in this example

[felipestarling]

Please ignore. I was able to figure it out. Thank you!

[courtneyjordan]

Hi @felipestarling!
You are fast! We'd love to know how you figured it out if you'd like to share? Thank you!

[felipestarling]

Hello Courtney,

Thanks! I was able to get #each to work. Below is an example of my code.

[courtneyjordan]

HI @felipestarling,

Thanks so much for sharing your solution!