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

mvvm double click event in listview

If you want to get the double click event on a listview item you can try with this code; <ListView Grid.Row="0" Grid.RowSpan="3" Grid.Column="0" Width="250" Height="200" HorizontalAlignment="Stretch" VerticalAlignment="Top" AlternationCount="2" BorderBrush="#FFA8CC7B" ItemContainerStyle="{StaticResource alternatingStyle}" ItemsSource="{Binding FromPayerNameList}" SelectedItem="{Binding SelectedFromPayer, Mode=TwoWay}"> <ListView.ItemTemplate> <DataTemplate> <TextBlock Width="{Binding Path=ActualWidth, RelativeSource={RelativeSource FindAncestor, AncestorType={x:Type ListView}}}" Text=...
Post a Comment
Read more

WPF datagrid cell textbox change event

Entity/Class: public class FeesDetails : INotifyPropertyChanged { public int Id { get; set; } public string FeesName { get; set;} public string FeesDetailsName { get; set; } public int? PaidAmount { get; set; } public event PropertyChangedEventHandler PropertyChanged; private void NotifyPropertyChanged(System.String info) { if (PropertyChanged != null) { PropertyChanged(this, new PropertyChangedEventArgs(info)); } } public int feesAmount { get; set; } public int FeesAmount { get { return this.feesAmount; } set { if (value != this.feesAmount) { this.feesAmount = value; NotifyPropertyChanged("FeesAmount"); } } } } XAML: <DataGrid AutoGenerateColumns="False" Height="21...
Post a Comment
Read more

The calling thread must be STA, because many UI components require this.

Using Thread: // Create a thread Thread newWindowThread = new Thread(new ThreadStart(() => { // You can use your code // Create and show the Window FaxImageLoad obj = new FaxImageLoad(destination); obj.Show(); // Start the Dispatcher Processing System.Windows.Threading.Dispatcher.Run(); })); // Set the apartment state newWindowThread.SetApartmentState(ApartmentState.STA); // Make the thread a background thread newWindowThread.IsBackground = true; // Start the thread newWindowThread.Start(); Using Task and Thread: // Creating Task Pool, Each task will work asyn and as an indivisual thread component Task[] tasks = new Task[3]; // Control drug data disc UI load optimize tasks[0] = Task.Run(() => { //This will handle the ui thread :The calling thread must be STA, because many U...
Post a Comment
Read more