How can I access all data in a data store in one module?

How To
1

I am sending opportunity information throughout the week from my CRM with the goal of creating a consolidated report using GPT. After the report is made for the week the data-store will be reset for the next week. When it is time to trigger the report, I want to pull all of the information in the data store into one GPT module to create the weekly report. I tried uploading my current blueprint, hopefully that helps. Currently, I am only able to access one row from the data store at a time, and I have not found a good way to consolidate the information.

Thanks in advance for your help!

blueprint (3).json (35.5 KB)

2

Welcome to the Make community!

Expand the advanced settings in the “Search Records” module, and enter a higher limit like 3400.

Screenshot_2024-10-23_220854
Screenshot_2024-10-23_220854779×515 63.5 KB

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Thank you for your response! I made that change and also added a router to try testing with and without the iterator but both routes had the same output, where 16 separate operations were executed instead of putting all the data in one operation

image
image1458×416 84.5 KB

4

You should point the “Source Module” of the aggregator to where the bundles are being generated, which is usually an Iterator module.

For more information, see the Make Academy.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.