Reference how to interact with the Mail REST API that provide access to folders, email messages, and email attachments. Understanding Share. Points REST and Search API Part 1 Selecting Items. Share. Point 2. 01. REST API that exposes plenty of information about users, lists and document libraries. For front end developers, this is a gold mine. A gold mine because of two things 1 Share. Welcome to the Visual Studio Team Services REST API Reference. Representational State Transfer REST APIs are service endpoints that support sets of HTTP operations. Dagfinn. Thanks for a comprehensive treatment to this topic. I am sure it would benefit a lot to everyone interested in SAP NetWeaver Cloud. For testing the REST api. Points out of the box UI is pretty bad, and 2 Share. Points out of the box UI is pretty bad. Update 32. 01. 7 Ive added Search API to this post as well. Continue reading below. So plenty of room for improvement here. TestingReadString.jpg' alt='Update List Item Rest Api Best' title='Update List Item Rest Api Best' />Now we can basically recreate Share. Points front end entire new CRUD interfaces and such. And the base of it all is its REST API. It is important to recognize that Share. Point REST API is using OData, which is a widely used convention when in comes to RESTful web services. You can learn more about the syntax from their website. For this post I would like to cover Selecting Items. Note that I prefer using j. Connect 4 Program Python Dummies more. Querys. ajax method. So all my calls will look like below. THE ENDPOINT. headers Accept applicationjson odataverbose. RESULTS HERE. THE ENDPOINT   method GET,   headers Accept applicationjson odataverbose,   success functiondata        console. RESULTS HERE   All were doing is replacing the url. A special note on SP 2. The only difference Ive seen is the endpoint part of the url. SP 2. 01. 0 has below. Selecting all items, all columns. The simplest way to grab list items is to get everything. This is done by using the endpoint below. Simply change the list value to your own. Itemsselect1apiweblistsgetbytitlelistnameItemsselectgain, this will select almost all columns that are available to the list. Note that I said almost, because Share. Points REST API doesnt really bring back everything. Things such as author information and values of lookups have to be queried differently more on this below. Selecting all items, custom columnsI find it good practice to only grab the columns that I need. This makes the payload as lean as possible. ItemsselectID,Title. ItemsselectID,Title. This also makes it easier to find things because each Javascript object only contain the columns ID and Title. What I dont understand is why ID and Id is present maybe a configuration error with the list. But nevertheless, the result is more manageable 3 Getting the total items in a list. To get the number of items in a list, append the Item. Count in the end of your query sting. NameItem. Count. NameItem. Count. I know that you can simply do a. The output looks like below 4 Retrieving specific list items. Now this endpoint will only get the list item with the ID of 4 Ive removed the sp. Page. Context. Info. Absolute. Url component for easier read. A more powerful solution is using the filter key. Not that this option allows you to get items with more flexibility. Check out this example which grabs items with the title equals to example 1. Note the use of single quotes Almost all values in Share. Point REST use single quotes ItemsselectTitle amp filterTitle eq example 11apiweblistsgetbytitlelistnameItemsselectTitle amp filterTitle eqexample 15 Multiple filter keys values. To get items that have Title that is equal to multiple values, use the endpoint below. ItemsselectTitle amp filterTitle eq example 1 or Title eq example 21apiweblistsgetbytitlelistnameItemsselectTitle amp filterTitle eqexample 1orTitle eqexample 2Notice that I used parenthesis to enclose the multiple parameters. This is completely optional but improves readability. In the case of multiple ANDs and ORs, for a stricter and finer result set, you need to use the parenthesis to enclose filter sets. This example below. List. NameItems amp selectTitle amp filterContent. Type eq Operating Policy or Content. Type eq Procedure and Subject eq Safety1apiweblistsgetbytitleList. NameItems amp selectTitle amp filterContent. Type eqOperating PolicyorContent. Type eqProcedureandSubject eqSafetyYou see how were grabbing items with Content. Type equaling to Operating Policy OR Procedure AND Subject equaling to Safety. Using startswith and substringof functions with filter. At times you need a more powerful filter in Share. Point REST API. See eq will only retrieve exact matches. If you want to get everything that starts with test, you use the startswith function. List. NameItemsfilterstartswithcolumn,test1apiweblistsgetbytitleList. NameItemsfilterstartswithcolumn,testNote that the column is the first parameter, then the value This is a mistake that Ive done several times because the documentation is pretty weak. Now, if you want to get items that contains specific characters, you use the substringof function. List. NameItemsfiltersubstringoftest,column1apiweblistsgetbytitleList. NameItemsfiltersubstringoftest,columnUnlike startswith, the substring takes the value first, then the column. Again, note the difference between the two. Limiting your results. The top parameter basically limits your items to a specified number. The syntax is below. ItemsselectTitle amp top1. ItemsselectTitle amp top1. This is also useful for creating paging systems in combination with an offset option below. Offsetting results for pagingSo you know how to limit your results, and you know how to get the total items. All you need is to offset your results. You do this with the skip parameter. Itemstop1. 0 amp skip2. Itemstop1. 0 amp skip2. Again, note the use of single quotes. The above will get a set of 1. Combined with the total, you can create your own paging mechanism. Update 81. 02. 01. I just found out that the skip parameter doesnt work with list items. There is a property in the REST response that you can use for paging. This is known as the next. I will do another tutorial strictly on this subject so stay tuned. Getting the Author Information. You have to specify that using the expand key. Also an additional parameter to the select key is needed. For example, to grab the Id and the name of the author, simply append to your query. ItemsselectAuthorTitle,Comment amp expandAuthorTitle. ItemsselectAuthorTitle,Comment amp expandAuthorTitle. The above will return the author information in its own node called Author. Document Libraries. Share. Point REST API supports querying document libraries. Remember, doc libs are also lists and for the most part, are handled through the same endpoint. Document Library NameItemsselectTitle,File. Leaf. Ref,Encoded. Abs. Thumbnail. Url,Encoded. Abs. Url. 1apiweblistsgetbytitleDocument Library NameItemsselectTitle,File. Leaf. Ref,Encoded. Black Sabbath Deluxe Edition Blogspot. Abs. Thumbnail. Url,Encoded. Abs. Url. The example above returns information about your file such as the name, full url and the internal Title For instances where you want to know the type of document library it is example Picture Library vs Document Library, use. Document Library NameBase. Template. 1apiweblistsgetbytitleDocument Library NameBase. Template. Although some information regarding document libraries require an entirely new endpoint. This includes file paths, subfolders, thumbnails and such. Get. Folder. By. Server. Relative. UrlFolder NameFiles.