Unanswered

Fetch API response and display in the power app

(1) Share

Report

Posted on by rapan062

I have an API: "https://xepst. javra.com/cgi-bin/wspd_cgi.sh/ WService=xePST-prod-web/js/jsread.p?call=wfh"

whose response is as follows:

Screenshot 2024-07-04 at 12.04.31 PM.png
I want to create a power app that displays all the employee name that are on work from home today i.e EmployeeDetails.UserInfo.WFHRecords.Date = today's Date

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (2)

Report

Hey @rapan062 ,

you have two possible ways to get this result.
You can create a custom connector inside the power platform to use it directly in the app.
Or you can use a flow. like this you could get around creating the connector and use the http request action. you could Then pass the table too power apps parse the Json and collect it into a collection.

you could then display the collection in a Gallery.

Let me know if you need further assistance.

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report

Hey @DBO_DV. I tried making a custom connector but the values of the values are not being recognized inside the app. Can you guide me through the entire process? I can not find out where the problem is.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Yes no problem Could you show me the collection that you receive from your conector?

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report

I have created my connector as follows:
In my power app, i connect the custom connector through add data. Now on the OnStart property i write following formula:
ClearCollect(
WFHData,
'XEPST API'.GetWFHRecords().EmployeeDetails.UserInfo
);
ClearCollect(
WFHToday,
ForAll(
WFHData,
{
EmployeeID: EmployeeID,
FullName: FirstName & " " & LastName,
WFHRecords: WFHRecords
}
)
);
ClearCollect(
WFHTodayRecords,
ForAll(
WFHToday,
ForAll(
WFHRecords,
{
EmployeeID: ThisRecord.EmployeeID,
FullName: ThisRecord.FullName,
Date: ThisRecord.Date,
WFH: ThisRecord.WFH,
WFHApproved: ThisRecord.WFHApproved,
WFHRemarks: ThisRecord.WFHRemarks
}
)
)
);
ClearCollect(
WFHTodayFiltered,
Filter(
WFHTodayRecords,
DateValue(Date) = Today() && WFH = true
)
);
the following error shows
'GetWFHRecords' is an unknown or unsupported function in namespace ' 'XEPST API' '.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Did you configure the response ?
If not it gets probably not recognized as a table. You can just import it from a sample
you can find it if you scroll a bit deeper then request.

Can you try this and let me know if it worked?

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report

If you cannot access above API. Let's try with another public API.
I also tried this API: https://datausa.io/api/data?drilldowns=Nation&measures=Population.
I made a custom connector 'PopulationDataConnector' with action 'GetPopulationData'.

and the response is also imported from sample response in the custom connector. I tested the custom connector and the result is as follows:

Now in the power apps, I inserted a button label. In the button's onSelect Property i wrote the following formula:

ClearCollect(populationCollection, PopulationDataConnector.GetPopulationData({drilldowns:"Nation",measures:"Population"}).data)

Following error is shown.
Yes, the connector is connected in the data section. Why is this error coming?

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Hey @rapan062 ,
Could you try this version?
ClearCollect(populationCollection, PopulationDataConnector.GetPopulationData({drilldowns:"Nation",measures:"Population"}))
If that does not work could you try putting it into a Variable?
Then probably it will not be recognized as a table.

We would have to look together how you've imported the response.

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report

In custom connector, I copied the API response and click import.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Have you tried my suggestion?

Was this reply helpful? Yes No
rapan062 on at

Like (1)

Report

Set(populationData, PopulationDataConnector.GetPopulationData({drilldowns: "Nation", measures: "Population"}));
ClearCollect(populationCollection, populationData)

As you suggested, I put the data in a variable. Still the same error is coming which is shown in above reply.

Was this reply helpful? Yes No