Building Flow by following Convert CSV example from MS site and it fails on Step 10 Run Script with 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadRequest' "Unable to parse script reference."

(0) Share

Report

Posted on by selt

Hi Team,

Happy New Year!

I would appreciate some help...

I am following this example to build a Flow:

https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv

when I reach step 10, Run Script, and fill in as suggested, I get the following error:

Failed to retrieve dynamic inputs. Error details: 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "Unable to parse script reference.\r\nclientRequestId: 85dc86b9-0111-4a6f-a55b-cc0dc3aa8ab6", "error": { "message": "Unable to parse script reference." }, "source": "excelonline-ne.azconn-ne-002.p.azurewebsites.net" }'

That error looks to me that it cannot access the script or it is not in the expected location...

However, I did create and save Office Script as suggested and it is visible in my OneDrive and shared within the Template.xlsx workbook as well:

Content:

TIA!

Selt

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

rameshmukka 1,115 on at

Like (1)

Report

@selt
Please remove main function within main function. Only one main function should be present.

Thanks,
Ramesh

Was this reply helpful? Yes No
selt on at

Like (0)

Report

Thanks @RameshMukka , one more push would be appreciated though with the following error. I copied and pasted those MS example CSV and XLXS files into the folder, not sure why it is complaining. It created those files without extensions in the process and then failed.

"The file format is not recognized. Please check that the selected workbook is valid.\r\nclientRequestId: 7fe0ab69-b52b-4a3d-ad2f-95286716a592",

Was this reply helpful? Yes No
selt on at

Like (0)

Report

sorry @RameshMukka my bad i forgot to put .xlsx when i was re-creating the flow.

Now, i got the following result:
{ "message": "We were unable to run the script. Please try again.\nCompilation error: module.ts(1,2): error TS1109: Expression expected.\r\nmodule.ts(1,12): error TS1005: ';' expected.\r\nmodule.ts(1,21): error TS1005: ';' expected.\r\nmodule.ts(1,25): error TS1005: ';' expected.\r\nmodule.ts(1,30): error TS1005: ';' expected.\r\nmodule.ts(1,35): error TS1005: ';' expected.\r\nmodule.ts(1,37): error TS1005: ';' expected.\r\nmodule.ts(1,43): error TS1005: ';' expected.\r\nmodule.ts(1,47): error TS1005: ';' expected.\r\nmodule.ts(1,51): error TS1005: ';' expected.\r\nmodule.ts(1,54): error TS1005: ';' expected.\r\nmodule.ts(1,57): error TS1005: ';' expected.\r\nmodule.ts(1,61): error TS1005: ';' expected.\r\nmodule.ts(2,2): error TS1003: Identifier expected.\r\nmodule.ts(2,4): error TS1161: Unterminated regular expression literal.\r\n\r\nclientRequestId: 77faf951-e8c6-40b5-b69d-50d327c5d2d9", "logs": [] }

Was this reply helpful? Yes No
selt on at

Like (0)

Report

cancel that, found it after testing with giving csv example directly under main function. the comment was not properly commented out so it was trying to process it. Thanks for your help @RameshMukka

Was this reply helpful? Yes No