Issue with ForEach Loop bringing in Body Value of previous Parse JSON Step

Mayhew Wilroy 0 Reputation points
2024-06-21T18:06:40.28+00:00

I have been working on a Logic App mostly created with the help of a couple YouTube videos to send notifications when a Client Secret for a Registered Application is expiring. This is the general structure, Recurrence, initialize variables, Get Token for authentication to enterprise apps with rights to all applications, parse token, then a get application call for all applications, then the last parse which pulls the Body from the previous Get Applications call, the app runs successfully and does pull the application data.

User's image

The issue I am having is when I add a ForEach loop at the end, I want to pull the Body Value from the ParseJSON 1, but only option is "Body Required", so it seems like its indicating there is no body in the previous JSON but there is, you can also see the output below from the ParseJSON

User's image

User's image

I wondering if there is an issue with the sample payload I used to generate a schema. Although there was no error thrown when I used it and in the videos I was following this seemed to be the exact payload used.

"type": "object",

        "properties": {

          "value": {

            "type": "array",

            "items": {

              "type": "object",

              "properties": {

                "id": {

                  "type": "string"

                },

                "appId": {

                  "type": "string"

                },

                "displayName": {

                  "type": "string"

                },

                "passwordCredentials": {

                  "type": "array",

                  "items": {

                    "type": "object",

                    "properties": {

                      "customKeyIdentifier": {},

                      "displayName": {

                        "type": "string"

                      },

                      "endDateTime": {

                        "type": "string"

                      },

                      "hint": {

                        "type": "string"

                      },

                      "keyId": {

                        "type": "string"

                      },

                      "secretText": {},

                      "startDateTime": {

                        "type": "string"

                      }

                    },

                    "required": [

                      "customKeyIdentifier",

                      "displayName",

                      "endDateTime",

                      "hint",

                      "keyId",

                      "secretText",

                      "startDateTime"

                    ]

                  }

                }

              },

              "required": [

                "id",

                "appId",

                "displayName",

                "passwordCredentials"

              ]

            }

          }

        }

      }

Any ideas would be helpful. This is the first logic app i've created so I am definitely not an expert.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,966 questions
0 comments No comments
{count} votes