Export to file for Paginated Reports (Web API-JSON)

[ntruong1994]

Hi everyone,

I tried running a flow that exported a daily Paginated report on Onedrive by Power Automate but got error 401 : " The response is not in a JSON format ". My current dataset is connected to a web API. Could you please help to fix this error? Thanks a lot !

Best regards ,

VT

[Anonymous]

Hi  @ntruong1994 ,

As the error message mentions, it seems like the request is not valid JSON format strings. Have you tried to put them into the JSON formatter to verify the data formats?

Solved: Error: The response is not in a JSON format. - Power Platform Community (microsoft.com)

In addition, are any specific characters included in the values? (e.g. escape character, Unicode characters) They may also cause issues.

This is the related document, you can view this content:

Solved: 'The response is not in JSON format' error for MS ... - Power Platform Community (microsoft....

Solved: error: "The response is not in a JSON format" - Power Platform Community (microsoft.com)

Solved: The response is not in a JSON format, Cannot read ... - Power Platform Community (microsoft....

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.