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

Query Update with Chain

Beantwoord
Request Demo
  • Bewerkt

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

Opmerkingen

2 opmerkingen

Datum Stemmen
  • 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

U moet u aanmelden om een opmerking te plaatsen.