Forum Discussion

Veena123's avatar
Veena123
Regular Visitor
1 year ago

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

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!

4 Replies

  • Veena123's avatar
    Veena123
    Regular Visitor

    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's avatar
      datacoffee
      Most Valuable Professional

      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. 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable

    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. 

  • xujx's avatar
    xujx
    Microsoft Employee

    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.