Azure Logic Apps - Consuming
RESTService - Stock Quotes





  2. Get your API Key




  1. Test the connection


  1. Create a new LogicApp
  2. Add Recurrence as the first shape and configure it to trigger the application every 1 Minute
  1. Click on the New step -> Add an action
  1. Then search for Variables
  1. Initialize a new variable of type string named “LastRefreshed” to store the last refreshed value that provided in the “Meta Data” section of the HTTP response for fetching required data from “Time Series (1min)” section *.
  2. Initialize another variable (repeat steps 6 and 7) of type float named “value” to store the “Open” value of the given Stock Option
  1. Add a new action of type HTTP (HTTP - HTTP)
  2. Specify the GET method in the first filed
  3. In the lower left corner switch from the Design view to Code View
  1. At the bottom, you should see the section for parameters
  1. You need to add the following code inside the brackets
   "API": {
     "Type": "string",
     "defaultValue": "https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=XYZ&interval=1min&apikey=YOURKEY"
   },
   "Symbol": {
     "Type": "string",
     "defaultValue": "GE"
   }


  1. Go back to the Design tab:
  1. Click inside the Uri field
  2. In order to make the URI parameterized, click on the Add dynamic content link.
Add the following expression: replace(parameters('API'),'symbolParam',parameters('Symbol'))
  1. Using LogicApp parameters will make your application more flexible, especially if you would like to query the service for other Stock Options
  2. Add a new action, search for Variables and then for “Set variable”
  1. From the drop down, choose LastRefreshed
  1. Name: LastRefreshed
  2. Place the cursor in the Value field and click on the Add Dynamic content > Expression
  1. Expression:  body('HTTP')?['Meta Data']['3. Last Refreshed']
  1. Finally reading values from the latest node of “Time Series (1min)” section, for example we need to get “Open” value and convert it to a float value since the JSON represented as a string, so “float(...)” function will do the job, and the expression for set variable action
  2. Add the new action: Variables - Set Variable
  3. Name: value
  4. Value: Click on the Add dynamic content link and then go to the Expression tab
  5. Expression:  float(body('HTTP')?['Time Series (1min)'][variables('LastRefreshed')]['1. open'])
  1. Now Deploy the App to azure portal


  1. Go back to your azure portal and run your application.




  1. Result

* Initializing Variables actions should be right after the trigger, you can not Initialize variable in the middle of the workflow.

Comments

Post a Comment

Popular posts from this blog

C# - Simple Class Library and how to use it in another project

Image
C# - Simple Class Library and how to use it Create  a Class Library Project Create a new project - Console Application Right click on the newly created project and Set it as a StartUp Project Reason: You cannot run a Class Library on it’s own, it needs to be called from another project. Add a reference to your Class Library project In the SimpleClassLibrary Project - rename the Class to PrintOK and add a public method WriteOK() using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.IO; namespace SimpleClassLibrary { public class PrintOK {     public void WriteOK(){      Console .WriteLine( "OK" );      Console .ReadLine(); } } } Add preprocessor  directive In the UsingClassLibrary project, add the following code: using System; using...
Read more

AWS CLI - INSTALLATION AND CONFIGURATION

Image
AWS CLI - INSTALLATION AND CONFIGURATION https://aws.amazon.com/cli/ Download the MSI installer from here Install as administrator If you haven’t done that before then create your IAM credentials here Access Key ID: AXXXXXXXXXXXXXXXXXXXXQ Secret Access Key : FYYYYYYYYYYYYYYYYYYYYYYYYYYYY2i After the installation is successfully accomplished - open cmd and issue the following command aws configure aws /? Try sns sns /? To get the list of commands that for the sns system You could also use aws help and aws sns help Run the following command: aws sns list-topics
Read more

Upload a file to a Web server in ASP.NET by using Visual C# .NET

Image
Upload a file to a Web server in ASP.NET by using Visual C# .NET Open the Visual Studio Click New > Project ASP.NET WebApplication Name it accordingly When the Project gets created, right click on it and click on Add > New Item > Web Form Name the form FileUpload.aspx Open the FileUpload.aspx the following code <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="FileUpload.aspx.cs" Inherits ="ASPFileUpload.FileUpload" %> <! DOCTYPE html > < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < title > FileUpload </ title > </ head > < body >     < form id ="form1" enctype ="multipart/form-data" runat ="server">         < p >< input type ="file" id ="File1" name ="File1" runat ="server...
Read more