2 Replies Latest reply on Oct 13, 2017 9:49 AM by Matt Ryan

    Is it true that the WDC can only create an extract on publish and not call a REST service when rendered?

    Matt Ryan

      I am looking into building a WDC for our server where it accesses one of our big data stores via a REST service.  The idea being that the workbook would request data rows for a single "key", the rest service would query those rows and return to the workbook only rows with that key (a little more than that behind the scenes).   So the concept is that the workbook would get the data each time it was rendered, not at publish time.  Once rendered it would be fast to filter the various views on just the data pulled from that initial call.

       

      But if the whole workbook would have to be published just to adjust the data source from one key value to the next - then WDC isn't a feasible solution.  

        • 1. Re: Is it true that the WDC can only create an extract on publish and not call a REST service when rendered?
          Brendan Lee

          Hey Matt,

           

          It more depends on where you are getting this key from.  If you are trying to get this key from something in the viz (like a parameter) or the username of the person accessing the viz, then what you say is true*.   This is because the metadata written into the WDC (such as the username, password, connectionData, etc.) cannot be altered once the WDC is published.

           

          However, since the the WDC is a web app you control, if the key is something you could dynamically read from a REST API or some other server side component, then you could just read that key from your WDC when it is doing the gather data phase, and use that key to adjust what data you bring back dynamically.


          Hope that helps!
          Brendan

           

           

           

          *Currently true, we do have plans to address these areas in the future. 

          • 2. Re: Is it true that the WDC can only create an extract on publish and not call a REST service when rendered?
            Matt Ryan

            Thanks for your input!   But my idea hinges on the REST service getting the key from a URL parameter on the workbook.  We use that all the time to embed dashboards where a filter is set to an initial value before it renders.  It is that value that I would like to have input to the REST service so it can do a variety of different things before querying the database.  Note, the return to the workbook would always be in the same exact format.