Power Pages

Cannot retrieve File column content using Webapi

(0) Share

Report

Posted on by salesmaster

Hi,

I am trying to get the file content from the file type column in dataverse to my Power pages portal.

I have followed the documentation -

1. Created Webapi site setting to enable it (Webapi/sm_candidate/enabled)

2. Created a site setting for fields (Webapi/sm_candidate/fields with value sm_name,sm_domicile)

3. Using the below code to fetch the data -

webapi.safeAjax({
        type: "GET",
        url: "/_api/sm_candidates("+ id +")/sm_domicile",
        contentType: "application/json",
        success: function (data, textStatus, xhr) {
            var fileContent = data["value"]; // Base 64
            var fileName = "file.bin"; // default name
        },
        error: function (xhr, textStatus, errorThrown) {
            console.log(xhr);
        }
    });

But it is giving me error like -

{
  "error": {
    "code": "90040101",
    "message": "Attribute * in table sm_candidate is not enabled for Web Api."
  }
}

When I cbange the value of Webapi/sm_candidate/fields site setting to '*'. It works.

Not sure what I am doing wrong here.

Categories:

Customize & extend

All responses (2)

Answers (0)

Sort by

Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue stems from how the Web API site settings are configured in your Power Pages portal. The error message indicates that the attribute (sm_domicile) in your Dataverse table (sm_candidate) is not explicitly enabled for Web API access.

The site setting Webapi/sm_candidate/fields defines which attributes (columns) in the sm_candidate table are accessible through the Web API. You must include sm_domicile in this setting. sm_name,sm_domicile

let me know if you need more details.
salesmaster 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@SaiRT14 I have it in my site setting already as you can see in point 2.