Is it possible to access the expoert of tags in Excel directly via Excel? Instead of going into the Trendminer and exporting a tag view, would it be possible to load the data of different tags directly into Excel via API connection and a PowerQuery in Excel?
Answer
Export Data to Excel
Best answer by fvandael
Hi Stefan,
There is an api endpoint for extracting tag data which you can use, we do not have a PowerQuery script for this.
On this page you can find more details about the endpoint: https://developer.trendminer.com/compute-api/#_get_index_data.
You will also need to authenticate and get a token which you can find more information about on this page: https://developer.trendminer.com/compute-api/#_retrieving_an_access_token.
If you have any questions feel free to reach out.
Frederik
Hi Stefan,
There is an api endpoint for extracting tag data which you can use, we do not have a PowerQuery script for this.
On this page you can find more details about the endpoint: https://developer.trendminer.com/compute-api/#_get_index_data.
You will also need to authenticate and get a token which you can find more information about on this page: https://developer.trendminer.com/compute-api/#_retrieving_an_access_token.
If you have any questions feel free to reach out.
Frederik
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.