Showcase of Email with Table using Text parser to Get content of HTML Table and a text aggregator with group by to make the data more usable throughout the scenario

[Joseph_Accountant]

Hi @Bantlar

Happy to point you in the right direction. In general I think you need to learn a bit more about how arrays work and specifically how arrays in Make work.

A few options come to mind.

1. Get & Map Array functions. See this great post linked below for some more detail.

What are the most useful functions in Make and some examples of using them?

One of the most useful functions in Make is “mapping”. Mapping is used to get data from the output of one module and use the data in the input of another module. Mapping sometimes involves filtering collections and arrays using a combination of functions: the get() and map() functions. There is an excellent write up on this which is a must read for anyone who wants to use Make effectively. If you don’t want to read the article here’s a short preview: Imagine you have a bundle of data that look…

2. If that value will always be in the same place you can also hard code the array level in Make. See screenshot below as a small sample, here I am hardcoding the 3rd item in the array at the first level, then the 2nd item in the array on the 2nd level, and ultimately getting back the ‘descriptor’ field.
   

3. Use the Iterator module to iterate the various levels of the array, this is probably the most user friendly but the least efficient, but if you haven’t tried it before it may help conceptualize how the data is actually being stored (another way to do this is ‘download the output bundle’ and paste it in a code editor that can format JSON, you will understand the structure better and it will make working with the data in Make less frustrating).

I hope this helps get you on the right path, and it may feel discouraging to spend hours trying to get the answer, but you will learn a lot along the way and the next time you have a similar problem you will breeze right through it.