Iterator : quickbook

[Naomi_martins]

What is your goal?

i want to separate bundles from the iterator into operations so i can have access to the data directly. i am working with quickbooks invoice and there are more than 1 item and description. the quickbooks have 3 to 4 items per run. i need each item’s description and pricing so that i can map them in Google Sheets, as each row belongs to each invoice.

What is the problem & what have you tried?

i want to separate bundles from the iterator into operations so i can have access to the data directly. i am working woth quickbooks invoice adnthere are more than 1 item and description. the quickbooks have 3 to 4 items per run i started my automation with watching for new invoices; each invoice can have 3 to 4 items with different descriptions and pricing. the items did not split into different operations from the watch modules. To solve this i added an iterator and iterated the line array; it split the items into bundles based on the number of items. the problem now is that i need each bundle to occur as a different operation. i need each item’s description and pricing so that i can map them in Google Sheets, as each row belongs to each invoice, so each row has 4 description columns, but i dont have access to the descriptions separately so i can map the different descriptions into the single row in the sheets. Please help me!

Screenshots (scenario flow, module settings, errors)

[Stoyan_Vatov]

Hey Naomi,

you did get them in separate operations, that’s what Bundle 1 and Bundle 2 on top mean. Where are you trying to map them though? Is it all in the same module? Cause then you don’t need the iterator at all.

[samliew]

Welcome to the Make community!

You probably don’t need the Iterator, especially since you said:

@Naomi_martins

each row has 4 description columns

@Naomi_martins

map the different descriptions into the single row

You can use the built-in functions map and get to access variables within an array.

To do this, you can use the built-in function map —

{{ map(complex array; key; [key for filtering]; [possible values for filtering separated by a comma]) }}

and the built-in function get —

{{ get(object or array; path) }}

so you get something that looks like this —

{{ get(map(1.array; "description"); 1) }}
{{ get(map(1.array; "description"); 2) }}
{{ get(map(1.array; "description"); 3) }}
{{ get(map(1.array; "description"); 4) }}

etc.

For more information, the function’s documentation can be found in the Help Centre and the “Mapping with Arrays” link below. You should also complete the tutorials in the Make Academy, especially Using get() and map() functions.

I’d recommend going through the Make Academy if you haven’t yet!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks

Hope this helps! If you are still having trouble, please provide more details.

— @samliew