Hi!
I'm trying the REST API, I haven't done this before and the M and DAX languages are weird to me. I tried this on a postman I got this to work well. I tried looking for instructions to do this in Power BI, but that key makes it difficult.
Here is a view of postman javascript, showing that key how to create. Is there any way to make this work in Power BI?
pm.request.headers.add({key: 'X-Fivaldi-Partner', value: 'ws-XXXX'});
let bodyMD5 = '';
let contentType = '';
if (request.data.length > 0) {
bodyMD5 = CryptoJS.MD5(request.data);
contentType = request.headers['content-type'];
}
let time = Math.floor(new Date().getTime() / 1000).toString();
pm.request.headers.add({key: 'X-Fivaldi-Timestamp', value: time});
let stringToSign = request.method + LF +
bodyMD5 + LF +
contentType + LF;
let headers = pm.request.headers.all();
headers.sort(function (a, b) {
return a.key.toLowerCase().localeCompare(b.key.toLowerCase());
}).forEach(function(header) {
if (header.key.startsWith('X-Fivaldi')) {
let key = header.key.trim().toLowerCase();
let value = header.value;
if (typeof value === 'string') {
value = value.trim();
}
stringToSign += key + ':' + value + LF;
}
});
let url = request.url.replace('http://', '').replace('https://', '');
let path = '';
let queryStr = '';
if (url.includes('?')) {
path = url.substring(url.indexOf('/'), url.indexOf('?'));
queryStr = LF + encodeURI(url.substring(url.indexOf('?') +1));
} else {
path = url.substring(url.indexOf('/'));
}
stringToSign += path + queryStr;
console.log(stringToSign);
stringToSign = CryptoJS.enc.Utf8.parse(stringToSign);
//let key1 = CryptoJS.enc.Utf8.parse(pm.variables.get('partnerSecret'));
let key = CryptoJS.enc.Utf8.parse('xxxxxxxx');
console.log(key);
//console.log(key1);
let hash = CryptoJS.HmacSHA256(stringToSign, key);
let signature = 'Fivaldi ' + CryptoJS.enc.Base64.stringify(hash);
pm.request.headers.add({key: 'Authorization', value: signature});
