Error JSON format

(0) Share

Report

Posted on 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 😞

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Surendran Ravindran 212 on at

Like
a
(3)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
sintijar 9 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sintijar 9 on at

Like
a
(0)

Report
Copy link

Link copied!

2 mistakes were reported:

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
sintijar 9 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I think it is based on your connection.

I could be wrong...

Was this reply helpful? Yes No
sintijar 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, thank you. I managed to connect finally :). Everything works now.

Was this reply helpful? Yes No