Unanswered

Error Uploading CSV

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (4)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
greggpowell 137 on at

Like (1)

Report

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

Was this reply helpful? Yes No