how to get document file size, extension details from sharepoint integration

Hi [mention:7bd80d20e8d5464ba14fd461c9056f13:e9ed411860ed4f2ba0265705b8793d05]  AFAIK you will not be able to find document data for its size, extension Appian does not directly expose file metadata like size and extension when retrieving a document. May be you need to use some Microsoft Graph API

Unsure on how to do it with the built in connector. But perhaps you can try the regular HTTPS connector with the SP REST API.

learn.microsoft.com/.../working-with-folders-and-files-with-rest

Hi [mention:7bd80d20e8d5464ba14fd461c9056f13:e9ed411860ed4f2ba0265705b8793d05] ,

I would suggest you to use Microsoft Graph API, as we can get the required custom properties of a file easily.

The Microsoft Graph API provides detailed metadata, including file size, extension, and other properties.

Endpoint will be: GET

https://graph.microsoft.com/v1.0/sites/{site-id}/drives/{drive-id}/items/{item-id}

{
  "id": "12345",
  "name": "Document.pdf",
  "size": 1048576,
  "file": {
    "mimeType": "application/pdf",
    "hashes": {
      "sha256Hash": "abc123..."
    }
  }
}