Unanswered

How to fix "The response is not in a JSON format"

(0) Share

Report

Posted on by lolfav

Hello everyone. I have encountered an issue when building my flow. I use Cloudmersive in order to transform an Excel sheet into a pdf. However, during the action "Split a signle XLSX into separate worksheets", an error occurs, which is the following : The response is not in a JSON format.

Do you know how I can fix that?

Many thanks!

Screenshot 2021-06-28 165405.png

Screenshot 2021-06-28 170925.png

Screenshot 2021-06-28 171022.png

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

Hi @lolfav :

I've made some tests but did not encountered the problem you mentioned:

Please check the Cloudmersive Document Conversion connection:

1\Whether the Cloudmersive account is registered correctly, the corresponding API is obtained,

and the connection is correctly configured.

2\If your Cloudmersive account is a free trial account, have you exceeded the 800 calls/Month limit?

Best Regards,

Bof

Was this reply helpful? Yes No
lolfav 15 on at

Like (0)

Report

Many thanks for your answer! I have a few questions.

First, what should be the connection name that I enter in the Cloudmersive Document conversion? How can I change this name?
And then, should I be connected to Power Automate with the same account which retrieved the API key from Cloudmersive? I am actually not the one who got the key, but another member of my organization.

Thank you!

Was this reply helpful? Yes No
lolfav 15 on at

Like (0)

Report

I also think the issue might be coming from the fact that I am not sure if I am using the Premium version of Power Automate. Do you know how I can get this version as a free trial?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @lolfav :

Q1 :First, what should be the connection name that I enter in the Cloudmersive Document conversion? How can I change this name?

The name of the connection does not affect anything, you do not need to make any changes. The only thing you have to do is to let the author of this connection share this connection with you, or I suggest you can consider creating a connection yourself, and then use this connection:

Plan1: let the author of this connection share this connection with you

Plan2: You could register a new account and get the API key

*get the API Key

*Create a new connection:

Plan3: Ask the connection's owner and get the key,then create a new connection using the key

Q2:And then, should I be connected to Power Automate with the same account which retrieved the API key from Cloudmersive? I am actually not the one who got the key, but another member of my organization.

The api key is universal, and it does not affect anything. You can let the owner of this connection give you this connection share, or create a connection yourself.

Best Regards,

Bof

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @lolfav :

OK,I think that is the problem. Cloudmersive Document Conversion is a premium connector.

You should be able to obtain a trial license through "try free".(If the current account has not obtained trail permission before)

Best Regards,

Bof

Was this reply helpful? Yes No
lolfav 15 on at

Like (0)

Report

Thank you @v-bofeng-msft !
I just registered a new account and got a new API key. However, when I added the connection and entered the key, the following appeared:

What can I do?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @lolfav :

I suggest you click manual test and then authorize connections

Best Regards,

Bof

Was this reply helpful? Yes No
lolfav 15 on at

Like (0)

Report

HI @v-bofeng-msft. Thanks again for answering. Unfortunately, when I click on the Try Free, I get into this page.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @lolfav :

Maybe you can try again later or change the browser and try again.

Best Regards,

Bof

Was this reply helpful? Yes No
Megan2000 2 on at

Like (0)

Report

Hello I am trying to make a new flow and when I try to run it I get a trigger error that says "The response is not in a JSON format." Does anyone know how to fix this?

Was this reply helpful? Yes No