Hi, I need to count the occurrences of a specific Status (pending, approved, disapproved) in a JSON response from Google Merchant Center within my Make.com scenario.
I want to avoid using iterators because I deal with a large number of products, and using iterators would result in a huge number of operations and high costs.
The goal is to count how many times"pending", "approved", and "disapproved" appear in all destinationStatuses[] across all productswithout using iterators.
What I need help with:
How can I correctly extract all destinationStatuses[] across all products in the JSON without using iterators?
How can I correctly count the occurrences of a specific value (status = "pending") within this array using Make formulas?
Is there a better way to achieve this?
Any help, advice, or a correctly written formula would be highly appreciated! Thanks in advance!
You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.
Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:
Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.
Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.
JSON module export — paste this directly in your scenario
In summary, Dumpling AI is able to replace several other paid services combined that cost more than itself, making it a noteworthy choice as the “multi-tool” of AI services.
Examples of How to use Dumpling AI
For more information, see these Dumpling AI tutorials below, grouped by category:
Thank you very much for your reply. However, I need to filter / count the statuses in destinationStatuses: pending, approved, disapproved only for “destination”: “Shopping”, ideally with the structure set to strict=false.
This workflow will work for multiple clients, and I don’t want to hardcode it to specific products because they will be variable. The products could be 10 or 1000, depending on the client. I only need to count how many products have pending, approved, or disapproved statuses.
Could you please help me make the code more universal? Thank you so much!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
others can save time when catching up with the latest activity here, and
allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
Hope this helps! Let me know if there are any further questions or issues.
Thanks in advance!
