Azure Function to call API and display information

In this post, will review on how to create an Azure Function to call an API to get the data and back the json data to requester. This is developed using Visual Studio in Windows environment.

Open Visual Studio and then click to create a new project. Search Azure Function Template and then click next. Put a meaningfull name and location of your project. Click next.



Next, select Http trigger from Function dropdown box. In this project, this would be a Http call.

Finally turned on Authorization level to Anonymous. Click to create the project.


Once the project created, you will found the local.settings.json file. Replace the following code with the following one. We place environment/configuration variable in local.settings.json file under Values.

{
    "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true",
    "FUNCTIONS_WORKER_RUNTIME": "dotnet-isolated",
    "APIURL": "https://www.alphavantage.co/",
    "APIKEY": "ZMM6ZDHER7PFKY07"
  }
}

Now, open the CS file your created for your HTTP trigger Azure function. Following SDK should be there.

using System;
using System.Net.Http;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using System.Collections.Generic;
using Microsoft.Azure.Functions.Worker;
using System.Collections;


Finally replace your class file with the following code:

public static class Stock
{
    private static readonly HttpClient client = new HttpClient();

    [Function("GetStockData")]
    public static async Task<IActionResult> Run(
        [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req,
        ILogger log)
    {
        string symbol = req.Query["stock"];
        if (string.IsNullOrEmpty(symbol))
        {
            return new BadRequestObjectResult("Please provide a stock symbol.");
        }

        // Replace with your actual API key
        string apiKey = Environment.GetEnvironmentVariable("APIKEY"); 
        string apiUrl = Environment.GetEnvironmentVariable("APIURL") + "query?function=TIME_SERIES_MONTHLY&symbol=" + symbol + "&apikey=" + apiKey;
      
        HttpResponseMessage response = await client.GetAsync(apiUrl);
        if (!response.IsSuccessStatusCode)
        {
            return new StatusCodeResult(500);
        }

        string jsonResponse = await response.Content.ReadAsStringAsync();
        JObject data = JObject.Parse(jsonResponse);

  
        return new ContentResult
        {
            Content = data.ToString(),
            ContentType = "application/json",
            StatusCode = 200
        };
    }
}


Run the project and then open the url to check. Please make sure to add ?stock= in query parameter.
For example, I'd like to test with with Micrsoft Stock price. MSFT is the stock code for Micrsoft. 
Url would be something like http://localhost:7029/api/GetStockData?stock=MSFT

Comments

Post a Comment

Popular posts from this blog

SharePoint Framework Reference Guide

SPFx stands for SharePoint Framework -  https://learn.microsoft.com/en-us/javascript/api/overview/sharepoint?view=sp-typescript-latest   Below are the packages of SPFx and we are using them while using SPFx framework for development in our day-to-day activities. .'@microsoft/decorators' - https://learn.microsoft.com/en-us/javascript/api/decorators?view=sp-typescript-latest '@microsoft/sp-core-library' - https://learn.microsoft.com/en-us/javascript/api/sp-core-library?view=sp-typescript-latest '@microsoft/sp-component-base package' - https://learn.microsoft.com/en-us/javascript/api/sp-component-base?view=sp-typescript-latest '@microsoft/sp-application-base package' - https://learn.microsoft.com/en-us/javascript/api/sp-application-base?view=sp-typescript-latest '@microsoft/sp-dynamic-data package' - https://learn.microsoft.com/en-us/javascript/api/sp-dynamic-data?view=sp-typescript-latest '@microsoft/sp-extension-base package' - http...
Read more

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.         ...
Read more

SharePoint Admin Center

Image
 SharePoint Admin Center allows you to view your organization's SharePoint site including communication sites, channel sites, and sites that belong to Microsoft 365 group. This is same like Site Admin in earlier days of SharePoint versions. You can search organizational site, sort them or filter sites the way you want. Easy way to find and apply/change site settings. Under Policies, click on Sharing - This will allow you to create rules/ set control sharing at the organization level in SharePoint and OneDrive Here, in this page, you can apply settings to restrict how users are allowed to access content in SharePoint and OneDrive. Term store, the word getting populated from SharePoint 2010. You can feed metadata of metadata information of your organization level, program level, project level in Term store. helps your organization's knowledge better.  AI soon will play a vital role here and using AI, you can acyually find collect and process and finally yoour organization's d...
Read more