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

Question

I am trying to fetch document metadata from sharepoint Integration which I have bult using pre built sharepoint connected system by appian. As I am retrieving the data I could not find the document data for its size, extension etc how can I achieve this as I need the data to store document information in table.

Abhishek Karumuru · Answer

Hi aishwaryap610839 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

Mathieu Drouin · Answer

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

Varun Teja Gurrapu · Answer

Hi aishwaryap610839 , 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} Response will be in json : 
 {
 "id": "12345",
 "name": "Document.pdf",
 "size": 1048576,
 "file": {
 "mimeType": "application/pdf",
 "hashes": {
 "sha256Hash": "abc123..."
 }
 }
}
 - If Connected System does not support fetching metadata , create a separate Appian integration using the Microsoft Graph API . Hope this helps you!!!