Custom Connector POST Json

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm creating an API Custom Connection with POST, but it is not working

I managed to make the connection on Postman, but when I tried the importing in powerapps it did not work.

here are some prints, can you help me?

http://www.erp.ladder.com.br/api/erp/saldo-estoque-ladder/

HTTP 200 OK
Allow: POST, OPTIONS
Content-Type: application/json
Vary: Accept

{
 "scs": {
 "estoque": 1,
 "saldo": 1,
 "reserva": 0
 },
 "exists": true,
 "rj": {
 "estoque": 0,
 "saldo": 0,
 "reserva": 0
 }
}

post json:
{"produto": "catalog_number"}

Duvida 1.png Duvida 2.png Duvida 3.png Duvida 4.png Duvida 5.png Duvida 6.png Duvida 7.png Duvida 8.png Duvida 9.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Where do you deploy your API?

Based on the error message that you mentioned, it seems to tell that PowerApps could not send a POST request to your API server.

Please check if you have configured a port your API server, if yes, please consider modify the Host value within your custom connector as below:

www.erp.ladder.com.br:Port Number

Also please check if you have enabled the Remove Server connect functionality for your API Server. Please also check and see if the following article would help in your scenario:

https://dwmkerr.com/publish-web-web-deploy/

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft

is a rest api using standard port 80,

the API works perfectly in POSTMAN, but powerapps is giving this error

follows image attachment of the functioning of the api

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I talked to my developer and he said that the requests arrive, but lack the body in JSON format

KeyError at /api/erp/saldo-estoque-ladder/ ‘produto’

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the Request Body of your Post Request in your custom connector?

Do you specify the data transfer format within the Headers part of the Post request within your custom connector?

On your side, please consider specify the data transfer format within the Headers part of the Post request within your custom connector as below:

Content-Type application/json Accept application/json

then save your custom connector, try it again, check if the issue is solved.

In addition, you could also consider take a try to create a OpenAPI definition file for your Rest API, then create a custom connector based on the OpenAPI definition file, check if the issue still exists.

More details about creating custom connector in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/register-custom-api

Best regards,

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I solved the problem

release the external remote access in api server.

thanks

Was this reply helpful? Yes No