Forum Discussion
Query referring to another query
Hi,
I'm getting my data from an API (GraphQL) that requires a token. There is a different token every couple of days, so the query should use a different token each time. (I can't use a static parameter for that).
I have another API query that gets the token whenever it's refreshed. (This query only has one value which is the token)
I'm trying to connect between the two queries so the data will refresh automatically but I keep getting the Formula.Firewall error (Query references other queries, so it may not directly access a data source.).
Is there a way to automatically get the updated token to connect to the API? (without manually change the token each time)
3 Replies
Can you turn the Token into a Parameter (Right click on the single value and Drilldown (must be ABC)) and utilise it that way rather than as a query?
For the error message I had a similar issue with passing parameters to SQL and had to change my privacy settings in order to make it work....
This started "randomly" as last week it wasn't an issue so guessing there has been some sort of update/change somewhere that now means this has to be ticked.