I don't know why document.createElement('embed'); not working but when I put it up above let id; it works, I need it down because I want to use sheetURL variable as src
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<script src="https://live.zwidgets.com/js.sdk/1.1/ZohoEmbededAppSDK.min.js"> </script>
</head>
<body onload="myFunction()">
<p id="demo"></p>
<script type='text/javascript'>
let id;
ZOHO.embeddedApp.on("PageLoad", function (data){
id = data.EntityId[0];
ZOHO.CRM.API.getrecord({
Entity: "Deals",
RecordID: id,
})
.then(function(data) {
const sheetID = data.data[0].Due_Diligence_Sheet_ID;
// const sheetURL = data.data[0].Due_Diligence_Sheet_URL;
var sheetURL = "https://sheet.zohopublic.com/sheet/published/qsiei34cf7c2f3f2049658d806b567c53659d";
})
});
var embed = document.createElement('embed');
document.body.appendChild(embed);
embed.src = "https://sheet.zohopublic.com/sheet/published/qsiei34cf7c2f3f2049658d806b567c53659d";
embed.width = '100%';
embed.height = '660px';
</script>
</body>
</html>