LogicAppsUX icon indicating copy to clipboard operation
LogicAppsUX copied to clipboard

Parse JSON action is not providing found fields in the dropdown list

Open mattyjbennett opened this issue 1 year ago • 0 comments

Describe the Bug with repro steps

  1. Under the Parse JSON action (with the correct schema attached to it)
  2. Create a Compose action.
  3. In the Inputs box, insert dynamics content.
  4. From the list, select the Parse JSON section
  5. Only the Body is present in the list.

What type of Logic App Is this happening in?

Consumption (Portal)

Are you using new designer or old designer

New Designer

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

relevant sections only:

 "Compose_1": {
                "inputs": "a",
                "runAfter": {
                    "Parse_CDM_record": [
                        "SUCCEEDED"
                    ]
                },
                "type": "Compose"
            },

 "Parse_CDM_record": {
                "inputs": {
                    "content": "@triggerBody()",
                    "schema": {
                        "Applicant": {
                            "properties": {
                                "FeeStatus": {
                                    "type": "string"
                                },
                                "LatestDecisionDate": {
                                    "type": "string"
                                },
                                "LatestDecisionStatus": {
                                    "type": "string"
                                },
                                "Module": {
                                    "items": {
                                        "properties": {
                                            "CampusCode": {
                                                "type": "string"
                                            },
                                            "ModuleCode": {
                                                "type": "string"
                                            },
                                            "ProgrammeCode": {
                                                "type": "string"
                                            },
                                            "StudentModuleRegistrationStatusCode": {
                                                "type": "string"
                                            },
                                            "TermCode": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "ModuleCode",
                                            "ProgrammeCode",
                                            "TermCode"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "Programme": {
                                    "items": {
                                        "properties": {
                                            "AdmissionYear": {
                                                "type": "string"
                                            },
                                            "AttendanceMode": {
                                                "type": "string"
                                            },
                                            "CampusCode": {
                                                "type": "string"
                                            },
                                            "MajorCode": {
                                                "type": "string"
                                            },
                                            "ProgrammeCode": {
                                                "type": "string"
                                            },
                                            "ProgrammeYear": {
                                                "type": "string"
                                            },
                                            "StartDate": {
                                                "type": "string"
                                            },
                                            "StudyModeCode": {
                                                "type": "string"
                                            },
                                            "TermCode": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "ProgrammeCode",
                                            "StudyModeCode",
                                            "AdmissionYear",
                                            "StartDate"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "UCASPersonalId": {
                                    "type": "string"
                                },
                                "UCASUbmissionDate": {
                                    "type": "string"
                                }
                            },
                            "required": [
                                "Programme"
                            ],
                            "type": "object"
                        },
                        "ApplicationDetail": {
                            "properties": {
                                "ApplicationId": {
                                    "type": "string"
                                },
                                "ApplicationURL": {
                                    "type": "string"
                                },
                                "DateModified": {
                                    "type": "string"
                                },
                                "DateSubmitted": {
                                    "type": "string"
                                },
                                "InterviewPreferences": {
                                    "type": "string"
                                },
                                "PersonalStatement": {
                                    "type": "string"
                                }
                            },
                            "required": [
                                "ApplicationId",
                                "ApplicationURL",
                                "DateModified",
                                "DateSubmitted",
                                "PersonalStatement",
                                "InterviewPreferences"
                            ],
                            "type": "object"
                        },
                        "OfferAndDecision": {
                            "items": [
                                {
                                    "properties": {
                                        "Accept": {
                                            "type": "boolean"
                                        },
                                        "ConditionalAccept": {
                                            "type": "boolean"
                                        },
                                        "ConditionalOffer": {
                                            "type": "boolean"
                                        },
                                        "DecisionReason": {
                                            "type": "string"
                                        },
                                        "DecisionStatus": {
                                            "type": "integer"
                                        },
                                        "Decline": {
                                            "type": "boolean"
                                        },
                                        "Deferred": {
                                            "type": "boolean"
                                        },
                                        "InviteToInterview": {
                                            "type": "boolean"
                                        },
                                        "OfferText": {
                                            "type": "string"
                                        },
                                        "OtherDecisionReason": {
                                            "type": "string"
                                        },
                                        "Withdrawn": {
                                            "type": "boolean"
                                        }
                                    },
                                    "required": [
                                        "DecisionStatus",
                                        "DecisionReason",
                                        "OtherDecisionReason",
                                        "ConditionalOffer",
                                        "OfferText",
                                        "ConditionalAccept",
                                        "Decline",
                                        "Withdrawn",
                                        "InviteToInterview",
                                        "Accept",
                                        "Deferred"
                                    ],
                                    "type": "object"
                                }
                            ],
                            "type": "array"
                        },
                        "Person": {
                            "properties": {
                                "Initials": {
                                    "type": "string"
                                },
                                "InternalStaffId": {
                                    "type": "string"
                                },
                                "LastName": {
                                    "type": "string"
                                },
                                "PersonCode": {
                                    "type": "string"
                                },
                                "PreferredName": {
                                    "type": "string"
                                },
                                "Title": {
                                    "type": "string"
                                },
                                "UoB_EmailAddress": {
                                    "type": "string"
                                },
                                "UoB_Username": {
                                    "type": "string"
                                }
                            },
                            "required": [
                                "PersonCode",
                                "UoB_EmailAddress",
                                "UoB_Username",
                                "Title",
                                "LastName",
                                "PreferredName",
                                "Initials",
                                "InternalStaffId"
                            ],
                            "type": "object"
                        },
                        "PersonalData": {
                            "properties": {
                                "DateOfBirth": {
                                    "type": "string"
                                },
                                "EmergencyContact": {
                                    "items": {
                                        "properties": {
                                            "ContactFirstName": {
                                                "type": "string"
                                            },
                                            "ContactSurname": {
                                                "type": "string"
                                            },
                                            "ContactTitle": {
                                                "type": "string"
                                            },
                                            "EmergencyContactAddress": {
                                                "properties": {
                                                    "AddressLine1": {
                                                        "type": "string"
                                                    },
                                                    "AddressLine2": {
                                                        "type": "string"
                                                    },
                                                    "AddressLine3": {
                                                        "type": "string"
                                                    },
                                                    "AddressNation": {
                                                        "type": "string"
                                                    },
                                                    "AddressTypeCode": {
                                                        "type": "string"
                                                    },
                                                    "AddressTypeDescription": {
                                                        "type": "string"
                                                    },
                                                    "City": {
                                                        "type": "string"
                                                    },
                                                    "PostCode": {
                                                        "type": "string"
                                                    },
                                                    "ValidFromDate": {
                                                        "type": "string"
                                                    },
                                                    "ValidToDate": {
                                                        "type": "string"
                                                    }
                                                },
                                                "required": [
                                                    "ValidFromDate",
                                                    "ValidToDate",
                                                    "AddressTypeDescription",
                                                    "AddressTypeCode",
                                                    "AddressLine1",
                                                    "AddressLine2",
                                                    "AddressLine3",
                                                    "City",
                                                    "PostCode",
                                                    "AddressNation"
                                                ],
                                                "type": "object"
                                            },
                                            "EmergencyContactPhoneNumbers": {
                                                "items": {
                                                    "properties": {
                                                        "PhoneNumber": {
                                                            "type": "string"
                                                        },
                                                        "PhoneNumberTypeCode": {
                                                            "type": "string"
                                                        },
                                                        "PhoneNumberTypeDescription": {
                                                            "type": "string"
                                                        }
                                                    },
                                                    "required": [
                                                        "PhoneNumberTypeDescription",
                                                        "PhoneNumberTypeCode",
                                                        "PhoneNumber"
                                                    ],
                                                    "type": "object"
                                                },
                                                "type": "array"
                                            },
                                            "Priority": {
                                                "type": "string"
                                            },
                                            "Relationship": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "Priority",
                                            "Relationship",
                                            "ContactTitle",
                                            "ContactFirstName",
                                            "ContactSurname",
                                            "EmergencyContactAddress"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "Forename": {
                                    "type": "string"
                                },
                                "MiddleNames": {
                                    "type": "string"
                                },
                                "NameSuffix": {
                                    "type": "string"
                                },
                                "NationalInsuranceNumber": {
                                    "type": "string"
                                },
                                "PersonAddresses": {
                                    "items": {
                                        "properties": {
                                            "AddressLine1": {
                                                "type": "string"
                                            },
                                            "AddressLine2": {
                                                "type": "string"
                                            },
                                            "AddressLine3": {
                                                "type": "string"
                                            },
                                            "AddressNation": {
                                                "type": "string"
                                            },
                                            "AddressTypeCode": {
                                                "type": "string"
                                            },
                                            "AddressTypeDescription": {
                                                "type": "string"
                                            },
                                            "City": {
                                                "type": "string"
                                            },
                                            "PostCode": {
                                                "type": "string"
                                            },
                                            "ValidFromDate": {
                                                "type": "string"
                                            },
                                            "ValidToDate": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "ValidFromDate",
                                            "ValidToDate",
                                            "AddressTypeDescription",
                                            "AddressTypeCode",
                                            "AddressLine1",
                                            "AddressLine2",
                                            "AddressLine3",
                                            "City",
                                            "PostCode",
                                            "AddressNation"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "PersonEmails": {
                                    "items": {
                                        "properties": {
                                            "EmailAddress": {
                                                "type": "string"
                                            },
                                            "EmailTypeCode": {
                                                "type": "string"
                                            },
                                            "EmailTypeDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "EmailTypeDescription",
                                            "EmailTypeCode",
                                            "EmailAddress"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "PersonPhoneNumbers": {
                                    "items": {
                                        "properties": {
                                            "PhoneNumber": {
                                                "type": "string"
                                            },
                                            "PhoneNumberTypeCode": {
                                                "type": "string"
                                            },
                                            "PhoneNumberTypeDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "PhoneNumberTypeDescription",
                                            "PhoneNumberTypeCode",
                                            "PhoneNumber"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                }
                            },
                            "required": [
                                "DateOfBirth",
                                "Forename",
                                "MiddleNames",
                                "NationalInsuranceNumber",
                                "NameSuffix",
                                "PersonEmails",
                                "PersonPhoneNumbers",
                                "PersonAddresses"
                            ],
                            "type": "object"
                        },
                        "Qualification": {
                            "items": [
                                {
                                    "properties": {
                                        "AcademicSubject": {
                                            "type": "string"
                                        },
                                        "AwardDate": {
                                            "type": "string"
                                        },
                                        "CurrentlyCompleting": {
                                            "type": "string"
                                        },
                                        "EnglishLanguageQualifications": {
                                            "type": "string"
                                        },
                                        "Grade": {
                                            "type": "string"
                                        },
                                        "Institution": {
                                            "type": "string"
                                        },
                                        "MissingReason": {
                                            "type": "string"
                                        },
                                        "Non-UKQualificationType": {
                                            "type": "string"
                                        },
                                        "OtherLanguageQualifications": {
                                            "type": "string"
                                        },
                                        "OtherUKQualificationType": {
                                            "type": "string"
                                        },
                                        "QualificationEquivalency": {
                                            "type": "string"
                                        },
                                        "QualificationType": {
                                            "type": "string"
                                        },
                                        "StartDate": {
                                            "type": "string"
                                        }
                                    },
                                    "required": [
                                        "QualificationType",
                                        "AcademicSubject",
                                        "Grade",
                                        "StartDate",
                                        "AwardDate",
                                        "Institution",
                                        "QualificationEquivalency"
                                    ],
                                    "type": "object"
                                }
                            ],
                            "type": "array"
                        },
                        "SensitiveData": {
                            "properties": {
                                "AccessibilityRequirement": {
                                    "items": {
                                        "properties": {
                                            "AccessibilityRequirementCode": {
                                                "type": "string"
                                            },
                                            "AccessibilityRequirementDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "AccessibilityRequirementDescription",
                                            "AccessibilityRequirementCode"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "Disability": {
                                    "items": {
                                        "properties": {
                                            "DisabilityCode": {
                                                "type": "string"
                                            },
                                            "DisabilityDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "DisabilityDescription",
                                            "DisabilityCode"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "EthnicityCode": {
                                    "type": "string"
                                },
                                "EthnicityDescription": {
                                    "type": "string"
                                },
                                "ExamSpecialRequirement": {
                                    "items": {
                                        "properties": {
                                            "ExamSpecialRequirementCode": {
                                                "type": "string"
                                            },
                                            "ExamSpecialRequirementDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "ExamSpecialRequirementDescription",
                                            "ExamSpecialRequirementCode"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "GenderIdentityCode": {
                                    "type": "string"
                                },
                                "GenderIdentityDescription": {
                                    "type": "string"
                                },
                                "MaritalStatusCode": {
                                    "type": "string"
                                },
                                "MaritalStatusDescription": {
                                    "type": "string"
                                },
                                "Nationality": {
                                    "items": {
                                        "properties": {
                                            "NationalityCode": {
                                                "type": "string"
                                            },
                                            "NationalityDescription": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "NationalityDescription",
                                            "NationalityCode"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                },
                                "References": {
                                    "items": [
                                        {
                                            "properties": {
                                                "DateCreated": {
                                                    "type": "string"
                                                },
                                                "Forename": {
                                                    "type": "string"
                                                },
                                                "Institution": {
                                                    "type": "string"
                                                },
                                                "Position": {
                                                    "type": "string"
                                                },
                                                "RefereeEmail": {
                                                    "type": "string"
                                                },
                                                "RefereeName": {
                                                    "type": "string"
                                                },
                                                "RefereeRole": {
                                                    "type": "string"
                                                },
                                                "ReferenceText": {
                                                    "type": "string"
                                                },
                                                "SafeguardingConcerns": {
                                                    "type": "boolean"
                                                },
                                                "Surname": {
                                                    "type": "string"
                                                },
                                                "Title": {
                                                    "type": "string"
                                                },
                                                "referenceType": {
                                                    "type": "string"
                                                }
                                            },
                                            "required": [
                                                "RefereeName",
                                                "Title",
                                                "Forename",
                                                "Surname",
                                                "RefereeEmail",
                                                "RefereeRole",
                                                "ReferenceText",
                                                "referenceType",
                                                "SafeguardingConcerns",
                                                "DateCreated",
                                                "Position",
                                                "Institution"
                                            ],
                                            "type": "object"
                                        }
                                    ],
                                    "type": "array"
                                },
                                "ReligionCode": {
                                    "type": "string"
                                },
                                "ReligionDescription": {
                                    "type": "string"
                                },
                                "SexCode": {
                                    "type": "string"
                                },
                                "SexDescription": {
                                    "type": "string"
                                },
                                "SexualOrientationCode": {
                                    "type": "string"
                                },
                                "SexualOrientationDescription": {
                                    "type": "string"
                                },
                                "StudentHold": {
                                    "items": {
                                        "properties": {
                                            "HoldCode": {
                                                "type": "string"
                                            },
                                            "HoldReason": {
                                                "type": "string"
                                            },
                                            "HoldType": {
                                                "type": "string"
                                            }
                                        },
                                        "required": [
                                            "HoldCode",
                                            "HoldType",
                                            "HoldReason"
                                        ],
                                        "type": "object"
                                    },
                                    "type": "array"
                                }
                            },
                            "required": [
                                "SexDescription",
                                "SexCode",
                                "GenderIdentityDescription",
                                "GenderIdentityCode",
                                "SexualOrientationDescription",
                                "SexualOrientationCode",
                                "EthnicityDescription",
                                "EthnicityCode",
                                "ReligionDescription",
                                "ReligionCode",
                                "MaritalStatusDescription",
                                "MaritalStatusCode"
                            ],
                            "type": "object"
                        },
                        "WorkExperience": {
                            "items": [
                                {
                                    "properties": {
                                        "EmployerName": {
                                            "type": "string"
                                        },
                                        "EndDate": {
                                            "type": [
                                                "string",
                                                "null"
                                            ]
                                        },
                                        "JobDescription": {
                                            "type": "string"
                                        },
                                        "JobTitle": {
                                            "type": "string"
                                        },
                                        "Mode": {
                                            "type": "string"
                                        },
                                        "OwnerId": {
                                            "type": "string"
                                        },
                                        "RelevantToStudy": {
                                            "type": "boolean"
                                        },
                                        "StartDate": {
                                            "type": "string"
                                        },
                                        "StatusCode": {
                                            "type": "string"
                                        },
                                        "WorkExperienceType": {
                                            "type": "string"
                                        },
                                        "WorkHistoryBreak": {
                                            "type": "string"
                                        }
                                    },
                                    "required": [
                                        "EmployerName",
                                        "JobTitle",
                                        "JobDescription",
                                        "Mode",
                                        "StartDate",
                                        "EndDate",
                                        "RelevantToStudy",
                                        "WorkHistoryBreak",
                                        "WorkExperienceType",
                                        "StatusCode",
                                        "OwnerId"
                                    ],
                                    "type": "object"
                                }
                            ],
                            "type": "array"
                        }
                    }
                },
                "runAfter": {
                    "Initialize_Disability_Code": [
                        "SUCCEEDED"
                    ],
                    "Initialize_Job_Description_Text": [
                        "SUCCEEDED"
                    ],
                    "Initialize_Work_History_Break_Length": [
                        "SUCCEEDED"
                    ],
                    "Initialize_Work_History_Break_Text": [
                        "SUCCEEDED"
                    ]
                },
                "type": "ParseJson"
            },

Screenshots or Videos

No response

Browser

Chrome

Additional context

Refer to Parse JSON and Compose_1 actions.

mattyjbennett avatar Jun 25 '24 09:06 mattyjbennett