|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Refreshing Data Connection in Wdesk through Chains

Udzielono odpowiedzi
Zamów wersję demonstracyjną

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

Komentarze

Komentarze: 3

Data Głosy
  • Oficjalny komentarz
    Tony Scalese
    • Edytowano

    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

Zaloguj się, aby dodać komentarz.