RequestFor Step-by-Step Guide on Creating a logic app to read from api and pushing to EventStreamRTI

[Veena123]

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:

Setting up the Logic App in Azure.
Configuring the API connector to read data.
Steps to transform the data (if necessary).
Push data to Eventstream
Setting up the EventStream connection in RTI.
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!

[xujx]

Can you share the full error message under the Event Hub name input box in your screenshot? The error message seems not the same as the one in your reply.

[v-tangjie-msft]

Hi @Veena123 ,

1. Create a Logic App:
- Go to the Azure portal.
- Click on "Create a resource" and search for "Logic App".
- Click "Create" and fill in the necessary details like Subscription, Resource Group, and Logic App name.
- Click "Review + create" and then "Create".

Create web APIs & REST APIs for Azure Logic Apps - Azure Logic Apps | Microsoft Learn

2. Configuring the API Connector to Read Data：
(1) Add an HTTP Trigger:
- In the Logic App Designer, select the "When an HTTP request is received" trigger.
- This will generate a URL that you can use to trigger the Logic App.

(2) Configure the API Call:
- Add a new step and choose "HTTP" action.
- Set the method to "GET" (or the appropriate method for your API).
- Enter the API endpoint URL.
- Add any necessary headers or authentication details.

 3. Steps to Transform the Data:

- If you need to transform the data, you can use the "Compose" action to manipulate the JSON data.
- Alternatively, you can use Azure Functions or other services to process the data before pushing it to EventStream.

4. Push Data to EventStream.

Create an eventstream in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

5. Setting Up the EventStream Connection in RTI.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Veena123]

I've encountered an issue in the final step while pushing data to Event Stream. We're using the endpoint from Event Stream and getting the following error:

jsonCopy code{"status": 400,"message": "Event received is null and could not be parsed.\r\nclientRequestId: bf114c7d-e91a-4640-9436-8d343066e661","error": {"message": "Event received is null and could not be parsed."},"source": "eventhubs-ncus.azconn-ncus-001.p.azurewebsites.net"}

Can you please assist me with this?

Thank you!

[datacoffee]

This error looks like an empty json object was send to the endpoint. An empty json can't be parsed to data and you get the error.
Try to debug and make sure you send a json object to the endpoint. 🙂