How I would loop inside another

how I would loop inside another

         [
                {
                  "STORE_NAME": "Morumbi",
                  "STORE_ID": 1
                },
                {
                  "STORE_NAME": "Panamby",
                  "STORE_ID": 2
                },
                {
                  "STORE_NAME": "City Lapa",
                  "STORE_ID": 3
                },
                {
                  "STORE_NAME": "Granja Viana",
                  "STORE_ID": 6
                },
                {
                  "STORE_NAME": "Emporio SM",
                  "STORE_ID": 7
                },
                {
                  "STORE_NAME": "Alto de Pinheiros",
                  "STORE_ID": 9
                },
                {
                  "STORE_NAME": "Moema Jauaperi",
                  "STORE_ID": 12
                },
                {
                  "STORE_NAME": "Moema Pavao",
                  "STORE_ID": 13
                },
                {
                  "STORE_NAME": "Mooca",
                  "STORE_ID": 18
                },
                {
                  "STORE_NAME": "Higienopolis",
                  "STORE_ID": 20
                },
                {
                  "STORE_NAME": "São Caetano",
                  "STORE_ID": 22
                },
                {
                  "STORE_NAME": "Perdizes Cotoxo",
                  "STORE_ID": 23
                },
                {
                  "STORE_NAME": "Perdizes Sumare",
                  "STORE_ID": 24
                },
                {
                  "STORE_NAME": "Chacara Klabin",
                  "STORE_ID": 25
                },
                {
                  "STORE_NAME": "Itaim",
                  "STORE_ID": 27
                },
                {
                  "STORE_NAME": "Eataly",
                  "STORE_ID": 29
                },
                {
                  "STORE_NAME": "Chacara Flora",
                  "STORE_ID": 30
                },
                {
                  "STORE_NAME": "Alphaville",
                  "STORE_ID": 31
                },
                {
                  "STORE_NAME": "Portal do Morumbi",
                  "STORE_ID": 35
                },
                {
                  "STORE_NAME": "Brooklin",
                  "STORE_ID": 36
                },
                {
                  "STORE_NAME": "Villa Lobos",
                  "STORE_ID": 37
                },
                {
                  "STORE_NAME": "Eataly Dark kitchen 1",
                  "STORE_ID": 38
                }
              ]

I want to make a request for each item of this object

Send this message slack: {{$node[“Parse products”].json[“store_id”]}}

output slack:
Captura de tela 2021-05-11 100124

Hey @leosantosx!

Are you receiving a single item or multiple items? If you’re receiving a single item you can use the code snippet to transform it into multiple items: JavaScript Code Snippets | Docs

Once you have multiple items, n8n will send a message for each item.

{
  "nodes": [
    {
      "parameters": {
        "functionCode": "return ([\n{json:\n    {\n        \"STORE_NAME\": \"Morumbi\",\n        \"STORE_ID\": \"1\"\n    }\n},\n{json:{\n        \"STORE_NAME\": \"Panamby\",\n        \"STORE_ID\": \"2\"\n    }\n},\n{json:{\n        \"STORE_NAME\": \"City Lapa\",\n        \"STORE_ID\": \"3\"\n    }\n},\n{json:{\n        \"STORE_NAME\": \"Granja Viana\",\n        \"STORE_ID\": \"6\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Emporio SM\",\n    \"STORE_ID\": \"7\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Alto de Pinheiros\",\n    \"STORE_ID\": \"9\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Moema Jauaperi\",\n    \"STORE_ID\": \"12\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Moema Pavao\",\n    \"STORE_ID\": \"13\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Mooca\",\n    \"STORE_ID\": \"18\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Higienopolis\",\n    \"STORE_ID\": \"20\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"São Caetano\",\n    \"STORE_ID\": \"22\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Perdizes Cotoxo\",\n    \"STORE_ID\": \"23\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Perdizes Sumare\",\n    \"STORE_ID\": \"24\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Chacara Klabin\",\n    \"STORE_ID\": \"25\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Itaim\",\n    \"STORE_ID\": \"27\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Eataly\",\n    \"STORE_ID\": \"29\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Chacara Flora\",\n    \"STORE_ID\": \"30\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Alphaville\",\n    \"STORE_ID\": \"31\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Portal do Morumbi\",\n    \"STORE_ID\": \"35\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Brooklin\",\n    \"STORE_ID\": \"36\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Villa Lobos\",\n    \"STORE_ID\": \"37\"\n    }\n},\n{json:{\n    \"STORE_NAME\": \"Eataly Dark kitchen 1\",\n    \"STORE_ID\": \"38\"\n    }\n}\n])\n"
      },
      "name": "Set stores",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        -2680,
        1053
      ]
    },
    {
      "parameters": {
        "requestMethod": "POST",
        "url": "=https://redash.name.com.br/api/queries/QUERY_ID/results",
        "jsonParameters": true,
        "options": {},
        "bodyParametersJson": "={\n\t\"parameters\": {\n\t\t\"RESULT_TYPE\": 1,\n\t\t\"STORE_ID\": \"{{$node[\"Set stores\"].json[\"STORE_ID\"]}}\"\n\t}\n}",
        "headerParametersJson": "={\n\"Authorization\": \"Key {{$node[\"Set key redash\"].json[\"key\"]}}\",\n\"Content-Type\": \"application/json\"\n}"
      },
      "name": "Get products",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 1,
      "position": [
        -2410,
        1053
      ],
      "retryOnFail": true,
      "maxTries": 4,
      "waitBetweenTries": 5000,
      "continueOnFail": true
    },
    {
      "parameters": {
        "conditions": {
          "string": [
            {
              "value1": "={{Object.keys($node[\"Get products\"].json[\"query_result\"].data)}}",
              "operation": "contains",
              "value2": "rows"
            }
          ]
        }
      },
      "name": "Request is ok",
      "type": "n8n-nodes-base.if",
      "typeVersion": 1,
      "position": [
        -2120,
        1053
      ],
      "alwaysOutputData": false,
      "retryOnFail": true,
      "waitBetweenTries": 5000,
      "maxTries": 4
    },
    {
      "parameters": {
        "functionCode": "const products = []\n\nfor (let data of items[0].json.query_result.data.rows) {\n    products.push({\n        json: {\n    \t\tstore_id: data.store_id\n      \t}\n    })\n}\n\nreturn products;\n"
      },
      "name": "Parse products",
      "type": "n8n-nodes-base.function",
      "typeVersion": 1,
      "position": [
        -1830,
        1053
      ]
    }
  ],
  "connections": {
    "Set stores": {
      "main": [
        [
          {
            "node": "Get products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get products": {
      "main": [
        [
          {
            "node": "Request is ok",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Request is ok": {
      "main": [
        [
          {
            "node": "Parse products",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

I want to place an request for each item of the object and pick up the products, but only be able to place only the first request

Your HTTP Request node will make a request for all the items that you pass from the previous node. While selecting the item from the Expression Editor you might only see the first output, but the node makes a request for all the items. Can you please share the output of the HTTP Request node? If you can share the credentials via personal message, it will help me replicate myself.