Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

"Import query result into table" connector?

Request Demo

In the UI for a Wdata table, you can add data three ways, as shown:

However, when working with the Workiva connector commands in a chain, while there are the "Import file into table" and "Import spreadsheet into table" commands (corresponding to the first two options, respectively), there doesn't seem to be a command allowing one to pass in a query result ID and insert its output into a table. It would be nice to be able to do this without the added steps / stand up / tear down of a file in the middle.

 

0

Opmerkingen

3 opmerkingen

Datum Stemmen
  • Isaac Oard

    Hi Andrew McKenzie 
    Thanks for your feedback! I will get you added to an idea ticket now.

     

    0
  • Jeff Hickey

    Hi Andrew, I wanted to provide steps to accomplish this within a Chain while the idea ticket that Isaac submitted is reviewed and pending.

    The method for adding Query results into a Wdata Table would be to first use the Run Query command then the Download Query Result command. These two commands will run and retrieve the Query results that can then be loaded into the Wdata Table. To do that, use the Create File and Import File Into Table commands. At minimum, these four commands will allow you to load the Query results into a Wdata Table.

    To take it a step further, it is leading practice and recommend to use the Load Data to Wdata template instead of the Create File and Import File Into Table commands. You may also want to consider adding additional logic to transform the Query output data as necessary prior to loading it into the Wdata Table as well as including error handling in your Chain.

    0
  • Andrew McKenzie

    Thanks Jeff Hickey for pointing me to the template!

    0

U moet u aanmelden om een opmerking te plaatsen.