locked
Web service to update subgrid RRS feed

  • Question

  • Hi Everyone,

    Basically, I want to update the contents of a subgrid depending on the results of a webservice. i.e. Webservice fires, returns some results, I want those results to populate the subgrid. So, my order history based on my customer number for example.

    Thanks in advance

    D


    • Edited by Ded_sec Monday, November 24, 2014 3:09 PM
    Monday, November 24, 2014 2:52 PM

All replies

  • Web service reads data from where? Is it a SQL Server Db?

    Sachith Chandrasiri

    Tuesday, November 25, 2014 2:52 AM
  • Sorry, I should have said. Yes, it would be a different SQL Server Db. So I would need to use my customer number (which is in a CRM field) to be used in a query (to an external Db, i.e. not in the same CRM Db) to return all of my orders, then use thosed results to populate a grid/sub grid on my contact record in CRM.

    D

    Tuesday, November 25, 2014 8:51 AM
  • So according to my understanding your sub grid contains some CRM records. So I reckon you create a windows service to synchronize your SQL Database table and that particular entity's records.

    Sachith Chandrasiri

    Tuesday, November 25, 2014 8:56 AM