Sharepoint list item using the Microsoft Graph API and Postman

-

 

To retrieve a list item using the Microsoft Graph API and Postman, you'll need to follow these general steps. I'll provide a basic example, but keep in mind that you may need to adjust the details based on your specific use case and the permissions you have.

Prerequisites:

  1. Register an App in Azure AD:

    • Go to the Azure Portal.
    • Navigate to Azure Active Directory -> App registrations -> New registration.
    • Note down the Application (client) ID and Directory (tenant) ID.

  2. Create Client Secret:

    • In the App registration, go to Certificates & Secrets.
    • Create a new client secret and note down the Value.

  3. Grant API Permissions:

    • Go to API permissions and grant the necessary permissions (e.g., Sites.ReadWrite.All for SharePoint).

  4. Get Access Token:

    • Use the client ID, client secret, and tenant ID to get an access token. You can use the OAuth 2.0 authorization code flow or client credentials flow. For simplicity, I'll use the client credentials flow here.
    http
    POST https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token

Headers:
Content-Type: application/x-www-form-urlencoded

Body:
grant_type=client_credentials
&client_id={client-id}
&client_secret={client-secret}
&scope=https://graph.microsoft.com/.default

    Replace {tenant-id}, {client-id}, and {client-secret} with your actual values.

    Extract the access_token from the response.

Retrieve a List Item:

Now, you can use the access token to make a request to the Microsoft Graph API to get a list item.

http
GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id}/items/{item-id}

Headers:
Authorization: Bearer {access-token}

Replace {site-id}, {list-id}, and {item-id} with your actual values.

Example Request in Postman:

  1. Open Postman.
  2. Create a new request.
  3. Set the request type to GET.
  4. Enter the URL with the appropriate placeholders.
  5. Add the Authorization header with the value Bearer {access-token}.

Send the request, and you should receive the details of the specified list item.

Remember to adjust the permissions, endpoints, and other details based on your specific Microsoft 365 environment and requirements.


To get the List ID (GUID) from SharePoint Online (SPO), you can use the SharePoint REST API or Microsoft Graph API. Here's an example using the SharePoint REST API:

  1. Get the Site ID: You need to start by getting the Site ID. You can use the following endpoint:

    http
    GET https://<your-spo-url>/_api/site?$select=Id

    Replace <your-spo-url> with the URL of your SharePoint site.

    This will return the Site ID in the response.

  2. https://6yhvfv.sharepoint.com/sites/Compass/_api/site/id
https://6yhvfv.sharepoint.com/sites/Compass/_api/site/id

  1. Get the List ID: Once you have the Site ID, you can use it to get the List ID. You need to replace <your-site-id> with the actual Site ID in the following endpoint:

    http
    GET https://<your-spo-url>/_api/web/lists/getbytitle('<your-list-title>')?$select=Id

    Replace <your-spo-url> with the URL of your SharePoint site and <your-list-title> with the title of your SharePoint list.

    This will return the List ID (GUID) in the response.

Example in Postman:

  1. Open Postman.

  2. Create a new request.

  3. Set the request type to GET.

  4. Enter the URL for getting the Site ID.

  5. Add any necessary headers for authentication.

    Send the request, and extract the Site ID from the response.

  6. Use the Site ID to construct the URL for getting the List ID.

  7. Send another request to get the List ID.

Remember to replace placeholders like <your-spo-url> and <your-list-title> with your actual SharePoint Online URL and list title.

Note: Microsoft is continuously updating and evolving its APIs, and there may be changes or improvements after my last knowledge update in January 2022. Please refer to the latest SharePoint REST API documentation or Microsoft Graph API documentation for the most up-to-date information.

Comments

Post a Comment

Popular posts from this blog

Sites.Selected | Graph API SharePoint Permission

-
Image
  SharePoint Site Collection Permission   The "sites.selected" permission in Microsoft Graph API allows you to grant an application access to specific SharePoint sites instead of all SharePoint sites in the tenant.   Step1: To   Configure "Sites.Selected" Permission in Azure App Registration To use "sites.selected" , you need to: Register an App in Azure AD . Grant "Sites.Selected" Permission to the app. Manually Grant Access to the specific SharePoint site. Use Microsoft Graph API or PowerShell to assign the required role (Read/Write).   Step 1: Register an App in Azure AD Go to Azure Portal → Azure Active Directory → App Registrations . Click New registration . Provide a name (e.g., SharePointAccessApp). Choose Accounts in this organizational directory only . Click Register . Step 2: Add "Sites.Selected" API Permission Navigate ...
Read more

Configure the SharePoint Online App Catalog

-
Image
  You can create an Sharepoint Online app catalog site collection in few simple steps: Sign into Office 365 as a global admin or SharePoint admin. Select the app launcher icon   in the upper left and choose  Admin  to open the Office 365 admin center (if you don’t see the Admin tile, you don’t have Office 365 administrator permissions in your organization). In the left pane, choose  Admin centers  >  SharePoint .  Click on  ‘More Features’  from the left navigation/pane. Now, click on the  ‘Open’  button under Apps. Select  apps  in the left pane, and then select  App Catalog. Select  Create a new Sharepoint app catalog site , and then select  OK . On the Create App Catalog Site Collection page, enter the required information, and then select  OK . An app catalog site collection has been created.  Once the App Catalog site collection is created successfully, click on the new link to th...
Read more

Azure Function | Sharepoint List item | Call from Power Automate Flow

-
  🔹 Steps to Set Up an Azure Function for SharePoint List Item Creation 1️⃣ Create an Azure Function App Go to Azure Portal → Function Apps → Click Create . Choose: Subscription : Select your subscription. Resource Group : Create a new one or use an existing one. Function App Name : Enter a unique name. Runtime Stack : Choose .NET , Python , or Node.js . Region : Select a preferred region. Plan Type : Choose Consumption (Serverless) . Click Review + Create → Then Create . 2️⃣ Create a New Function Inside the Function App Open your Function App → Click Functions → + Add Function . Choose HTTP Trigger (for now, Power Automate will trigger this function). Name your function (e.g., SharePointNewItemTrigger ). Set Authorization Level to Function . Click Create . 3️⃣ Get SharePoint List Data Using Microsoft Graph API Since Azure Functions cannot directly detect SharePoint list changes, we use Power Automate to send data when an item is added. Modify the...
Read more