Unanswered

Error Uploading CSV

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Greetings,

I am taking the Dataverse course and I'm currently on the importing tables exercise. I have followed the steps exactly, but when I upload a csv, I get the following error:

"Record","Field","Error"

"82b0fad2-3fdd-42e8-8b35-e813a26597d9",

"POST https://org4d0d6c49.crm3.dynamics.com/api/data/v9.0/cr82f_pets {'cr82f_appointmentdate':'2021-06-04T00:00:00.000Z','cr82f_breed':'wolf','importsequencenumber':'0','cr82f_petid':null,'cr82f_petname':'bimbo','cr82f_species':'999999','statuscode':'0','statecode':'0','timezoneruleversionnumber':'0','utcconversiontimezonecode':'0','versionnumber':'','createdby.azureactivedirectoryobjectid':null,'createdonbehalfby.azureactivedirectoryobjectid':null,'createdby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','modifiedonbehalfby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','modifiedby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','ownerid@odata.bind':'/teams(32c0cdd0-abb9-eb11-8236-000d3ae93e7c)','modifiedonbehalfby.azureactivedirectoryobjectid':null,'createdonbehalfby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','modifiedby.azureactivedirectoryobjectid':null}",

"Reason: Bad Request, Header x-ms-client-request-id a0d54a05-8f32-4f11-a34c-15e57d8b7e99, Error code: 0x0, Message: An error occurred while validating input parameters: Microsoft.OData.ODataException: An unexpected instance annotation name 'createdby.azureactivedirectoryobjectid' was found when reading from the JSON reader, In OData, Instance annotation name must start with @. at Microsoft.OData.JsonLight.ReorderingJsonReader.ReadPropertyName(String& propertyName, String& annotationName) at Microsoft.OData.JsonLight.ReorderingJsonReader.ProcessObjectValue() at Microsoft.OData.Json.BufferingJsonReader.ReadNextAndCheckForInStreamError() at Microsoft.OData.Json.BufferingJsonReader.ReadInternal() at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStartImplementation(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload) at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStart(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload) at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementation() at Microsoft.OData.ODataReaderCore.ReadImplementation() at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action) at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader) at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext) at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)"

How can I understand what this error message means? Someone else is having the same problem.

Shane.

Categories:

Microsoft Dataverse with Power Apps

All responses (4)

Answers (0)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CShaneGoodman,

Are you possibly putting in an email address into the Created By field on the records you are uploading? This should be a name like "John Smith" and not an email address. Can you show an example of an input record from your CSV file?

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I uploaded the example to OneDrive .

I'm not specifying an email address. I put my own name ("Shane Goodman"). Then the error message was saying that I had to specify a GUID. However, if I put in a GUID, I got another error message saying:

"Record","Field","Error"

"32276a8c-eb65-4323-9720-00ec55e0fe8b",

"POST https://org4d0d6c49.crm3.dynamics.com/api/data/v9.0/cr82f_pets {'cr82f_appointmentdate':'2021-06-07T21:44:00.000Z','cr82f_breed':'newbreed','cr82f_petname':'growler','cr82f_species':'296030001','createdby.azureactivedirectoryobjectid':null,'modifiedonbehalfby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','modifiedby@odata.bind':'/systemusers(d964f43f-6186-44f5-847a-e89f21587652)','ownerid@odata.bind':'/teams(32c0cdd0-abb9-eb11-8236-000d3ae93e7c)','modifiedonbehalfby.azureactivedirectoryobjectid':null,'createdby@odata.bind':'/systemusers(23c7cdd0-abb9-eb11-8236-000d3ae93e7c)','modifiedby.azureactivedirectoryobjectid':null}",

"Reason: Bad Request, Header x-ms-client-request-id f7e84957-9d39-4ca2-ab6b-c556e0037b00, Error code: 0x0, Message: An error occurred while validating input parameters: Microsoft.OData.ODataException: An unexpected instance annotation name 'createdby.azureactivedirectoryobjectid' was found when reading from the JSON reader, In OData, Instance annotation name must start with @. at Microsoft.OData.JsonLight.ReorderingJsonReader.ReadPropertyName(String& propertyName, String& annotationName) at Microsoft.OData.JsonLight.ReorderingJsonReader.ProcessObjectValue() at Microsoft.OData.Json.BufferingJsonReader.ReadNextAndCheckForInStreamError() at Microsoft.OData.Json.BufferingJsonReader.ReadInternal() at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStartImplementation(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload) at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ReadPayloadStart(ODataPayloadKind payloadKind, PropertyAndAnnotationCollector propertyAndAnnotationCollector, Boolean isReadingNestedPayload, Boolean allowEmptyPayload) at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementation() at Microsoft.OData.ODataReaderCore.ReadImplementation() at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action) at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader) at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext) at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)"

I think this is saying that I have to begin the GUID of the user with an "@" sign. How do I do that?

Shane.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

0x0 is not in the list of error codes. What troubleshooting steps can I take? Is there another forum I could try?
greggpowell 137 on at

Like
a
(1)

Report
Copy link

Link copied!

Shane,
This appears to be a long standing systemic problem in Power Apps..... both with csv files, and excel tables.
I have a similar issue, and posted about it here: https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Excel-file-table-fails-to-import-into-Dataverse-adding-this-to/m-p/955766#M12029

I'll be curious what the solution is - if we get one (hopefully).

There is a work around - I found - by creating a table - manually adding every column name, and then going back in and manually mapping the column names to the data.... that explanation is too simplistic I know to help but.... I'm hoping someone cones and explains why this feature of power apps seems to be broken.

r/
Gregg