Help with nested Array / Collection problem

Hey team, I am working with a nested collection / array situation.

In the screenshot attached, you see the output of my iterator ( I have ~80 of these bundles).

I want to extract key ($overall), the date that’s nested in Value (2024-07-22…), and the integer value (881) nested in the Value and write it to a row of a google sheet.

Can anyone point me in the right direction? Would be very helpful.

Welcome to the Make community!

Can you provide the output bundle that generates this array? (BEFORE the iterator module)

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading them here will look like this:

module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

samliewrequest private consultation

Join the Make Fans Discord server to chat with other makers!

I’d love to but this is personal data

As sharing sensitive information about your situation might not be suitable for an open forum discussion,

For complex technical issues or bugs like this, directly contacting support can often lead to a faster resolution. They have access to your specific account details, scenario and scenario logs, server-side logs, and internal tools and resources, which allows them to investigate more thoroughly than what you have access to. Additionally, sharing sensitive information about your situation might not be suitable for an open forum discussion.

If you manage to get your issue resolved with support, we’d still love to hear about it! Sharing your solution on the forum can help others facing similar problems.

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

Hi @Lennart

We could see that you have already executed the Iterator module. This means you are just one step away.

You can simply map those variables in Google sheet (Add a Row Module)

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!