I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Query Update with Chain

Con risposta
Richiedi una demo
  • Modificato

Hello:

I've tried creating a chain that automatically launches a query without parameters and exports the result to a specific section of a spreadsheet. The chain contains a "Run query" and "Export Query result" nodes but gives an error when trying to export the query result.

The "Run query" node contains the ID of the query and runs well. The "Export Query result" contains the ID of the query result and the URL of the spreadsheet.

I would like to know if the structure of the chain is correct or if there are steps /nodes missing.

The error is the following:

Export Query Result Configuration:  
        Admin Host Override:  
                  Client ID: 65f8f3c608ee4839999bb5072787603a 
              Client Secret: ENCRYPTED 🔐 
          Export as Dataset: false 
     Graph DB Host Override:  
            Query Result ID: 29ae65969bae407ba5609e4e37808b5c 
            Spreadsheet URL: 

Command description: Exports a query result to the URL of the spreadsheet to export to, if present. If not present, a new spreadsheet will be created. 
 
Error running query: an exception was thrown during export 
. Code 400 
 
Result: Error running query: an exception was thrown during export 
. Code 400 

 

Thank you in advance

0

Commenti

2 commenti

Data Voti
  • Jeff Hickey

    Here are a couple of areas to begin troubleshooting:

    • Double check the Query Result ID is correct and is dynamically retrieving from Run Query command output.
    • Make sure that the same runner, such as CloudRunner, is being used in the two command.
    • Since your log shows that a Spreadsheet URL was not included, the command will attempt to create a new Spreadsheet. Please verify that the API Grant has access create a new Spreadsheet as well as the user associated to the API Grant.

    I recommend also reviewing the template Run Query with a Parameter Value From a Spreadsheet. While this template does include a couple extra steps for retrieving the parameter value from a Spreadsheet, it also includes the Run Query and Export Query Results command for reference.

    If you're still getting an error after making any necessary changes above, please post screenshots of the configurations of the Run Query and Export Query Results command for further review.

    0
  • Mikel De La Torre

    Hello Jeff:

    The error came because the API Grant didn't have access to create a new Spreadsheet.

    Thank you very much for your help.

     

    0

Accedi per aggiungere un commento.