Query Update with Chain
답변함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
-
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
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댓글을 남기려면 로그인하세요.
댓글
댓글 2개