René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"@odata.bind problem with same column and table names","articleBody":"We encounter an error when inserting data into a lookup column by OData.\nWe have two tables: Table1 and Table2, with logical names new_table1 and new_table2.\nIn Table2, We added a column named Table1 (logical name new_table1), which is a lookup column referencing Table1.\nWhen inserting data into the column new_table1@odata.bind with the value\n/new_table1s(8feb3d3a-71cf-f011-bbd3-000d3a26b7dc), we receive the following error:\n\"HttpError: Error identified in Payload provided by the user for Entity :'new_table2s'.\nFor more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293\n----\u003e InnerException : Microsoft.OData.ODataException: An undeclared property 'new_table1'\nwhich only has property annotations in the payload but no property value was found in the payload.\nIn OData, only declared navigation properties and declared named streams can be represented as properties without values.\"\nInterestingly, when we add another lookup column named Test (new_test) that also references Table1, the issue does not occur (the only diffrence is the column name)\nAfter testing with different tables and column names, it seems the problem arises specifically when the column name is identical to the name of another table.\nIn Dataverse, there is no issue when adding a column with the same name as another table, nor when creating a table with the same name as a column in a different table. Everything works correctly in Dataverse — the problem only occurs with OData.","author":{"url":"https://github.com/JakubStarobrat","@type":"Person","name":"JakubStarobrat"},"datePublished":"2025-12-09T10:55:57.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/77/PowerPlatform-DataverseClient-Python/issues/77"}