cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbgoh
Helper V
Helper V

No data return from custom API

Hi,

I created a custom connector and when I tested it, I can get the results as shown below:

sbgoh_0-1625112651848.png

However, when I call it via PowerApps, there is no results return. 

I have added that connector in my powerapps. There is no error too.

What could be missing?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @sbgoh ,

 

 

Let's go back to the beginning.

Please try to copy the result's body.

vxiaochenmsft_0-1627886944812.png

vxiaochenmsft_1-1627887140536.png

vxiaochenmsft_2-1627887155997.png

vxiaochenmsft_3-1627887177939.png

 

Then please try to delete your connection and recreate a connection again.

 

Best Regards,
Wearsky

 

 

View solution in original post

7 REPLIES 7
v-xiaochen-msft
Community Support
Community Support

Hi @sbgoh ,

 

Please try to remove the connection in your canvas and delete your connection.

Then please try to recreate a connection and add it in canvas again.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

Hi Wearsky,

 

I have removed and add back the connector to the canvas apps but still no data is displayed.

I also tried to create new canvas apps and add the new custom connector. Still no data.

Here is my formula:

ClearCollect(colIps,'WQ-LocalAPI_IPS'.GetInstantPrice({bizUnit:"CHINA", mfr:"ABC", fullMfrPart:"LM3333A", currency:"USD", requestQty:1000, employeeId:"90000"}));

 

sbgoh_0-1625117264508.pngsbgoh_1-1625117289787.png

 

v-xiaochen-msft
Community Support
Community Support

Hi @sbgoh ,

 

This is a strange phenomenon.

Since this is your custom api, it is difficult for me to test it for you..

If it continues to have the problem, I suggest you try this method:

Powerapps triggers flow, then flow calls this api and returns to powerapps.

vxiaochenmsft_0-1625118769004.png

Maybe it can return data for you.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

I created my flow with the custom connector but when I want to add it to my canvas, there is error. Is this a bug or my flow issue ?

sbgoh_0-1625125164001.png

sbgoh_1-1625125236339.png

 

v-xiaochen-msft
Community Support
Community Support

Hi @sbgoh ,

 

 

Let's go back to the beginning.

Please try to copy the result's body.

vxiaochenmsft_0-1627886944812.png

vxiaochenmsft_1-1627887140536.png

vxiaochenmsft_2-1627887155997.png

vxiaochenmsft_3-1627887177939.png

 

Then please try to delete your connection and recreate a connection again.

 

Best Regards,
Wearsky

 

 

View solution in original post

Hi @sbgoh did you ever resolve this issue? I'm having the same problem with my custom connector returning no data. It does work when I add the connector to a Flow, but not in the test function in the custom connector designer, or when I try to use the connector in a canvas app. I can make the same API call in Postman and it returns data.

Thanks,

Greg

Hi it is not working so I did not use flow.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,318)