GUI to enable user selection of measurement and station in kHTConnector module.
If you're planning to import data into powerBI using the kHilltopConnector module (https://github.com/hawkes-bay-rc/kHilltopConnector)
- click getdata option from the ribbon
- Select other in filter menu and select python script
- Use the following code in the script window
import kHTGui selection = kHTGui.kHTGui() import kHilltopConnector as kHK kHTop = kHK.kHilltopConnector(apiUrl='https://data.hbrc.govt.nz/Envirodata/EMAR.hts',refreshInterval=24*3600) kHTop.selectMeasurement = selection.measurementAndSite['selectMeasurement'] kHTop.selectSite = selection.measurementAndSite['selectSite'] data = kHTop.fetchData(fetchYearsAtATime=0,scaleFactor=1000)
Hope it helps
No warranty or guarantee.