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.
Discussion posts and replies are publicly visible
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
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 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}
{ "id": "12345", "name": "Document.pdf", "size": 1048576, "file": { "mimeType": "application/pdf", "hashes": { "sha256Hash": "abc123..." } } }