Answered

Custom connection - how to create response type and build connection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

If I test my custom connector (built from importing postman); I get the following response

{
"storedFiles": {
"20190910": [
"ft_leavers",
"co_hours"
]
},
"success": true
}

How do I
1) Create a response in JSON that will let me read the data

2) Create a collection to read all the data - at the moment, only 'True' comes back when I build a collection;

ClearCollect(FTCollection, fT.Storagefiles())

Please and thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

To get the response in PowerApps, you need to set the default response in the custom connector definition. For doing so:

1) Open the custom connector action for which you want to set the response schema.

2) Scroll down and select Add default response. Paste the returned response in the body to generate schema for you.

3) Save the connector.

4) Remove the connection to custom connector in your powerapps, and add it again.

5) Use the expression:

ClearCollect(FTCollection, fT.Storagefiles())

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much!
Only issue is I have an object in my response as well; Is there a way of showing the data from the object?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

Yes, you can use do that by:

If you want to fetch a key out of the object, then you can use:

ThisItem.storedFiles.Name

Here, you need to update the Name with the column you want to display.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like
a
(0)

Report
Copy link

Link copied!

I am getting the error message below

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Anonymous

This is because the 20190910 is a array type response. To show all the values, separated by comma, you can use the below expression:

Concat(ThisItem.storedFiles.20190910, Value, ",")

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much!

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Is-there-a-timeout-for-API-Calls/m-p/372339

I had this other question about timeouts, can you advise on the above at all?

Really appreciate your help.

Jese

Was this reply helpful? Yes No