502 bad gateway when trying to execute an excel script

[Anonymous]

Hi, I am getting a 502 bad gateway error when trying to execute a script. Tried both the Excel Run Script action as well as the Sharepoint Run Script one, same result. Here is the error:

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "europe-002.azure-apim.net", "clientRequestId": "c4db4595-ddc9-4b2b-a7ac-aacdb4478beb", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: c4db4595-ddc9-4b2b-a7ac-aacdb4478beb", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-we.azconn-we-003.p.azurewebsites.net" } } }

[bcobra42]

I am also seeing this issue since Saturday. clientRequestId: 835f9c91-e17d-4655-b604-3aa470d6b965

[GeoffRen]

Sorry to hear you're experiencing this problem. It is an issue on our side and we are actively investigating the root cause. Will let you know once it's been addressed. Thanks for your patience!

[drakarin]

I am also getting this error:
The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "power-apis-usgov001-public.azure-apihub.us", "clientRequestId": "3b5683eb-ae67-45b8-942a-023e507829db", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: 3b5683eb-ae67-45b8-942a-023e507829db", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-usgv.azconn-gcc-usgv-001.p.azurewebsites.us" } } }

It is impacting all of my scripts.

Is there something on our end as customers we should be doing differently?

-- Sean

[GeoffRen]

No, this is completely on our end. If you are experiencing a 502 and are on a gov cloud, at this time, it is 100% on our end.

[drakarin]

Thank you very much for the update @GeoffRen !

[drakarin]

Update -- my issues are cleared and the flows are working properly now.

[GeoffRen]

Yes, this should be fixed now. Thanks for the update and for being patient!

[mblekhshtein]

Hello, 
I think I might encountered the same issue. I am trying to test if office scripts work for me. First of all, the action asks me for a script parameter field, which I did not specify in my script and in the course of the topic - BadGateway

Also this excel workbook should contain scripts inside itself, but from "Run office script" action it is not seen (maybe it could be a part of the same retrieval action)

Here is my error message:
Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "germany-001.azure-apihub.net", "clientRequestId": "02b81ffb-4bf7-4b8a-b3b9-a934705a0bf9", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments.\r\nclientRequestId: 02b81ffb-4bf7-4b8a-b3b9-a934705a0bf9", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-gwc.azconn-gwc-001.p.azurewebsites.net" } } }'

The flow and action configuration is shown on screenshot.
The script is has the following structure:
function main(workbook: ExcelScript.Workbook) {
  //Delete all rows in assignments table.
  let delete_tbl = workbook.getTable("Assignments_tbl");
  // Delete all row(s) at index 0 from table Assignment_tbl
  let numberOfRows = delete_tbl.getRowCount();
  if (numberOfRows > 0 ) delete_tbl.getRangeBetweenHeaderAndTotal().delete(0);
}

Thank you in advance!

[Thib_Kyos]

Hello, 

@GeoffRen 

Still have the issue here : Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: error:  code: 502, source: europe-001.azure-apim.net, clientRequestId: fadb4ced-a006-4d34-8ea7-5a9cd39c86dc, message: BadGateway, innerError:  status: 502, message: he server experienced an issue and couldn't complete the request. Please try again in a few moments.clientRequestId: fadb4ced-a006-4d34-8ea7-5a9cd39c86dc  messag: The server experienced an issue and couldn't complete the request. Please try again in a few moments.

[GeoffRen]

Your script seems to be in an invalid state. We usually see this happen when the script file itself was modified manually. Can you recreate the script and try again?

[GeoffRen]

It looks like you are having the same issue as above. Your script seems to be in an invalid state. We usually see this happen when the script file itself was modified manually. Can you recreate the script and try again?

[akamerer]

@GeoffRen I am getting the same issue for several of my flows. Here is one of the errors:

{

  "error": {

    "code": 504,

    "source": "flow-apim-msmanaged-na-northcentralus-01.azure-apim.net",

    "clientRequestId": "1992aed5-ab69-4242-b1ae-f501e55884a7",

    "message": "BadGateway",

    "innerError": {

      "status": 504,

      "message": "Your Office Script has timed out. Please try again.\r\nclientRequestId: 1992aed5-ab69-4242-b1ae-f501e55884a7",

      "error": {

        "message": "Your Office Script has timed out. Please try again."

      },

      "source": "excelonline-eus2.azconn-eus2-003.p.azurewebsites.net"

    }

  }

}

[Sumit-Sandhir]

@GeoffRen  I am getting the same issue as well. Looks like again there is a certificate issue on Microsoft end. Here is the error message i am getting
The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScriptV2' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "uk-001.azure-apim.net", "clientRequestId": "1891f008-1e0a-4915-a79c-ab4a5228f80d", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments.\r\nclientRequestId: 1891f008-1e0a-4915-a79c-ab4a5228f80d", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-ukw.azconn-ukw-001.p.azurewebsites.net" } } }

[GeoffRen]

We do not have a certificate issue or know of an outage currently. It seems that your issue is that your script file was corrupted somehow. The .osts file corresponding to your script does not seem to be valid JSON. You can try to fix that file manually, or just create a new identical script and that should fix your issue.

[GeoffRen]

It seems that your script is timing out. It's difficult to say exactly why without knowing what your script looks like and what the workbook it is running on looks like. For assistance, I'd recommend making a new post with a full repro containing a copy of your script and the workbook it is running on for more help from the wider community as well (you can tag me there too).

[scott_od]

@GeoffRen I am also having repeated failures with trying to run my excel script from power automate, I can run it directly in excel without any issues:

{

  "error": {

    "code": 502,

    "source": "flow-apim-europe-001-northeurope-01.azure-apim.net",

    "clientRequestId": "d1dded62-ea25-4e9c-9ed9-9ed985b924b4",

    "message": "BadGateway",

    "innerError": {

      "message": "We were unable to run the script. Please try again.\nThe script couldn't create a connection with Excel. Please try again.\r\nclientRequestId: d1dded62-ea25-4e9c-9ed9-9ed985b924b4",

      "logs": []

    }

[Ablaye]

Hi GeoffRen,

Can you help me.

I have this issue if i register an Excel run script flow :

The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadGateway'. Error response: { "error": { "code": 502, "source": "france-001.azure-apim.net", "clientRequestId": "2c0e5648-139e-4407-a40d-ba7d906aab14", "message": "BadGateway", "innerError": { "status": 502, "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments. clientRequestId: 2c0e5648-139e-4407-a40d-ba7d906aab14", "error": { "message": "The server experienced an issue and couldn't complete the request. Please try again in a few moments." }, "source": "excelonline-fs.azconn-fs-001.p.azurewebsites.net" } } }.

Thanks