Hello i have following code for embedding and passing a valid sheet to load with params however sheet is not opening and default first sheet is opening
sheet option
sheetOptions: { initialSheetId: sheetID, singleSheet: false, sheetId: sheetID, emitSizeChangedEventOnSheetChange: false },
complete code
static embedDashboard = async (embedUrl, params, targetElm, sheetID) => {
const { createEmbeddingContext } = QuickSightEmbedding;
const embeddingContext = await createEmbeddingContext();
const frameOptions = {
url: embedUrl,
container: document.getElementById(targetElm),
height: "90%",
width: "100%",
//printEnabled: true,
resizeHeightOnSizeChangedEvent: true,
onChange: (changeEvent, metadata) => {
console.log(changeEvent);
console.log(metadata);
switch (changeEvent.eventName) {
case 'ERROR':
break;
}
}
}
console.log('loading->' + sheetID);
const contentOptions = {
parameters: params,
sheetOptions: {
initialSheetId: sheetID, singleSheet: false, sheetId: sheetID,
emitSizeChangedEventOnSheetChange: false },
toolbarOptions: { export: false, undoRedo: false, reset: false },
onMessage: async (messageEvent, experienceMetadata) => {
switch (messageEvent.eventName) {
case 'CONTENT_LOADED': {
embeddedDashboard.getSelectedSheetId().then((sheetId) => {
currentSheetID = sheetId;
console.log('new sheets->' + currentSheetID);
}).catch((error) => {
console.error('Error getting sheet ID:', error);
});
embeddedDashboardPrams = await embeddedDashboard.getParameters();
embeddedDashboardVar = embeddedDashboard;
break;
}
case 'PARAMETERS_CHANGED': {
const params = await embeddedDashboard.getParameters();
embeddedDashboardPrams = params;
break;
}
case 'SELECTED_SHEET_CHANGED': {
const params = await embeddedDashboard.getParameters();
embeddedDashboard.getSelectedSheetId().then((sheetId) => {
currentSheetID = sheetId;
}).catch((error) => {
console.error('Error getting sheet ID:', error);
});
break;
};
};
}
}
var embeddedDashboard = await embeddingContext.embedDashboard(frameOptions, contentOptions);
embeddedDashboardVar = embeddedDashboard;
};