You’re offline. This is a read only version of the page.
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.
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
0x0 is not in the list of error codes. What troubleshooting steps can I take? Is there another forum I could try?
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.
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
17
Super User 2025 Season 1
Share
Report
All responses (
Answers (
