How to access the array output from the parse JSON

How To
, , ,
3

Hello @amal,
Welcome to the community.

General output tricks

When you use Parse JSON it returns a collection or an array within a collection. It depends on what data input you give on Parse JSON. Try to wrap things and return a single bundle from Parse JSON
For example

[
    {"id":1, "name": "MyName1"},
    {"id":2, "name": "MyName2"},
    {"id":3, "name": "MyName3"}
]

This returns multiple(three) bundles on Parse JSON.
But if you try this,

[
   {
      "data":[
         {
            "id":1,
            "name": "MyName1"
         },
         {
            "id":2,
            "name": "MyName2"
         },
         {
            "id":3,
            "name": "MyName3"
         }
      ]
   }
]

This one always returns the single bundle and also your data array is wrapped within it.

It’s simple most of don’t know about it, When you give multiple collections(objects) to parse JSON it gives you output as multiple bundles.

Your Problem

Iterator always takes Array as input while your Parse JSON returns multiple bundles. https://www.make.com/en/help/modules/iterator

Because ParseJSON returns multiple bundles that’s why you don’t have the option to use that data directly to Iterator.

Solution

Check my above explanation for using Parse JSON if it fits your requirements then use it like that.
Otherwise, you need to use one extra step as Array Aggregator between Parse JSON and Iterator steps.

I hope this solves your issue and is also clear to you.

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution :white_check_mark: and :+1:
Need expert help or have questions? Contact or comment below! :point_down: