Error JSON format

Like (0) Share

Report

Posted on 12 Mar 2023 13:53:29 by sintijar

I'm trying to get data from PDF document.

Got an error:

{
"statusCode": 401,
"headers": {
"Request-Context": "appId=cid-v1:0dacbed6-da67-4d12-94b4-2378f6427ff0",
"x-azure-ref": "20230312T133841Z-7k073azf1x37pcuwhbdq01fm8000000003s000000001wt3d",
"X-Cache": "CONFIG_NOCACHE",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Sun, 12 Mar 2023 13:38:43 GMT",
"X-Powered-By": "ASP.NET",
"Content-Length": "286",
"Content-Type": "application/json"
},
"body": {
"error": {
"code": 401,
"source": "flow-apim-europe-001-northeurope-01.azure-apim.net",
"clientRequestId": "22434333-0bb6-48c4-83f8-1928ac74e8ae",
"message": "The response is not in a JSON format.",
"innerError": "The API Key provided is not valid"
}
}
}

Please support me, I'm already without ideas 😞

All responses (8)

Answers (0)

sintijar 9 on 20 Mar 2023 at 06:41:16

Like (0)

Report

Re: Error JSON format

Yes, thank you. I managed to connect finally :). Everything works now.
Rhiassuring 8,688 Super User 2025 Season 1 on 13 Mar 2023 at 20:58:44

Like (1)

Report

Re: Error JSON format

I think it is based on your connection.

I could be wrong...
sintijar 9 on 13 Mar 2023 at 19:59:11

Like (0)

Report

Re: Error JSON format

I realized that I'm not able to connect to encodian first time. I do have API , but it is not possible to enter it and connect. No such window if encodian action is chosen
Rhiassuring 8,688 Super User 2025 Season 1 on 13 Mar 2023 at 16:30:07

Like (0)

Report

Re: Error JSON format

Hi @sintijar

"The API key provided is not valid" - it sounds like maybe you have an account with Encodian and it has run out of capacity. The free key, I think, only allows 50 runs a month. Something like that. Have you been trying this a lot? Are you using a free license?
sintijar 9 on 12 Mar 2023 at 20:09:43

Like (0)

Report

Re: Error JSON format

2 mistakes were reported:
sintijar 9 on 12 Mar 2023 at 18:51:54

Like (0)

Report

Re: Error JSON format

Thanks @Rhiassuring the form can be fulfilled. Tried ones again, the same problem
About action Parse JSON. Tryed, but I'm not sure what I should remove. Scheema also is not generating.
Surendran Ravindran 212 on 12 Mar 2023 at 17:09:51

Like (3)

Report

Re: Error JSON format

Hi @sintijar ,

The JSON will contain ‘\’ escape characters which we need to remove. This can either be done with a text or code editor using ‘Find and Replace’ or online service.

After that use Parse Json action for proper managing and formatting of Json

Refference : https://www.encodian.com/blog/extracting-pdf-form-data-using-microsoft-flow/

Regards
Surendran R
Rhiassuring 8,688 Super User 2025 Season 1 on 12 Mar 2023 at 16:52:44

Like (0)

Report

Re: Error JSON format

Hi there,

Is the PDF that you're pointing to a fillable form?

I tried this in a slightly different way, but had success. Here's what I did:

This makes me wonder if maybe PowerApps isn't 100% finished (in yours) when it fires, or something - that or it's not a fillable form.