How to retrieve records by Portal Web Api?

[shahriat]

I have a custom entity and have given permission through portal manager. Now I want to retrieve record from that custom entity using web api like following:

webapi.safeAjax({

        type: "GET",

        url: "/_api/custom_configurations",

        contentType: "application/json",

        success: function (res, status, xhr) {

            console.log(res);

        }

    });

but I'm getting 406 status code as response.

I need to access records from my angular app. How to do it in portal environment?

[OliverRodrigues · Accepted solution]

Hi

currently the Web API only supports Create/Update/Delete methods, please see more info from the documentation: Use the Web API for portals - Power Apps | Microsoft Docs

the reason for that is because we have other methods for retrieving data:

• via JS - oData: Dynamics Portals – Entity List – Integration using OData feed | Rajeev Pentyala - Microsoft power pl...
• via Liquid - FetchXML tag for retrieve multiple equivalent: Use template tags for a portal - Power Apps | Microsoft Docs
• via Liquid - Entities object for retrieve simple: Use Liquid objects for a portal - Power Apps | Microsoft Docs

what you can also do is creating your own retrieve API using custom Web Templates + FetchXML, take a look at this post that might help you: 

Creating a Custom Portal API to Retrieve Data | PowerObjects

[shahriat]

@OliverRodrigues  Thank you very much for your quick response.

I have tried the web api because I need to retrieve custom entity's record from my angular 9 app that I linked into my portal app. In this scenarios how can I get records from angular app?

[OliverRodrigues]

Hi, is your angular app inside Power Apps Portals? not sure how you are linking your app, can you give more details?

if your app still has access to Portal objects/pages or web templates, I would recommend using the Entities liquid object mentioned earlier.