Unanswered

Power Automate Cloudmersive Tool ERROR

Like (0) Share

Report

Posted on 20 Oct 2023 10:03:25 by NikoSt

Hi,

at my Power Automate Flow I would like to call a CSV file and convert the data to an Excel tool. For this I use the tool from Cloudmersive "Convert CSV to Excel". I have enough capacity available in the Free license of Cloudmersive.

Currently, when I run the flow on tool "Convert CSV to Excel", I get the following error message:

The response is not in a JSON format.

What exactly is the reason for this?

I attached the flow. The Actitiy "Convert CSV to Excel" with the error and the Input CSV data.

All responses (2)

Answers (0)

Suggested answer

JD-14041842-0 2 on 14 Apr 2025 at 18:47:49

Like (0)

Report

Power Automate Cloudmersive Tool ERROR

Try to ensure that when creating the CSV file in SharePoint (or wherever you need), it is created with UTF-8 encoding. To do this, you need to use the following expression (in the file content section):

concat(uriComponentToBinary('%EF%BB%BF'), body('Crear_tabla_CSV'))

I hope I can help anyone who is having this problem
Noemi 2 on 09 Nov 2023 at 17:39:20

Like (0)

Report

Re: Power Automate Cloudmersive Tool ERROR

I am dealing with the same issue with Cloudmersive. It started to happen a while ago now and they don't seem to be to helpful on providing answer on how to fix it.