Unanswered

GPT-4 API gives bad JSON error in Power Automate Desktop but is ok in OPenAI Playground

(0) Share

Report

Posted on by Steve48

431

In Power Automate Desktop, I am looping through similar PDF files and using the GPT-4 API To extract text from them. Some files return status code 200, and some return 400 -bad JSON. I copied the text out of a ‘bad’ file that gets submitted to the API into the Openapi playground and it got processed with no error, Does anyone know how to troubleshoot? Why would the Openapi playground process ok but not the when invoking the webservice from Power Automate Desktop.? TIA

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Steve48 431 on at

Like
a
(1)

Report
Copy link

Link copied!

Using Postman I was able to determine (by successive truncation that there was a backslash "\" that made the json invalid. Removing that solved the problem. I don't know why playground worked. maybe they clean the input?
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

They probably have some escaping applied in the background. You can do that in PAD, by using Replace text to make your flow work properly. You might also want to escape/replace double quotes, too.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Steve48 431 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Agnius. I will replace the ”\”s. Double quotes don’t seem to cause a problem. I’m glad I tried using Postman. I didn’t realize that they underline bad JSON with a “squiggly” line. That made it easy to isolate the problem. All along I suspected the issue had to do with images, but that wasn’t the case.