Unanswered

Script having external api calls using fetch is not working

(0) Share

Report

Posted on by yogeshagarwal

Hello,

We've created an office script, where we're using external API calls using fetch. But the API request got stuck in the Pending state.

Following this documentation: Use external fetch calls in Office Scripts - Office Scripts | Microsoft Learn

There's no related error or warning in the console or debug panel.

Also, CORS headers are allowed as wildcards.

Any suggestions are really appreciated.

Regards

Yogesh

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

MichelleRanMSFT Microsoft Employee on at

Like (0)

Report

Hi @yogeshagarwal, sorry to hear you're running into issues with API calls! Could you share your script code (sensitive data removed as needed) so we can try to reproduce this issue? And to double check, are you running your script from Excel (and not from Power Automate)?

Was this reply helpful? Yes No
yogeshagarwal 2 on at

Like (0)

Report

Hi @MichelleRanMSFT, Thanks for reverting back.
Yes I'm doing an API call in Excel Script. Below is the code. Attached is the Rest API activity Network tab.

function main(workbook: ExcelScript.Workbook😞 void {
const sourceSheet = workbook.getWorksheet('Sheet1');
const apiUrl = 'https://API_URL';

const requestOptions: RequestInit = {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
};

function sendData() {
const sourceRange = sourceSheet.getUsedRange();
const sourceValues = sourceRange.getValues();
console.log(sourceValues);
requestOptions.body = JSON.stringify(sourceValues);

fetch(apiUrl, requestOptions)
.then((response) => {
if (!response.ok) {
throw new Error(`HTTP error! Status: ${response.status}`);
}
return response;
})
.then((data) => {
console.log('success:');
})
.catch((error) => {
console.log('Error:', error);
});
}
sendData();
}

image.png

Was this reply helpful? Yes No
MichelleRanMSFT Microsoft Employee on at

Like (0)

Report
Since fetch returns a promise, you need to await it:
async function main(workbook: ExcelScript.Workbook) { const sourceSheet = workbook.getWorksheet('Sheet1'); const apiUrl = 'https://API_URL'; const requestOptions: RequestInit = { method: 'POST', headers: { 'Content-Type': 'application/json', }, }; function sendData() { const sourceRange = sourceSheet.getUsedRange(); const sourceValues = sourceRange.getValues(); console.log(sourceValues); requestOptions.body = JSON.stringify(sourceValues); return fetch(apiUrl, requestOptions) .then((response) => { if (!response.ok) { throw new Error(`HTTP error! Status: ${response.status}`); } return response; }) .then((data) => { console.log('success:'); }) .catch((error) => { console.log('Error:', error); }); } await sendData(); }
Does that work?

Was this reply helpful? Yes No