Subscribe to my channel for more related videos https://www.youtube.com/LearnNow1
Praveen's CTO Blog
Subscribe to my channel for more related videos https://www.youtube.com/LearnNow1
Using Managed Identity to deploy azure resources is considered best practice as it reduces the overhead of keeping additional credentials (tokens/passwords) in config files. This article is about accessing Auzre KeyVault using Managed Identity. I am using .NET Framework 4.8 version for this tutorial.
Step 1 – Create KeyVault and secrets
First, just go to Azure Portal and create necessary secret values for testing. I would go with a “testkey” and a dummy value.
(I am assuming you know the basics of Azure Portal and knows how to create an azure resource such as KeyVault)
Also, please take a note of the “Vault URI” you can see in the “Overview” section. We would require it in the C# Code.
Step 2 – Create Sample .NET App
Next, open Visual Studio (I have used 2022) and start a new project. I have used a .NET Framework 4.8 Console Application.
Step 3 – Install necessary NuGet packages
We require two major packages for this project. Install these:
1. Azure.Identity
2. Azure.Security.KeyVault.Secrets
Step 4 – Coding!
This is the sample code I have used. Make sure to replace with your keyvault URL.
using System;
using Azure.Identity;
using Azure.Security.KeyVault.Secrets;
namespace kvtest
{
internal class Program
{
static void Main(string[] args)
{
SecretClient secretClient = new SecretClient(new Uri("https://your-keyvault.vault.azure.net/"), new DefaultAzureCredential());
var secret = secretClient.GetSecret("testkey");
Console.WriteLine(secret.Value.Value);
Console.ReadKey();
}
}
}
Notice the “DefaultAzureCredential()”, which does the trick of our Managed Identity, without providing plain credentials here.
Step 4 – Login to Azure
If you “run” your app at this stage, you will end up getting an error like the one below. This is because, currently you do not have any connection between your laptop and azure portal. This application will work if you host this in Azure, in any resources like App Service but you cannot run this in your developer laptop/machine if you want to debug.
To make your app debug-able in your machine, you have to let Visual Studio login to Azure.
Go to Tools –> Options –> Azure Service Authentication
and, login to your account there.
Step 5 – Execute!
Now we are all set for building and running the app. Just hit F5!
My use case here was to store the resumes uploaded by candidate in a website directly in a SharePoint list.
Below is the high level flow the process, created in Power Automate (same you can do in Azure Logic Apps as well with similar steps)
Here is the output, i.e., data and file uploaded to SharePoint/Office 365
The HTTP call is expected to be made from the external application such as a web page but for the purpose of testing, here is the Postman screen used:
Detailed flow
Let us start with an HTTP Request Trigger. You will get a URL which looks like in the below screenshot. This is the URL you will be using. By default this will be using anonymous auth, but you can secure it using few methods, like this one.
Parsing Json
This is an optional step. I wanted to pass some parameters also in addition to the file upload, but I chose not to send individually but as a json string. Since it is a Json string, I have to parse it to extract values from it.
This is the sample input I have. Refer to postman screenshot above.
{
"position": "Java Developer",
"firstname": "Praveen",
"lastname": "Nair",
"email": "praveennnn@abcdef.com",
"phone": "+9715555555",
"urls": ["http://www.google.com", "https://www.adfolks.com"]
}
Create SharePoint List row
Creating a list row and attaching the file is a two step process. First we have to create the row, then using that ID, we have to attach the uploaded file.
Final notes
The last send-mail component you see is just to notify someone in recruitment team that there is a job application logged in SharePoint. Same you can achieve using SharePoint notification features so you may ignore it.
I found that getting filename from the uploaded payload is not so straightforward in Power Automate (someone correct me if I am wrong), but anyways I did’nt need that because the logic I had to use here is to create a custom filename using the candidate’s name and adding the extension we get from the content-type.
Though I’ve wrote this function for Angular – ag-grid, this can be used as an independent method as well.
Code:
LastUpdated(value: string):string {
let inputDate = new Date(value);
let today = new Date();
let yesterday = new Date(today.setDate(today.getDate()-1));
let numdays = Math.round((today.getTime() - inputDate.getTime()) / (1000*3600*24));
let ret:string = formatDate(inputDate,"MMM, dd yyyy",'en-US', '+4');
if ( inputDate.setHours(0,0,0,0) == new Date().setHours(0,0,0,0)) {
ret = "Today";
} else if ( inputDate.setHours(0,0,0,0) == (yesterday.setHours(0,0,0,0))) {
ret = "Yesterday";
} else if (numdays >= 1 && numdays < 7) {
ret = numdays.toString() + " day" + ((numdays > 1)?'s':'') + " ago";
}
return ret;
}
While you will find multiple solutions for formatting a date in ag-grid on internet/stackoverflow and documentation, here is one method I found handy:
{ field: ‘DateUpdated’, valueFormatter: params => formatDate(params.value, ‘MMM, dd yyyy’, ‘en-US’) }
Read in detail here – https://learn.microsoft.com/en-us/aspnet/core/security/cors?view=aspnetcore-7.0
Disclaimer: this is an unethical practice so this is recommended only for development/debugging purpose
I was wondering if I can have a feature to post who-are-all-on-planned-leave list daily in the HR/leaders group in Microsoft Teams. Searched for a plugin in the marketplace, and tried to find a API also. Finally, contacted the Bayzat support and found they don’t have a developer API available at the moment. Then I went though the normal HTTP calling methods and found it worked well. Sharing with you, hoping someone will find this useful in future.
Here is the Adaptive Card output you get in Teams:
This is the high level view of the Power Automate App Flow
Details:
Step 1 – Get the authentication access token
This token is required for you to get access to any APIs/URLs. Use the login API for this:
Step 2 – Read the Leave Calendar
My requirement is only to read one single day, so I am passing utcNow()
Step 3 – Modify the response data as per your requirement
My requirement is small that, I need only list of people marked OOO for this particular day
Step 4 – Post to Microsoft Teams
I chose to post the data in Teams as an Adaptive Card, so I am posting in that format
Contact me if you need some clarifications. Make sure to add sufficient validations to make this flow error free.
Here is a nice playlist for Spring Boot beginners videos from Java Brains – https://www.youtube.com/playlist?list=PLqq-6Pq4lTTbx8p2oCgcAQGQyqN8XeA1x
This is just a revision of my school memories. Language used is Java.
import java.util.Scanner;
public class testmain {
public static void main(String[] args) {
int large = 0; // there is a possible logic error, ignore
int slarge = 0; // there is a possible logic error, ignore
Scanner scanner = new Scanner(System.in);
System.out.println("Enter the number of elements");
int N = scanner.nextInt();
for (int c = 0;c<N;c++) {
int num = scanner.nextInt();
if (num > large) {
large = num;
}
if (num != large && num > slarge) {
slarge = num;
}
}
System.out.println(
"Largest = " + large +
"\nSecond Largest = " + slarge
);
}
}
Haven’t tried their paid courses but free courses are excellent.