FetchXMLBuilder icon indicating copy to clipboard operation
FetchXMLBuilder copied to clipboard

Cannot find metadata for relation

Open lambeaulady opened this issue 2 years ago • 1 comments

When I attempt to Convert to Power Automate Parameters, I get this message: Cannot find metadata for relation task.ownerid =>team.teamid

It otherwise works to generate the results/FetchXML. I really like this tool but the whole reason I was using it was to generate the ExpandQuery code.

image

lambeaulady avatar Feb 08 '24 22:02 lambeaulady

The conversion to Web API & Power Automate parameters relies on using the defined relationships - you can't join on arbitrary attributes in the same way you can in Fetch XML. In this case the relationship is defined as being task.owningteam >- team.teamid, so if you use Fetch XML like:

<fetch>
  <entity name="task">
    <link-entity name="team" from="teamid" to="owningteam">
      <attribute name="name" />
    </link-entity>
  </entity>
</fetch>

this will convert to Web API & Power Automate parameters:

image

MarkMpn avatar Mar 29 '24 22:03 MarkMpn

@lambeaulady, do you have anything more that I should fix? Otherwise, this issue will be closed.

rappen avatar Aug 16 '24 08:08 rappen

It seems to be working now, thank you.

lambeaulady avatar Aug 23 '24 13:08 lambeaulady