Dynamics Community Forum Thread Details

How to send OData EntityReference (Lookup) values from Json

Hello,

I'm implementing a code within a Logic App to send data to a custom Activity in Dynamics online v8.2 web services. Everything looks like works good, all the data is making it to the custom activity and executes a plugin, but the issue is that all the EntityReferences are null at the time that reading the values.

This is the Dynamics activity field definition:

6327.Capture2.JPG

this is the Logic App.

3122.Capture1.JPG

in the ODataV4Metadata from CRM the needed field is defined this way:

and the way I'm sending the values from Postman to the Logic app is a simple Json field with the GUID on it:

{

"crmLeadId": "74ec5085-XXXX-e811-812e-e0071b6aaXXX",

}

does anyone knows how to define these type of values from the Json or something that could give a light?

Thank you!

Hi Andrew,

yes I did it and still showing the same error:

"message": "An OData property annotation was found for a parameter payload; however, parameter payloads do not support OData property annotations.".

This is the complete Json message that I'm using, the GUID values are EntityReference fields, anyway, I'm evaluating the way to make the value visible in CRM with the plugin exception trace.

{
"address1City": "",
"address1Line1": "123 Main",
"address1Line2": "",
"address1PostalCode": "",
"address1StateOrProvince": "",
"billingAddressSameasInstall": true,
"campaignId": "FC3F7A95-D864-E811-8138-E0071B6AD111",
"desiredCallTime": "2018-06-19T16:35:05Z",
"email": "",
"firstName": "Jairo",
"futureInstallReason": "",
"installAddressCountry": "",
"installJobNumber": "",
"installStreetName": "",
"installStreetNumber": "",
"installUnitNumber": "",
"installationFeeId": "",
"isFirstParty": true,
"jornayaCampaignId": "E55426E4-6570-E611-80DC-FC15B4286CB8",
"lastName": "VR_LA0618_01",
"leadId@odata.bind": "/leads(74ec5085-fd73-e811-812e-e0071b6aa291)",
"leadIdData_result": 0,
"leadIdLabsData_result": 0,
"leadQualifierData_age": "20",
"leadQualifierData_ageRule": false,
"leadQualifierData_authentic": false,
"leadQualifierData_capture": false,
"leadQualifierData_captureRule": false,
"leadQualifierData_dataIntegrity": 0,
"leadQualifierData_dataIntegrityFailed": "[\"JAIRO\",\"VR_LA0618_01\",\"1020180618\"]",
"leadQualifierData_dataIntegrityPassed": "[]",
"leadQualifierData_dataIntegrityRule": false,
"leadQualifierData_deviceDay": 0,
"leadQualifierData_deviceDayRule": false,
"leadQualifierData_deviceFiveMinutes": 0,
"leadQualifierData_deviceFiveMinutesRule": false,
"leadQualifierData_deviceHour": 0,
"leadQualifierData_deviceHourRule": false,
"leadQualifierData_deviceTwelveHours": 0,
"leadQualifierData_deviceTwelveHoursRule": false,
"leadQualifierData_deviceWeek": 0,
"leadQualifierData_deviceWeekRule": false,
"leadQualifierData_duration": "07",
"leadQualifierData_durationRule": false,
"leadQualifierData_entityRule": false,
"leadQualifierData_entityValue": false,
"leadQualifierData_ipDay": 0,
"leadQualifierData_ipDayRule": false,
"leadQualifierData_ipFiveMinutes": 0,
"leadQualifierData_ipFiveMinutesRule": false,
"leadQualifierData_ipHour": 0,
"leadQualifierData_ipHourRule": false,
"leadQualifierData_ipTwelveHours": 0,
"leadQualifierData_ipTwelveHoursRule": false,
"leadQualifierData_ipWeek": 0,
"leadQualifierData_ipWeekRule": false,
"leadQualifierData_leadAge": "07",
"leadQualifierData_leadDay": 0,
"leadQualifierData_leadDayRule": false,
"leadQualifierData_leadDupe": false,
"leadQualifierData_leadDupeCheck": "00",
"leadQualifierData_leadDupeCheckRule": false,
"leadQualifierData_leadDupeRule": false,
"leadQualifierData_leadDupeTime": "0",
"leadQualifierData_leadDuration": 0,
"leadQualifierData_leadFiveMinutes": 0,
"leadQualifierData_leadFiveMinutesRule": false,
"leadQualifierData_leadHour": 0,
"leadQualifierData_leadHourRule": false,
"leadQualifierData_leadPlusDay": 0,
"leadQualifierData_leadPlusDayRule": false,
"leadQualifierData_leadPlusFiveMinutes": 0,
"leadQualifierData_leadPlusFiveMinutesRule": false,
"leadQualifierData_leadPlusHour": 0,
"leadQualifierData_leadPlusHourRule": false,
"leadQualifierData_leadPlusTimeFirstNotAvailable": 0,
"leadQualifierData_leadPlusTimeFirstNotAvailableRule": false,
"leadQualifierData_leadPlusTimeLastNotAvailable": 0,
"leadQualifierData_leadPlusTimeLastNotAvailableRule": false,
"leadQualifierData_leadPlusTwelveHours": 0,
"leadQualifierData_leadPlusTwelveHoursRule": false,
"leadQualifierData_leadPlusWeek": 0,
"leadQualifierData_leadPlusWeekRule": false,
"leadQualifierData_leadTwelveHours": 0,
"leadQualifierData_leadTwelveHoursRule": false,
"leadQualifierData_leadWeek": 0,
"leadQualifierData_leadWeekRule": false,
"leadQualifierData_regRule": false,
"leadQualifierData_result": 1,
"leadQualifierData_stored": false,
"leadQualifierData_storedRule": false,
"leadQualifierData_token": "45952EDD-B6D7-6278-6A5D-FBBD9ED2DB14",
"leadQualifierData_totalEntities": 0,
"leadQualifierData_totalEntitiesRule": false,
"leadQualifierData_totalHops": 0,
"leadQualifierData_totalHopsRule": false,
"leadQualifierData_urlRule": false,
"leadQualifierData_urlValue": false,
"leadQualifierId": "45952EDD-B6D7-6278-6A5D-FBBD9ED2DB14",
"primaryPhone": "1020180618",
"providerName": "AC",
"renterOwner": "N",
"secondaryPhone": "",
"spanishSpeaking": "No",
"transactionCurrencyId": "7F4CA223-B47B-E511-80DD-3863BB2E6B80"
}