Forum Discussion
How do I chain API calls?
I've run into this many times when using web service APIs
To get around this you'll likely have to encapsulate the data sources, at least maybe for stations, into a function
So maybe, GetStation () which just returns the JSON
The caller can convert the JSON into a list, then use this to adjust the URL to get the measurements
It is a pain, but it works. The following quote from the article below helped me find a solution when I encountered the same as you
"Embedding or masking your Data Sources inside Functions – this method will make your data sources not visible to the Data Privacy Levels at first, but you can tune your queries to define the data source at first and then apply a function."
https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/
I've run into this many times when using web service APIs
To get around this you'll likely have to encapsulate the data sources, at least maybe for stations, into a function
So maybe, GetStation () which just returns the JSON
The caller can convert the JSON into a list, then use this to adjust the URL to get the measurements
It is a pain, but it works. The following quote from the article below helped me find a solution when I encountered the same as you
"Embedding or masking your Data Sources inside Functions – this method will make your data sources not visible to the Data Privacy Levels at first, but you can tune your queries to define the data source at first and then apply a function."
https://www.poweredsolutions.co/2019/03/12/data-privacy-and-the-formula-firewall/