Scenario

Fetching a Specific Item from a SharePoint List

Objective

You want to retrieve the details of a specific item from a SharePoint list based on the list name and item ID stored in variables.

Steps:

  • Identify the List and Item: You have a SharePoint site with multiple lists, and you need to fetch the details of a specific item from a list. The list name and item ID are stored in variables VarListname and VarItemID respectively.
  • Construct the HTTP Request: Use the SharePoint REST API to get the item details by specifying the list name and item ID in the URL.
  • Execute the HTTP Request: Make an HTTP GET request to the SharePoint REST API endpoint with the appropriate query parameters.
  • Set the value from the needed column in a variable.
Method: GET

Uri: _api/web/lists/getbytitle('@{variables('VarListname')}')/items(@{variables('VarItemID')})/

Headers:
  Accept: application/json;odata=verbose
  Content-type: application/json;odata=verbose

Bonus, how to do the same in Javascript:

const siteUrl = "https://your-sharepoint-site-url";
const listName = "Project Documents"; // Example list name
const itemId = 1; // Example item ID

fetch(`${siteUrl}/_api/web/lists/getbytitle('${listName}')/items(${itemId})`, {
  method: "GET",
  headers: {
    "Accept": "application/json;odata=verbose"
  }
})
.then(response => response.json())
.then(data => {
  const item = data.d;
  console.log(`Item ID: ${item.Id}`);
  console.log(`Item Title: ${item.Title}`);
  // Add more fields as needed
})
.catch(error => console.error('Error fetching item:', error));

Explanation

The fetch function sends an HTTP GET request to the SharePoint REST API endpoint. The getbytitle method is used to specify the list by its title. The items method is used to specify the item by its ID. The response is parsed as JSON, and the item details are logged to the console.