Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

OData error converting fetchxml for N:N relationship #1097

Open
Djones4822 opened this issue Jan 3, 2025 · 1 comment
Open

OData error converting fetchxml for N:N relationship #1097

Djones4822 opened this issue Jan 3, 2025 · 1 comment

Comments

@Djones4822
Copy link

Djones4822 commented Jan 3, 2025

I have a custom table that has a M:M relationship with another custom table. I created this the way I normally would within the solution inside of powerapps. When I go to create the fetchXml it creates fine, but converting to the OData query I get an error:

Cannot find metadata for relation <table1>.<table1_guid_col> => <relationship_schema>.<table1_guid_col>

I am not sure why... The FetchXML returns fine and gives me what I expect. Is there any reason that I could have misspecified something? I tried with another M:M relationship between other tables (contact table and custom table) and it worked fine...

I'm running:

XRMToolbox - v1.2024.9.69
FetchXML Builder - v1.2024.10.1
Windows 11 - 24H2

@rappen
Copy link
Owner

rappen commented Jan 5, 2025

Hi Dave,
My guess it is some mismatching between LogicalName and SchemaName in the M:M relationship....
The error message is thrown here in the code:
https://github.com/MarkMpn/MarkMpn.FetchXmlToWebAPI/blob/master/MarkMpn.FetchXmlToWebAPI/FetchXmlToWebAPIConverter.cs#L1283
The code was created by the expert in this area, @MarkMpn, does Mark have any info to help us?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants