Query referring to another query

[Anonymous]

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)

[Anonymous]

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.

[Anonymous]

@Anonymous Thank you for the response! 

Unfortunately, I don't want to change the privacy settings, so I can't use that option. 

Regarding the first option you suggested, I tried to do so, but I keep getting the same error. After the drill down, how can I turn the value into a parameter?

[Anonymous]

Once you have done the drill down you can then type the name of that into your original query; for example I've created a parameter (drill down) that I renmaed ParameterName and then used it to filter a column......

Let me know if that doesn't make sense 🙂