office-scripts-docs icon indicating copy to clipboard operation
office-scripts-docs copied to clipboard

The API you are trying to use cannot be found error returned when any of the Query class methods are called on getQueries

Open 3levate opened this issue 5 months ago • 1 comments

All of the Query class methods do not work with the workbook.getQueries() method; however, these methods all seem to work on an individual Query object returned by workbook.getQuery("name")


To reproduce:
function main(workbook: ExcelScript.Workbook) {
	const queries = workbook.getQueries();
	queries.forEach((query: ExcelScript.Query) => {
		console.log(query.getName()); //replace with any Query class method
	});
}

Errors returned in console: image image image


Working methods when called on `getQuery()`:
function main(workbook: ExcelScript.Workbook) {
	const query = workbook.getQuery("MASTERFORECAST");
	console.log(query.getLoadedToDataModel());
}

Output: image image

3levate avatar Sep 10 '24 17:09 3levate