Answered

Custom Connector (GET method) with API Key showing no results in Collection

(0) Share

Report

Posted on by Dhanushka_Aus

Hi All,

I'm using Custom Connector to Call our internal system's GET API, which provides all the programs a staff member is registered to when we give a staff ID. We have a security Token, which I'm using as the API Key. API showed 200 response after I provided Staff ID, API Key, and Enterprise ID (which is constant).

So I followed below;

Crated a custom Connector (XX Connect) - Since I'm getting only program Key and Name, i used the Response Body given is the documentation:

{

"Key":"123"

"Value":"abacr"

}

Custom Connector action is GetPrograms(StaffID,EnterpriceID)

2) Once all this is done I tested it and it gave me 200 response (Refer attached custom Connector test result"). Got 3 values to it.

3) I did a small program, when I press the button, it will pass Staff ID and Enterprise ID, and try to get the collection. I used the same values I used for the step 2, which was successful test.

Powerapp loaded and it showed it executed, but as attached, when I check the Collection, it shows a BLANK table with "Key","Value" headings. ☹️ I now spent about 2 days and still no luck.

Can anyone please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Dhanushka_Aus ,

Do you mean that the custom connector action could return proper results when you test it, but it could not populate a collection within your canvas app?

Based on the first screenshot that you mentioned, it seems that the results from your custom connector action is a Table value rather than a Object value, so when you specify the JSON Schema within the Response Body, you should specify the following sample JSON Schema (type Object Array rather than Object😞

[ { "Key": "123", "Value": "abacr" }, { "Key": "456", "Value": "efdgyy" } ]

Please consider take a try with above solution to re-configure your custom connector action Body Response and re-publish it, then re-create a new connection to your custom connector from your canvas app, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Dhanushka_Aus 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft,

Awesome and thank you so much. Your solution made the application work and collection gathered. Thank you so much.😊👍

Best regards
Dhanushka

Was this reply helpful? Yes No