Is your feature request related to a problem? Please describe.
Could an extension be done around the handling of Messages which violate the requirements around the response on Message execution, currently the following error is thrown:
Messages must only have scalar type inputs and must produce either one or more scalar type outputs or a single Entity or EntityCollection output
Describe the solution you'd like
If a message violates the single Entity or EntityCollection output, id like a single Value returned with the Json from the response. For example:
declare @objectId uniqueidentifier
declare @componentType int = 1
select top(1) @objectId=metadataid from metadata.entity where logicalname='account'
select
*
FROM RetrieveDependenciesForDeleteWithMetadata(@componentType , @objectId)
Errors, but if we had the JSON output in a Value response column, we could then process the response as desired:
{
"@odata.context": "https://org99999999.crm11.dynamics.com/api/data/v9.0/$metadata#Microsoft.Dynamics.CRM.RetrieveDependenciesForDeleteWithMetadataResponse",
"DependencyMetadataCollection": {
"DependencyMetadataInfoCollection": [
{
"requiredcomponentobjectid": "70816501-edb9-4740-a16c-6a5efbc05d84",
"requiredcomponentdisplayname": "Account",
"requiredcomponenttype": 1,
"requiredcomponentname": "Account",
"requiredcomponenttypename": "Entity",
"requiredcomponentbasesolutionid": "fd140aad-4df4-11dd-bd17-0019b9312238",
"requiredcomponentbasesolutionname": "System Solution",
"requiredcomponentbasesolutionuniquename": "System",
"requiredcomponentbasesolutionversion": "5.0",
"requiredcomponentparentid": "00000000-0000-0000-0000-000000000000",
"requiredcomponentparentdisplayname": null,
"dependentcomponentobjectid": "5bfe9325-7f06-492c-9a6d-765615ab0561",
"dependentcomponentdisplayname": "Mscrm.HomepageGrid.account.MergeGroup",
"dependentcomponenttype": 10356,
"dependentcomponentname": "Mscrm.HomepageGrid.account.MergeGroup",
"dependentcomponenttypename": "App Action Rule",
"dependentcomponentbasesolutionid": "36576975-cb1f-4dab-9983-fa30b434f88a",
"dependentcomponentbasesolutionname": "System App Actions",
"dependentcomponentbasesolutionuniquename": "msdyn_SystemAppActions",
"dependentcomponentbasesolutionversion": "9.1.0.57",
"dependentcomponentparentid": "00000000-0000-0000-0000-000000000000",
"dependentcomponentparentdisplayname": null,
"dependencyid": "37ce1153-3f45-4f17-866d-ed6d8f344426",
"dependencytype": 2,
"dependencytypename": "Published",
"isdependencyremovalenabled": true,
"dependentcomponententitysetname": "appactionrules",
"dependentcomponententitylogicalname": "appactionrule",
"requiredcomponententitylogicalname": "entity"
},
// REMOVED
]
}
}
Is your feature request related to a problem? Please describe.
Could an extension be done around the handling of Messages which violate the requirements around the response on Message execution, currently the following error is thrown:
Messages must only have scalar type inputs and must produce either one or more scalar type outputs or a single Entity or EntityCollection outputDescribe the solution you'd like
If a message violates the single Entity or EntityCollection output, id like a single Value returned with the Json from the response. For example:
Errors, but if we had the JSON output in a Value response column, we could then process the response as desired:
{ "@odata.context": "https://org99999999.crm11.dynamics.com/api/data/v9.0/$metadata#Microsoft.Dynamics.CRM.RetrieveDependenciesForDeleteWithMetadataResponse", "DependencyMetadataCollection": { "DependencyMetadataInfoCollection": [ { "requiredcomponentobjectid": "70816501-edb9-4740-a16c-6a5efbc05d84", "requiredcomponentdisplayname": "Account", "requiredcomponenttype": 1, "requiredcomponentname": "Account", "requiredcomponenttypename": "Entity", "requiredcomponentbasesolutionid": "fd140aad-4df4-11dd-bd17-0019b9312238", "requiredcomponentbasesolutionname": "System Solution", "requiredcomponentbasesolutionuniquename": "System", "requiredcomponentbasesolutionversion": "5.0", "requiredcomponentparentid": "00000000-0000-0000-0000-000000000000", "requiredcomponentparentdisplayname": null, "dependentcomponentobjectid": "5bfe9325-7f06-492c-9a6d-765615ab0561", "dependentcomponentdisplayname": "Mscrm.HomepageGrid.account.MergeGroup", "dependentcomponenttype": 10356, "dependentcomponentname": "Mscrm.HomepageGrid.account.MergeGroup", "dependentcomponenttypename": "App Action Rule", "dependentcomponentbasesolutionid": "36576975-cb1f-4dab-9983-fa30b434f88a", "dependentcomponentbasesolutionname": "System App Actions", "dependentcomponentbasesolutionuniquename": "msdyn_SystemAppActions", "dependentcomponentbasesolutionversion": "9.1.0.57", "dependentcomponentparentid": "00000000-0000-0000-0000-000000000000", "dependentcomponentparentdisplayname": null, "dependencyid": "37ce1153-3f45-4f17-866d-ed6d8f344426", "dependencytype": 2, "dependencytypename": "Published", "isdependencyremovalenabled": true, "dependentcomponententitysetname": "appactionrules", "dependentcomponententitylogicalname": "appactionrule", "requiredcomponententitylogicalname": "entity" }, // REMOVED ] } }