(Crossposting from Dynamics Community :
Virtual Entity - Parent/Child with Integer as Identity not working (dynamics.com))
I have successfully created the a Virtual Table for the entity "DevOps Work Item", using a Odata V4 Data provider.
Now I am trying to incorporate the "Parent Work Item" concept.
The datasource structure is as following (only the relevant part):
[
{
"WorkItemId": 426,
"ParentWorkItemId": null
},
{
"WorkItemId": 427,
"ParentWorkItemId": 426
}
]
As you can see, the WorkItem ID is an integer. However, in the virtual table that ID is somehow converted to a GUID ( 426 = 1aa, 427 = 1ab)
When I try to add a LookUp field to the same table, using the external name "ParentWorkItemId" , and try to fetch the data, I get the error:
Type mismatch of the external attribute of type System.Nullable`1[System.Int32] expected a 'System.Nullable`1[[System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' value.
I understand that the system receives an Integer and that it cannot match it with the GUID that it expects on the "parent". But this leaves me with the question: How can I link these parent/child, either using both the INTEGER value, or both using the GUID value? Or is there another way to get around this?
Best regards,
Koen