3

Is there a way to write the service call in example A to get the file properties in example B? Currently the folder isn't a named list. If it were would that help?

This question is similar to: Is it possible to GET a list of Files in a document library with "extended properties". I'm using the answer, but still not getting the properties I want in one pass. I have to call example B for every file.

File properties - example A:

_api/web/GetFolderByServerRelativeUrl(<folderpath>)/Files?$expand=Properties

<m:properties>
  <d:CheckInComment /> 
  <d:CheckOutType m:type="Edm.Int32">2</d:CheckOutType> 
  <d:ContentTag>{9D4E82A3-EBF0-4A29-BCF5-1B10951901D1},6,10</d:ContentTag> 
  <d:CustomizedPageStatus m:type="Edm.Int32">0</d:CustomizedPageStatus> 
  <d:ETag>"{9D4E82A3-EBF0-4A29-BCF5-1B10951901D1},6"</d:ETag> 
  <d:Exists m:type="Edm.Boolean">true</d:Exists> 
  <d:Length m:type="Edm.Int64">82805</d:Length> 
  <d:Level m:type="Edm.Byte">1</d:Level> 
  <d:MajorVersion m:type="Edm.Int32">3</d:MajorVersion> 
  <d:MinorVersion m:type="Edm.Int32">0</d:MinorVersion> 
  <d:Name>O0032C - Decline letter.docx</d:Name> 
  <d:ServerRelativeUrl>/sites/s3vdfnl/docs/general/S0032/O0032C - Decline letter.docx</d:ServerRelativeUrl> 
  <d:TimeCreated m:type="Edm.DateTime">2015-04-09T12:45:11Z</d:TimeCreated> 
  <d:TimeLastModified m:type="Edm.DateTime">2015-04-09T12:45:11Z</d:TimeLastModified> 
  <d:Title>Decline Letter NL</d:Title> 
  <d:UIVersion m:type="Edm.Int32">1536</d:UIVersion> 
  <d:UIVersionLabel>3.0</d:UIVersionLabel> 
  </m:properties>
<m:properties>

File properties - example B:

_api/web/GetFileByServerRelativeUrl(<filepath>)/ListItemAllFields?expand=Properties"

<m:properties>
    <d:FileSystemObjectType m:type="Edm.Int32">1</d:FileSystemObjectType>
    <d:Id m:type="Edm.Int32">8</d:Id>
    <d:Title m:null="true" />
    <d:ID m:type="Edm.Int32">8</d:ID>
    <d:ContentTypeId>0x0120006AEEB7D3E4E35F49A2777DEF7274B7E9</d:ContentTypeId>
    <d:Created m:type="Edm.DateTime">2015-01-23T22:56:12Z</d:Created>
    <d:AuthorId m:type="Edm.Int32">11</d:AuthorId>
    <d:Modified m:type="Edm.DateTime">2015-01-23T22:56:12Z</d:Modified>
    <d:EditorId m:type="Edm.Int32">11</d:EditorId>
    <d:OData__CopySource m:null="true" />
    <d:CheckoutUserId m:null="true" />
    <d:OData__UIVersionString>1.0</d:OData__UIVersionString>
    <d:GUID m:type="Edm.Guid">c7093817-f264-4e85-845c-4989aa66e142</d:GUID>
    <d:md7package m:null="true" />
</m:properties>
  • Robert, i revised the question to make it more clear. I saw the duplicate post you were referring to and variations on the answer haven't helped either. I also have tried the suggestions in this post too: sharepoint.stackexchange.com/questions/138135/… – steve Aug 30 '15 at 3:22
9

You probably want this query: /_api/web/getfolderbyserverrelativeurl('<url>')/Files?$expand=ListItemAllFields

It will return files properties along with associated list item properties.

  • 2
    Winner, winner! Thank you so much Vadim. That works just the way I want it to. – steve Aug 31 '15 at 17:47
  • 1
    Steve, i'm glad it helped you! – Vadim Gremyachev Aug 31 '15 at 18:09
  • 1
    Why does it have only one upvote? – Denis Molodtsov Mar 24 '16 at 19:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.