Exact matching is a critical process for identifying precise matches between text data and predefined keywords. In this blog, we’ll walk you through building an Azure ML pipeline to perform exact keyword matching using a Python script Why Perform Exact Matching? Exact matching is vital when precision is critical. It ensures: Identifying Specific Terms: Ideal… Continue reading How to Build a Pipeline for Exact Matching in Azure ML Using Python Script
Requirements: If the file size of an Excel file exceeds the specified criteria, we need to address the following: The Excel file contains multiple sheets, and these sheets contain inter-related data. We utilize SQL Views to retrieve data from these sheets using the “Get Data” activity in Excel. Although we can split the Excel file… Continue reading Split the Text files using ADF Pipelines
As Azure Data Factory (ADF) does not offer Excel as a sink option, an alternative method is required to copy Excel files using ADF pipelines. Implementation Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field list to include… Continue reading Copying Excel files from source to destination in Excel format using ADF Pipeline
The objective is to copy various types of files, including JSON, CSV, Text, and Excel files, using a single Copy data activity in Azure Data Factory (ADF) pipeline. Implementation: Step 1: Utilize the “Get Metadata” activity to retrieve the list of files stored in the blob storage. Select the “Child Items” option from the field… Continue reading Dynamically copying all types of files, including Excels, JSON, CSV, and TXT, using a single copy data activity in ADF
The world of cloud computing has completely transformed how businesses operate and innovate. Microsoft Azure stands out as a leading cloud platform, by offering unmatched scalability and agility to organizations all over the globe. Our Microsoft Azure services encompass a wide range of offerings, from deploying infrastructure to modernizing applications. Whether you’re migrating to Azure,… Continue reading Harnessing Innovation with Microsoft Azure Services
In one organization, there is one analysis of employee’s performance on different technologies based on the technologies they know and ratings from their manager. If they don’t meet the required criteria, then that employee will get training for those technologies. Input: emp_id MSBI PowerBI ratings from the manager 101 null x 3 101 null null… Continue reading Implementing ADF Branches and Filters for Employee Training
In this blog we are going to learn how to implement Dynamic Mapping to copy data from multiple sources to sinks in ADF. The below attached images show that there are 2 pair of source-destination tables. Now the source table is holding some data while the destination tables is blank, but its schema is similar… Continue reading Copy Data Dynamically From Multiple Sources To Multiple Sinks In ADF
Now, in this blog we will see how to access SharePoint online data. In this example, we will resize SharePoint Online image by using the Microsoft Graph API via SharePoint using the /_api/v2.0. We need to specify the size; large, small, and medium; in the request URL to resize the image that would give us… Continue reading Access SharePoint Online Data Using Postman Part 2
In this blog, we will show you how we can interact with SharePoint via Rest APIs and perform actions like adding, updating, deleting, and fetching data using Postman. We are using two operations SharePoint App Registration and Azure AD app (Graph API). The important factor is Authentication and Authorization while accessing SharePoint information. Generate… Continue reading Access SharePoint Online Data Using Postman Part 1
There are basically two ways to create and publish the Function App in the Microsoft Azure. One of the ways is to create the Function App directly in the Microsoft Azure and publishing it from there itself. The second way is to create the Function App in the Visual Studio and publishing it from the… Continue reading Make Microsoft Azure Function App editable or read-only
At times we are stuck with issues which look very clear but takes everything out of you to resolve them. Recently, I had faced one of them during the deployment of one of my FunctionApp at Azure. Actually, I had to deploy a FunctionApp from the VisualStudio. I deployed it successfully but while selecting the… Continue reading Azure FunctionApp Error: The binding type(s) ‘serviceBusTrigger’ are not registered[SOLVED]
The integration of Microsoft D365 CE with SharePoint has enabled the document management in SharePoint precisely in the form of folders and subfolders, in a structured way. Today in this blog, let’s learn how we can upload the documents in SharePoint from the D365 CE using the Dot Net c# web API code with a… Continue reading Upload document to SharePoint from Microsoft D365 CE using C# Web API & manage SharePoint document metadata
In our previous blog, we have explained how to handle DLQ using the Azure Functions. Please refer: https://www.inkeysolutions.com/blogs/handling-dead-letter-queuedlq-using-azure-functions/ Lets now learn how to read the messages from the DLQ using the Logic App: First and foremost, we need to identify the message received in the Dead Letter Queue. So, the trigger step in the Logic… Continue reading Handling Dead Letter Queue(DLQ) using Logic App
Microsoft Azure Service Bus is a secure platform for transferring the messages across various platforms and applications. This is a reliable service for asynchronous data transfer using messages. Queues are one among the data structures used while transmitting the data across the cloud. Messages are stored in the queue until processed at the receiver’s end.… Continue reading Handling Dead Letter Queue(DLQ) using Azure Functions
Today, the majority of the business have based their roots with Azure. Above all the benefits, the main attraction of the Azure functions is that it helps in the simplification of developing the applications. They can also be debugged locally to identify the errors or to know the sanity status of the function. This can… Continue reading Debug the Azure Functions locally
Let’s learn today, how to add an external assembly as a reference in an azure function with a small example. This will help you to reuse the already developed functionalities (i.e.,) if there is a requirement that some of the functionalities are needed inside the azure function, which are already developed in any of the… Continue reading Add an external assembly as a reference in the Azure function
Today in this blog, I will explain you how to setup various resources in Azure to integrate the external website with dynamic crm 365 using Azure Logic App and Service Bus. You will have to create below resources in Azure to integrate external website with Microsoft Dynamics 365:- 1. Resource group 2. Service Bus Namespace… Continue reading Setup Azure portal resources to integrate external website with Microsoft Dynamics 365
Using Logic App we can create, update, return list of records etc from the CRM. Today in this blog, I will explain how to access the Azure Logic App using Service Bus from an external website. First, create a web API to access the Azure Logic App using Service Bus. Please refer the below link… Continue reading Access the Azure Logic App using Service Bus to connect Microsoft Dynamics 365 from an external website
Today in this blog, I will explain how we can communicate with the Microsoft dynamics 365 from an external website using Azure Service Bus & Logic App. Using Logic App we can create, update, return list of records etc from the CRM. Below is an example of how we can create the record in the… Continue reading Integrate external web resource with Microsoft Dynamics 365 using Azure Service Bus & Logic App
© All Rights Reserved. Inkey IT Solutions Pvt. Ltd. 2025
