I need some help translating a fetchmxl (advance find query) into Odata to be able to paste into PowerAutomate 'Get Records' function.
Here is my fetchxml query I downloaded from an advance find:
<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
-<entity name="new_assistanceapplication">
<attribute name="new_assistanceapplicationnumber"/>
<attribute name="new_assistanceapplicant"/>
<attribute name="new_assistanceapplicationid"/>
<attribute name="modifiedon"/>
<attribute name="modifiedby"/>
<attribute name="createdon"/>
<attribute name="createdby"/>
<attribute name="statuscode"/>
<attribute name="new_sectionselectedatthetimeofapplication"/>
<order descending="true" attribute="createdon"/>
-<filter type="and">
-<filter type="and">
<condition attribute="statuscode" value="914600018" operator="eq"/>
<condition attribute="createdon" value="3" operator="last-x-days"/>
<condition attribute="createdon" value="2" operator="olderthan-x-days"/>
</filter>
</filter>
Any help here is greatly appreciated. Thank you.
