cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aadilganie
Level 8

Retrieve data using custom API

Hi!

 

We are trying to retrieve data from our MIS which is based in the cloud. Their API uses the BATCH API and to access a specific dataset an APIKey has to be appended to the URL which gives you access to the data and actually shows it to you whether authenticated or no

 

Im not a developer but was hoping someone could point me in the right direction.

 

The URL looks like so:

https://example.company.cloud/api/batch/1.0/xml.ashx?apiKey={D3C8E44K-454D-4RED-B4G6-935A78C353S9}

 

The XML parameter can also be changed to json.ashx to display results in JSON format.

 

I have tried with postman and swagger and have read the files on the powerapps docs but dont seem to be getting any luck. Anyone know of another resource or can assist in any way?

 

Thanks in advance!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Retrieve data using custom API

Hi @aadilganie,

 

Could you please share a bit more about the MIS that you mentioned?

Do you want to access a specific dataset using the URL that you provided within your PowerApps app?

 

If you want to access a specific dataset using the URL that you provided within your PowerApps app, I afraid that there is no way to achieve your needs in PowerApps app currently.

 

You could consider take a try to create a custom connector within your PowerApps, then use the custom connector to access the specific dataset. More details about creating a custom connector in PowerApps, please check the following article:

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

 

In addition, please also check if you have requested a proper URL on your side. Please also take a try to modify your Custom API as a JSON file and call the API as below:

https://example.company.cloud/api/batch/1.0/sample.json?apiKey={D3C8E44K-454D-4RED-B4G6-935A78C353S9}

The sample of a OpenAPI Definition as below:

https://procsi.blob.core.windows.net/docs/SentimentDemo.openapi_definition.json

 

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aadilganie
Level 8

Re: Retrieve data using custom API

Hi @v-xida-msft

Thanks for you message and apologies for the delayed reply.

 

The MIS is actually a cloud based school information system that stores information about students, teachers etc and all data in between.

 

The school has access to generate an API key for each area they would like to give you access to. So basically the the API key generated would only give you access to a specific dataset anyway.

 

I did try to connect a custom API using Postman but I think I may be getting something wrong.

 

 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 53 members 4,631 guests
Please welcome our newest community members: