ITIQPro Reporting let's me write scripts to access data.
They give me this example:
const catsURL = "https://cat-fact.herokuapp.com/facts";
let cacheData;
return {
	readRow: async(index) => {
		if (index === 0) {
			const request = await fetch(catsURL);
			const jsonData = await request.json();
			cacheData = jsonData.map((row) => {{ Column1: row.text, Column2: row.type]{{;
		}
		if (index > cacheData.length) return false;
		return cacheData[index];
	}
};
 
I'd like to call open-meteo to get the current temperature and wind speed, How would I do that following the pattern above?

Sure, I can help you with that! Here's how you can modify the script to call the Open-Meteo API to get the current temperature and wind speed:
 
javascript
const weatherURL = "https://api.open-meteo.com/v1/forecast?latitude=51.05&longitude=-114.07&current_weather=true";
let cacheData;
return {
	readRow: async(index) => {
		if (index === 0) {
			const request = await fetch(weatherURL);
			const jsonData = await request.json();
			const weatherData = jsonData.current_weather;
			cacheData = [{ Column1: weatherData.temperature, Column2: weatherData.windspeed }];
		}
		if (index >= cacheData.length) return false;
		return cacheData[index];
	}
};
 
In this script:
- The `weatherURL` is set to the Open-Meteo API endpoint with latitude and longitude for Rocky View County, Alberta.
- The `readRow` function fetches the weather data when `index` is 0.
- The `cacheData` array stores the temperature and wind speed from the API response.
- The function returns the cached data for the given index.
 
Feel free to adjust the latitude and longitude values to match your specific location. Let me know if you need any more help!

ITIQPro Reporting let's me write scripts in JavaScript to access data.
 
They give me this example:
 
const catsURL = "https://catfact.ninja/facts";
let cacheData;
return {
	readRow: async (index) => {
		if (index === 0) {
			const request = await fetch(catsURL);
			const jsonData = await request.json();
			const factsArray = Array.isArray(jsonData.data) ? jsonData.data :  [];
			cacheData = factsArray.map((row) => ({ Column1: row.fact, Column2: row.length }));
		}
		if (!cacheData || index >= cacheData.length) return false;
		return cacheData[index];
	}
};
 
I'd like to call open-meteo.com to get the current temperature and wind speed. I'm located in Rocky View County Alberta, Canada. How would I do that following the pattern above?

const weatherURL = "https://api.open-meteo.com/v1/forecast?latitude=51.05&longitude=-114.07&hourly=temperature_2m,wind_speed_10m&daily=temperature_2m_max,temperature_2m_min,wind_speed_10m_max&timezone=auto";
let cacheData;
return {
	readRow: async(index) => {
		if (index === 0) {
			const request = await fetch(weatherURL);
			const jsonData = await request.json();
			const hourlyData = jsonData.hourly;
			const dailyData = jsonData.daily;
 
			cacheData = [];
 
			// Gather next 12 hours of data
			for (let i = 0; i < 12; i++) {
				cacheData.push({
					Column1: `Hour ${i + 1}`,
					Column2: `Temp: ${hourlyData.temperature_2m[i]}°C, Wind: ${hourlyData.wind_speed_10m[i]} km/h`
				});
			}
 
			// Gather next 7 days of data
			for (let i = 0; i < 7; i++) {
				cacheData.push({
					Column1: `Day ${i + 1}`,
					Column2: `Max Temp: ${dailyData.temperature_2m_max[i]}°C, Min Temp: ${dailyData.temperature_2m_min[i]}°C, Max Wind: ${dailyData.wind_speed_10m_max[i]} km/h`
				});
			}
		}
		if (index >= cacheData.length) return false;
		return cacheData[index];
	}
};