Cant figure out Nested Array

Hi guys, i have this issue where I’m using a make request module to scrape the box-office mojo page, I used the get content from HTML table to parse the output, and now I used the iterator module to get the data from the row array, and in it is an array containing an index item and a columns array, the data I need is in the column array, I’ve tried iterating through the columns array but it is not giving all the data instead it produced 7 different collection bundles with each column item in it, I’ve tried using the map functions and collection function also but I’m a bit confused and don’t know what to do.
the red line in the image shows the column I’m trying to iterate. I’ve attached the blueprint also. thanks


blueprint (2).json (37.0 KB)
blueprint (2).txt (37.0 KB)

2 Likes

Hi @emmanuel_bassey

You can use the index method to get all 7 values. Check the below link for more detail:
https://www.make.com/en/help/mapping/mapping-arrays#mapping-an-array-s-first-element

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!