Hero Image
Blog series - Conclusion

Conclusion So, there are a lot of HTTP calls that can be done. I’ve touched upon a few,. And hopefully you’ve gained a bit more insight in how these work. Some takeaways If you do a lot of HTTP calls in a single flow, there might be a cache issue poking around, resulting in double updates. When you use Term Store values to update, it wont show in the version history. (work around is to append them to a multiple line text field, but this results in a double entry in version history)

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - Get term store (for content types)?

Scenario: Fetching Terms from a Specific Term Set in a Term Store Objective You want to retrieve all terms from a specific term set within a term store in SharePoint. The term store and term set are identified by their unique GUIDs. Steps: Identify the Term Store and Term Set GUIDs You have a SharePoint site with a managed metadata service, and you need to fetch all terms from a specific term set. The term store GUID is TERMSTOREGUID and the term set GUID is GROUPGUID.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Best practises

Best practises Here are some best practises I found either online or discovered myself. Use the Appropriate HTTP Method Always choose the correct HTTP method for your operation. Use GET for retrieving data, POST for creating new resources, PUT for updating existing resources, and DELETE for removing resources. This helps maintain clarity and consistency in your code. Set Proper Permissions Ensure that you have the necessary permissions for the operations you intend to perform. This includes configuring the appropriate access levels for users and applications. Proper permissions help prevent unauthorized access and maintain data security.

Thursday, February 20, 2025 | 3 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Call a flow from a button

JSON formatting on a sharepoint list? In this blog post, we’ll explore the powerful capabilities of JSON list formatting in SharePoint. JSON formatting allows you to customize the appearance of your lists and libraries, making them more user-friendly and visually appealing. We’ll cover how to get a flow identifier, add a column, set JSON formatting code, and additional button formatting options such as showing/hiding based on fields and permissions. Get Flow Identifier To begin, you’ll need to get the flow identifier for the specific flow you want to use. This identifier is essential for linking your JSON formatting to the flow. You can find the flow identifier in the URL of your flow in Power Automate. Simply navigate to your flow, and copy the identifier from the URL.

Thursday, February 20, 2025 | 3 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Fetching Specific List Information

Scenario Fetching Specific List Information Objective You want to retrieve the ID and Title of a specific SharePoint list whose title matches a given name. Steps: Identify the List Title: You have a SharePoint site with multiple lists, and you need to fetch the ID and Title of a list named “Project Documents”. Construct the HTTP Request: Use the SharePoint REST API to filter the lists by title and select only the ID and Title fields. Execute the HTTP Request: Make an HTTP GET request to the SharePoint REST API endpoint with the appropriate query parameters. Method: GET Uri: _api/web/lists?$filter=Title eq 'name'&$select=Id,Title Headers: Accept: application/json;odata=verbose

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Free vs Premium?

Short overview - when to need a premium license and when not When can you get away with Power Automate free, and when do you need premium when working with http calls? Feature Free Premium Sharepoint HTTP request X Triggers X For a selected item x For a selected file X When an HTTP request is received X HTTP request X

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Get - Http get library id by GUID?

Scenario Fetching a Specific List by Library ID Objective You want to retrieve the details of a specific SharePoint list using its unique Library ID stored in a variable. Steps Identify the Library ID You have a SharePoint site with multiple lists, and you need to fetch the details of a list using its unique Library ID. The Library ID is stored in the variable VarLibraryID. Construct the HTTP Request Use the SharePoint REST API to get the list details by specifying the Library ID in the URL.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Get - Http get version number

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:

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Permissions

Permissions needed During my testing, I had SharePoint administrator access with full control on the lists, so I could do anything. For most of the calls, I recommend getting SharePoint administrator access to avoid any issues. Known Error: If the API call throws an error indicating that you’re not authorized, it doesn’t always mean you don’t have the correct permissions. It could mean you’re attempting to make an API call to an area of SharePoint that’s not allowed to be called. For example, if you’ve made a typo somewhere or aren’t using the correct type of call.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - HTTP calls to Sharepoint - Types in Sharepoint

Using the SharePoint REST API to Update Metadata Fields When working with SharePoint REST API, you might need to update a metadata field that originates from a content type. To do this, you first need to get the type value from your library. This type value is essential for making the correct HTTP call to update the metadata field. Step 1: Get the Library Type Value After making a GET request to your library API, you will receive a response body that contains various details about your library. One of the key values you need to extract is the type, which is usually in the format SP.Data.listname. This type value is required to update the metadata field.

Thursday, February 20, 2025 | 3 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Why do I need X-request-digest?

What is it, and why do I need it? Think of it as a type of token, that allows you, or permits you, to modify files on Sharepoint through an HTTP request. When you use POST as your method, and need to use Merge in your header, you also need to include a request digest value. Without it, you’re not authorized to do this action. What it will look like to use it in a call;

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - HTTP calls to Sharepoint - Working with folders

Working with folders and the Sharepoint API When working with the SharePoint API, handling folders can sometimes be tricky, especially when dealing with deeply nested structures. In this post, we’ll explore how to dynamically grab the file location regardless of how deep it is in the root or folder structure. We’ll also cover how to handle common issues like permission errors. Dynamically Grabbing the File Location To work with folders in the SharePoint API, you need to use the full path. This ensures that you can dynamically grab the file location, no matter how deep it is within the root or folder structure. Here’s a step-by-step guide:

Thursday, February 20, 2025 | 2 minutes Read