Forums

How to call fetchXML and convert data on client side to an Array Cancel The title field is required!

1. sayyedrazam

   

   13 posts
   Registered:
   15 Apr 2015
   26 Oct 2016

   Link to this post

   I want to handle some data transformation and need result of a FetchXML into an array ?  Any idea on how can this be achieved. I can also manipulate data if returned in Json or XML format ! 
2. swebb

   

   24 posts
   Registered:
   13 Nov 2014
   Answered

   26 Oct 2016 in reply to sayyedrazam

   Link to this post

   Hi Sayyed,
   
   Version 3.3 of The Portal Connector comes with a feature called Saved Queries. This feature is located under the "The Portal Connector" menu.
   
   What this feature allows you to do is to configure a custom FetchXML query and it will generate a service URL to return the results in JSON. You can also configure this query to accept querystring parameters and it can be secured by role or user.
   
   You can find more information here: https://www.crmportalconnector.com/developer-network/documentation/howto/how-to/how-to-use-the-saved-queries-feature
   
   Thanks,
   Steve
3. sayyedrazam

   

   13 posts
   Registered:
   15 Apr 2015
   26 Oct 2016 in reply to swebb

   Link to this post

   That really looks cool as this should suffice our need. I am assuming there is no option in Version 3.2 !