Hello Makers,
I’m trying to process the data from an API . This data looks pretty the same than a Json structure I have successfully processed but the Array Aggregator’s Aggregated values show “Value” instead of expected list of items…
The process that works :
1.Get from Json a list of Bundles :
Output :
Bundle 1 collection with items (id, userid)
Bundle 2 collection with items (id, userid)
Bundle 3 collection with items (id, userid)
…
2.Array aggregator to group all bundles in tables grouped by userid :
Output :
Bundle 1 collection
array of collection [(id, userid), (id, userid), …) with samed userid
Bundle 2 collection
array of collection [(id, userid), (id, userid), …) with samed userid
…
The process that DOES Not work :
1.Get from API a table() :
Output :
Bundle 1 is a collection with a table of collection items (id, userid)
Use an Iterator to get a list of bundles :
a list of Bundles :
Output :
Bundle 1 collection with items (id, userid) + Bundle order position + Total number of bundles
Bundle 2 collection with items (id, userid) + Bundle order position + Total number of bundles
Bundle 3 collection with items (id, userid) + Bundle order position + Total number of bundles
…
So here I would say, that apart from having 2 new items in the bundles (+ Bundle order position + Total number of bundles), I would expect to be quite in line with the Step 2 of the working scenario… don’t you ?
BUT
When I add step 3 with an Array aggregator to group all bundles in tables grouped by userid :
I just can’t : Aggregated fields show me only 3 possibilities : VALUE + Bundle order position + Total number of bundles . I don’t find (id, userid)…
I have only one week of Make , so I may not understand something.
Do you see how to solve this issue ? it’s now 2 days… I’m on it…
Hello @SebastianMertens : Thank you for the hint :
I did 1) run 2) save 3) reload web page (F5 on Chrome) : same. The list of aggragated fields from the Iterator[63] is still [Total number of bundles], [Bundle order position] & [Value] not the list of fields of the items (id, location…)
I suspect that it is because : the items array is a collection of items that are sometime also a collection (thing). Can it be ?
I can not simplify the GraphQL API, but maybe I can create my own array flatten… removing the sub collections… But don’t know how to do ?
This is a volunteer community forum, not a helpdesk.
Please respect that while you are here. My initial instinct was to delete my response after “registering” this, I have left my original response below…
My Method of navigating aggregator quirks
I only use array aggregators in very specific circumstances.
Not exposing variables without certain scenario prerequisites is an intentional design decision, per the make/integromat documentation.
My catchall/universal aggregator is usually not the “basic Array Aggregator” but actually is the Text Aggregator or CSV Aggregator
I then use a combination of: / / / / encasing the "text/string variable" in the next module that needs to use the restructured data.
Hello JugaadiTech, thank you for the 2 parts of your message. I appreciate both. I understand the volunteer aspect. It’s true that getting stuck for days make me mad.
So your not deleted part is even more appreciated