Azure JSON intake and output Solutioning Advice

Michael Burch 1 Reputation point
2022-05-24T23:09:22.49+00:00

Hello World,

So I have a project that is coming on deck that I need some advice on.

Overview: We are developing a mobile app that will be sending (REST API POST) data to a SaaS endpoint. The target endpoint has a complex JSON schema, and the mobile application will be sending the JSON message in a flat and common JSON schema. We would like to establish a middleware component to receive the JSON, validate that JSON to the common schema, reassemble the JSON to adhere to the complex target endpoint schema and output it to the target endpoint. We would like to avoid coding this from the ground up, and are looking to potentially leveraging existing resources within our Azure subscription.
As an example:

  • Azure Event Hub: Endpoint and messaging ingestion service
  • Azure Storage Account: Message capture
  • Azure Logic App: Validate against the schema, parse the JSON, assemble the JSON to the target endpoint schema
  • ???: REST API delivery to the target endpoint

**Note: The example above is considered just an example, and in no way to be considered the solution. I’m really looking for guidance on the Azure resources that would be needed to achieve the intake, validation, transformation, and output of the data. In other words, do my job for me .

In advance, thank you so much
Michael

Azure API Management
Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,778 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,863 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
560 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,626 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,031 Reputation points
    2022-05-25T22:55:41.86+00:00

    Hello @Michael Burch ,
    Thanks for the question and using MS Q&A platform.

    As I understand, you want advice on choice of product/services used in your architecture.
    mobile app (simple json) ---> ????? ---> unknown SaaS (complex json)

    Event Hubs is perfect if you need a buffer. I think it would also work for logging the messages here.
    Event Hubs also has a capture mechanism to more easily record in a storage of your choice.

    Here is a tutorial on logging from API Management to Event Hubs.

    I am not an expert in Logic App or API Management, so I asked my colleague (who works on API Management and Logic Apps), and was told API Management is the exact thing you need, as it can do transformation and validation and content validation. The more I look at API Management, the more I wonder if we even need the other parts (except Storage -- Everyone needs storage).

    Logic App is the only one I would really question.

    Please do let me if you have any queries. I expect your follow ups would be more on the API Management, so I'll send you to my colleague's queue if you like.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators