Request for Step-by-Step Guide on Creating a logic app to read from api and pushing to EventStream in RTI?

Question

Hello Team,

I’m currently working on a project involving Real-Time Intelligence (RTI) in Microsoft Fabric, and I need assistance with integrating a Logic App to read data from an API and push that data to EventStream RTI Fabric?

Could anyone please provide a detailed, step-by-step guide on how to accomplish this? Specifically, I’m looking for:

1. Setting up the Logic App in Azure.
2. Configuring the API connector to read data.
3. Steps to transform the data (if necessary).
4. Push data to Eventstream
5. Setting up the EventStream connection in RTI.
6. Any best practices or tips to ensure smooth data flow.

Your expertise would be greatly appreciated, and I look forward to your guidance!

Thank you!

Answer 1

Hi @Veena Koliguri,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

1. Set Up the Logic App in Azure

• Navigate to the Azure portal.
• Search for "Logic Apps" and select the service.
• Click + Create to create a new Logic App.
• Provide a name, resource group, and location for your Logic App.
• Click Create.

2. Configure the API Connector

• In the Logic App designer, click + Add new step.
• Search for "HTTP" and select the HTTP trigger.
• This will be triggered by an HTTP request, but you can also use other triggers like a schedule or a message from a queue.
• After the trigger, add a HTTP action.
• Set the Method to GET (or the appropriate method for your API).
• Paste the API URL into the URI field.
• If your API requires authentication, configure the Authorization header accordingly.
• Click Done.

3. Transform Data (if necessary)

• If the data from the API needs to be transformed or parsed, add a Parse JSON action or use JavaScript code to manipulate the data.
• For example, if the API returns data in JSON format, you can use the Parse JSON action to extract specific fields.

4. Push Data to EventStream

• Add an Azure Event Hub action.
• Select your Event Hub namespace and name.
• Choose the Send event operation.
• In the Body field, map the transformed data from the previous steps to the appropriate fields in the Event Hub message.
• Click Done.

5. Set Up the EventStream Connection in RTI

• In RTI Fabric, create a new EventStream instance.
• Configure the EventStream to connect to your Azure Event Hub.
• Provide the necessary connection details, such as the Event Hub namespace, name, and shared access policy.

If you find this answer helpful, please click "Accept Answer" and kindly upvote it.