CDS Error "0x8006088a"

[DaleJohnny]

Hi all,

I need to create a flow that (when condition true) copy the adress to another field.

Trigger

When a record is created, updatet or deleted

Conditions (CDS fields from D365)

new_syncaccountaddress = true

new_erpid = "A309943" (onyl for testings)

If condition true the flow should change follow fields in Dynamics 365 Sales.

Now I get the error below.

{
  "error": {
    "code": "0x8006088a",
    "message": "Bad Request - Error in query syntax."
  }
}

What do I have to adjust in the flow to make it work properly?

Thanks in advance and greetings from Switzerland

[abm]

Hi @DaleJohnny 

Which step you getting the error? Is that in your update record step? Check the field data types and corresponding value you trying to map.

[DaleJohnny]

Hi @abm 

I get the error in the last step (update record).
I've already checked the mapping and everything should be fine.
Only by the "item id" i'm not shure - do i need to write the record id from D365?

[abm]

Hi @DaleJohnny 

What data type is Item Id? Make sure your mapping value is also the same type.  If not try to use the int() expression to convert it.

Thanks

[DaleJohnny]

Hi @abm 

Thanks for your answer.

The Item ID is the GUID from Dynamics 365 sales.

I've put now the dynamic content for this Item-ID - that should be correct now.

But, now i receive the error below in the step "Update a record".

{
  "error": {
    "code": "0x0",
    "message": "An error occurred while validating input parameters: Microsoft.OData.ODataException: The 'odata.bind' instance or property annotation has a null value. In OData, the 'odata.bind' instance or property annotation must have a non-null string value.\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadAndValidateAnnotationStringValue(String annotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadAndValidateAnnotationStringValueAsUri(String annotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadEntryPropertyAnnotationValue(String propertyAnnotationName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadODataOrCustomInstanceAnnotationValue(String annotatedPropertyName, String annotationName, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ParseProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, String& parsedPropertyName)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ProcessProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, Action`2 handleProperty)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadResourceContent(IODataJsonLightReaderResourceState resourceState)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.StartReadingResource()\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadResourceSetItemStart(PropertyAndAnnotationCollector propertyAndAnnotationCollector, SelectedPropertiesNode selectedProperties)\r\n   at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementationSynchronously(PropertyAndAnnotationCollector propertyAndAnnotationCollector)\r\n   at Microsoft.OData.ODataReaderCore.ReadImplementation()\r\n   at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action)\r\n   at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader)\r\n   at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext)\r\n   at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)"
  }
}

[ManishJain]

Hi @DaleJohnny ,

Do you have look up value in the update record step. if yes then before setting that lookup value check for inputs coming from previous step whether it is null , accordingly do update.

Thanks

[DaleJohnny · Accepted solution]

Hi all,

I've found the solution for my issue.

If you need to update a lookup field, yout need to write the entity-name as a prefix and then the ( dynamic content )

Now everthing works 🙂

Thanks you all for the help!

[quetzal01]

@DaleJohnny could you please send a picture so I understand how you put the entity name as prefix and then the (dynamic content)? or explain with an example? Thank you so much!! 🙂

[DaleJohnny]

Hi @quetzal01 

Sure - MS changed the way a little bit.

Now you need to search with /plural entityname/dynamic content

I.e.

systemusers is the plural entity name and "Benutzer" the data, that i want from this entity.

Maybe you can archieve the same with the list records and an apply to each.

Hope it helps 🙂