Hello again Guilhermebastian2,
I understand that the token field updates (overwrite the value) on the same record and does not generate a new record. every 5 minutes
If so, we will take advantage of the fact that we know the value of 1 of the autoincrement field to refer to that record and refer to the value of the token.
The code for your example will be something like this:
<html>
<head>
<title>Exemplo de Embedded</title>
<script src="https://strpowerbi.blob.core.windows.net/powerbijs/jquery-3.4.1.min.js"></script>
<script type="text/javascript">
window.onload = function () {
var headers = {
'X-Knack-Application-ID': 'YOUR-KNACK-APPLICATION-ID-HERE',
'X-Knack-REST-API-Key': 'YOUR-REST-API-KEY-HERE',
'content-type': 'application/json'
};
var filterToken = {
'rules': [
{
'field':'field_19XX', //HERE IS YOUR autoincrement FIELD
'operator':'is',
'value': 1
}
]};
//HERE YOU MUST CHANGE YOUR OBJECT NUMBER
var fullUrl = 'https://api.knack.com/v1/objects/object_XX/records?filters=' + encodeURIComponent(JSON.stringify(filterToken));
$.ajax({
url: fullUrl,
async: false,
type: 'GET',
headers: headers,
}).done(function(data) {
var myToken = data.records[0].field_1934); // HERE YOU GET THE TOKEN VALUE
});
document.getElementById("field").val("
<html>
<script type='text/javascript'>
window.onload = function () {
var embedConfiguration = {type: 'report',accessToken: '[[[myToken]]]',id: '3c0ae9a0-550f-4920-b4c0-a26a29b76ee9',embedUrl: '[[[FIELD_1936]]]'};
var $reportContainer = $('#reportContainer');
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);}
</script>
<div id='reportContainer'></div>
</html>");
};
};
}
</script>
</head>
<body>
<div id="field">Teste</div>
</body>
</html>
</head>
<body>
<div id="field">Teste</div>
</body>
</html>