Hi Makers,
I’m having an issue in the ‘Microsoft Advertising Reports’ > ‘Run a report’ module. The flow was working fine for downloading zip reports and extracting data until March 15. Now, it shows an error— and seens the zip file is missing, and it just returns ‘Status: Success’ without the file. Is this a Make issue?
Welcome to the Make community!
Did you forget to download the file using the file’s link/URL? If it’s not downloaded to the scenario, the next module can’t access the file binary data (contents).
To do this, you can use the HTTP “Get a File” module with the file URL that you need to download. Your file has to be publicly accessible on the internet (doesn’t require authentication).
For more information, see the HTTP page in the Make Help Centre, which covers the following:
If you have an Array of multiple file URLs, you can use an Iterator module, and map the resulting bundle value/URL to the “Get a file” module.
To download multiple files before proceeding to the next module, you can use an Array Aggregator.
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.
This is done using the “Target structure type” field in an Array Aggregator module.
Here is an example:
As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into.
Here is an example of how your scenario could look:
This is just an example. Your final solution may or may not look like this depending on your requirements and actual input data.
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.
