|
Les types de fichiers classiques ne pourront plus être utilisés à partir de janvier 2021. Vous pouvez transférer vos fichiers classiques ou télécharger un PDF. En savoir plus

"Import query result into table" connector?

Demande de démonstration

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

Commentaires

3 commentaires

Date Votes
  • 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

Vous devez vous connecter pour laisser un commentaire.