Unanswered

Problem "Get Data" in CDS 2.0 not working

(1) Share

Report

Posted on by Yahya Manasrah

515

I try Get Data for a basic custom entity with 4 text columns, the wizard works perfectly until the start of importing then i get this error: -

Any idea?

Load to Common Data Service failed. Details: An error occurred while validating input parameters: Microsoft.OData.ODataException: Does not support untyped value in non-open type.
at System.Web.OData.Formatter.Deserialization.DeserializationHelpers.ApplyProperty(ODataProperty property, IEdmStructuredTypeReference resourceType, Object resource, ODataDeserializerProvider deserializerProvider, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.ApplyStructuralProperties(Object resource, ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at Microsoft.Crm.Extensibility.OData.CrmODataEntityDeserializer.ApplyStructuralProperties(Object resource, ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.ReadResource(ODataResourceWrapper resourceWrapper, IEdmStructuredTypeReference structuredType, ODataDeserializerContext readContext)
at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger). (Job ID: 2c206076-6994-4546-8d1e-a1d22ad86672)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

CWesener on at

Like (0)

Report

Adding @millopis from the Power Query team.

Was this reply helpful? Yes No
Yahya Manasrah 515 on at

Like (1)

Report

Hi @CWesener and @millopis, and that's for always being available.

I found a resolution that I would like to share, although I don't think this error should exist but here is the reason and how to eliminate.

The reason of this error is that if I create an entity and name as COUNTRY, Name of the primary field cannot be also called COUNTRY. Simple.

If I call the primary field anything else, such as COUNTRY NAME, then power query works perfectly.

Thanks.

Was this reply helpful? Yes No
AngeloMollame on at

Like (0)

Report

Hello Yahya.

Thanks for reporting this. We will introduce an additional validation rule that indicates that it's not possible to create an entity if it has a field with the same name as the entity itself.

Thanks

Angelo

Was this reply helpful? Yes No
Apostolis Microsoft Employee on at

Like (0)

Report

Confirmed issue & fix works, thanks Yahya

Was this reply helpful? Yes No
Smitha10 5 on at

Like (1)

Report

I am getting the same error with a different Primary name vs the entity name. I am training in powerapps and an admitted newbie but I have followed the instructions but I am unable to imort my data.

DataError1.png

Error1.png

Entity error1.png

Was this reply helpful? Yes No
Kyle M Garrett 7 on at

Like (0)

Report

I have the exact same issue.
I am also training and taking the same course via EDX.org.

Was this reply helpful? Yes No
dazhang on at

Like (0)

Report

@KyleGarrettand @Smitha10: sorry for the late reply. Would you mind starting a new thread for this issue, as it's unrelated to the issue that the current thread was created for?

Was this reply helpful? Yes No