|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Refreshing Data Connection in Wdesk through Chains

Besvart
Be om demo

Hi Team,

 

I have a requirement to refresh the INcoming data connection into the Wdesk spreadsheet which is connected to Wdata query through chains. How can I achived it through chains?

1

Kommentarer

3 kommentarer

Dato Stemmer
  • Offisiell kommentar
    Tony Scalese
    • Redigert

    The Wdata API has multiple endpoints that allow the refreshing of a spreadsheet connection.  The Export Query Results endpoint can be used after the Execute Query endpoint to achieve this.  Both of these endpoints have Commands (Export Query Results, Run Query respectively) in the Workiva Connector that can be used.  Also you can use the Refresh Connection endpoint or Refresh Batch of Connections endpoint but these would require the use of the HTTP Connector as these are not currently Commands in the Workiva Connector.  

  • Saima Rasheem

    I am using export query results and I see a flash when my chain runs but the data is not getting updated. 

    0
  • Jeff Hickey

    Hi Saima, here are some troubleshooting steps:

    1. Verify your Run Query command is producing the expected data
    2. Verify that you're passing the correct Query ID to the Export Query Result command
    3. Verify that the Chain has permission to edit the Spreadsheet where you're trying to send the results to
    4. Verify that you are not exceeding the Spreadsheet cell limits with the amount of data you are sending to the Spreadsheet
    0

Logg på for å legge inn en kommentar.