Can Excel accept a callback from a Web API with a javascript Office Add-in with a Websocket?

Greg Lovern 0 Reputation points
2023-05-27T08:10:12.0366667+00:00

I've been asked to call a certain Web API from Excel VBA to do a certain task. I was given a sample call to work with. This is for a propietary Web API for the organization so I don't think it's going to help to post the code here.

I was getting an error so I contacted the person who wrote it. He explained that it works by having a callback Web API call the caller with the results. And that since Excel can't accept a callback from a Web API, it wasn't going to work from Excel.

I googled for if there might be a workaround, and it sounds like maybe the new Office Add-ins, which are really javascript running on a web server which Excel connects to so that they can automate Excel like an Add-in, has a feature called Websockets which might accept Web API callbacks.

Is that correct--can Excel via an Office Add-in with Websockets accept a Web API callback?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,321 questions
0 comments No comments
{count} votes