Hi All,
We are looking to use Dataverse Web API to upsert external data into Dataverse and through our research we found that if the external key field is string type, the upsert fails. Has anyone in the community encountered the same issue?
* PATCH {DataverseWebAPI}/api/data/v9.2/new_table1(new_external_id_string=ABC12345)
-> This will throw an exception.
* PATCH {DataverseWebAPI}/api/data/v9.2/new_table1(new_external_id_integer=12345)
-> This will succesfully upsert the record.
There is no mention in the documentation that external key with string type will fail (https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/update-delete-entities-using-web-api)
We ended up creating an integer external key field in a Dataverse table and also changing the external key format on external data to be integer type. This is very cumbersome as we are looking to integrate our old system to Power Platform and we have at least 10 external data sources we plan to integrate to Dataverse.
