Virtual Entity - Parent/Child with Integer as Identity not working

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

Quick Links