Skip to main content

d365 portal fetchxml query as a json service

 In D365 portal sometimes we need to write a complex query which is not covered by List as OData Feed. If you use D365 Form Liquid fetchxml query is also not supported. You can write any fetch xml query as JSON data service into the portal.

1. Create Web Template

Into your web template, you need to write your fetchxml query


 {% assign std_discountid = request.params['id'] %}  
 {% fetchxml discountAccount %}  
 <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">  
  <entity name="std_std_discount_account_membership" >  
   <attribute name="accountid" />  
   <attribute name="std_discountid" />  
   <filter>  
    <condition attribute="std_discountid" operator="eq" value="{{std_discountid}}" />  
   </filter>  
  </entity>  
 </fetch>  
 {% endfetchxml %}  
 { "accountdiscounts" :   
 [{% for item in discountAccount.results.entities %}{"std_discountid":"{{ item.std_discountid }}","accountid":"{{ item.accountid }}"}  
 {% unless forloop.last %},{% endunless %}  
 {% endfor %}]  
 }

2. Create a Web page for this Web template so that we can access the Web Template with Partial URL

3. Give your fetchxml query table permission. 

(If your fetchxml query require N:N relation table you can check how to give permission for N:N relational table d365 portal many to many relationship table permissions )

Call the web template as JSON service.

     // //Get student Membership Discount 2 all Account  
     var dataUrI = "https://your.powerappsportals.com/discountaccount/?id="+encodeURIComponent(studentDiscountListId[1].proevt_discountid);  
     $.ajax({  
       type:'GET',  
       contentType: 'application/json; charset=utf-8',  
       datatype: 'json',  
       url: dataUrI,  
       beforeSend: function(XMLHttpRequest){  
         XMLHttpRequest.setRequestHeader('Accept', 'application/json');  
       },  
       async: false,  
       success: function(data, textStatus, xhr){  
         for (var i = 0; i < data.accountdiscounts.length; i++)   
         {  
           studentMembershipDiscountAccountList2.push(data.accountdiscounts[i].accountid);  
         };  
       },  
       error: function (xhr, textStatus, errorThrown ){  
         alert(textStatus+ ''+errorThrown);  
       }  
     });


If the table permission is set global, you can also check your get request using postman.







Labels:

Comments

Post a Comment

Popular posts from this blog

C# run powershell script as administrator

Recently I was fetching a problem that I need to run a PowerShell script that will change TFS user Display name and SID. I was trying to run that script from C# that was not working due to TFS security update and TLS certificate. Using this code block I resolve the Issue. var newProcessInfo = new System.Diagnostics.ProcessStartInfo(); newProcessInfo.FileName = @"C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe"; newProcessInfo.Verb = "runas"; // Define Run as administrator newProcessInfo.Arguments = script; //Define your powershell script newProcessInfo.UseShellExecute = false; newProcessInfo.RedirectStandardOutput = true; // This will enable to read Powershell run output newProcessInfo.RedirectStandardError = true; Process proces = System.Diagnostics.Process.Start(newProcessInfo); proces.WaitForExit(); // I want to read the output string from powershell window StringBuilder output = new StringBuilder(); output.Append("Started"); while (!proces.St
Post a Comment
Read more

ASP.NET MVC razor SAP Crystal report

Crete a new project: Add a aspx Master Page Create a new folder Reports and 2 sub folder crystal & crystalviewer Now add a web form page in crystalviewer  folder. Add the master page namespace in your web form page. MasterPageFile ="~/Views/Shared/ReportSite.Master" Replace your web form by this code < asp : Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" runat ="server">      </ asp : Content > Now go to design mode of your web form drag & drop the crystal report viewer in your web form. After that your page will be look look like this. Replace the code: < CR : CrystalReportViewer ID ="EmployeeList" runat ="server"   HasCrystalLogo ="False"     AutoDataBind ="True"   Height ="50px"   EnableParameterPrompt ="false" EnableDatabaseLogonPrompt
Post a Comment
Read more

mvc razor textboxfor change event change another textboxfor value

Based on value of Weight, Rate , CNF & AWB it will change the value of Freight , TTLCNF anfd TTLFright . Freight= Weight*Rate; TTLCNF  = Weight*CNF; TTLFright=  Freight+ TTLCNF  + AWB; @Html.TextBoxFor(model => model.Weight, new { onChange="return GetWight(this);"}) @Html.TextBoxFor(model => model.Rate, new { onChange="return GetWight(this);"})/Kg @Html.TextBoxFor(model => model.Freight, new {disabled = "disabled" , @readonly = "readonly" ,onChange="return GetTTLFright(this);"}) @Html.TextBoxFor(model => model.CNFPK, new { onChange="return GetCNFPK(this);"}) @Html.TextBoxFor(model => model.TTLCNF, new {disabled = "disabled" , @readonly = "readonly",onChange="return GetTTLFright(this);" }) @Html.TextBoxFor(model => model.AWB, new { onChange="return GetTTLFright(this);"}) and script <script> function GetW
Post a Comment
Read more