Generate JSON Payload Using MS Flow

To get the payload data from SharePoint Online, a developer needs to use either Postman or Custom Scripts. Usually, it’s a part of the solution or API. However, in some scenarios, developers need to use a payload outside the custom solution. Then, it’s not feasible to write a custom code or use Postman using the Client ID and Client Secret to get the payload or JSON response.

MS Flow is one of the easiest and quickest alternatives to get the JSON response from a SharePoint Online request. JSON response, i.e., the payload, can be used to identify the structure format, which helps to parse the data accordingly.

We can create a 3-step (trigger + action) flow that allows us to send an email quite securely (no need to handle the password separately).

Generate JSON Payload Using MS Flow 

Let’s explore how MS Flow is the quickest and easiest turnaround.

Step 1

Log in here with authorized credentials.

Step 2

Select My Flows -> New -> Create from blank.
 
 Generate JSON Payload Using MS Flow

Step 3

To start with the flow, we need to set the trigger point. So, I used recurrence as the trigger point to demonstrate.
 
Generate JSON Payload Using MS Flow 

Frequency can be set as per the requirement; I set it to 1 minute for demo purposes.

Step 4

Generate the payload for HTTP Request, i.e., Group Details - Group Name, “Approver” with the email selection.
 
 Generate JSON Payload Using MS Flow

Step 5

Send an email with the payload body.
 
Generate JSON Payload Using MS Flow

Step 6

Save and wait for a minute. Also, you can trigger it manually.

Check your email account. You must have received a JSON payload with the data on the defined email address.

Generate JSON Payload Using MS Flow
 
Example
  1. {  
  2.     "d": {  
  3.         "results": [{  
  4.             "__metadata": {  
  5.                 "id""https://mittal1201.sharepoint.com/sites/CommSite01/_api/Web/GetUserById(16)",  
  6.                 "uri""https://mittal1201.sharepoint.com/sites/CommSite01/_api/Web/GetUserById(16)",  
  7.                 "type""SP.User"  
  8.             },  
  9.             "Email""[email protected]"  
  10.         }, {  
  11.             "__metadata": {  
  12.                 "id""https://mittal1201.sharepoint.com/sites/CommSite01/_api/Web/GetUserById(6)",  
  13.                 "uri""https://mittal1201.sharepoint.com/sites/CommSite01/_api/Web/GetUserById(6)",  
  14.                 "type""SP.User"  
  15.             },  
  16.             "Email""[email protected]"  
  17.         }]  
  18.     }  
  19. }  

To verify the result, I have SP Group with two users. I have got the same in the above email.

Generate JSON Payload Using MS Flow 
 
That's it. I hope this article is helpful to you. Happy Coding!!!