Nested data transfer from logic apps to azure data explorer

Question

{
  "company": {
    "name": "TechCo",
    "founded_year": 2010,
    "employees": [
      {
        "id": 1,
        "name": "Alice",
        "position": "CEO",
        "projects": [
          {
            "project_id": "p1",
            "project_name": "InnovationHub",
            "status": "ongoing",
            "tasks": [
              {
                "task_id": "t1",
                "task_name": "Research",
                "assigned_to": "Alice",
                "due_date": "2023-09-30"
              },
              {
                "task_id": "t2",
                "task_name": "Prototyping",
                "assigned_to": "Bob",
                "due_date": "2023-10-15"
              }
            ]
          }
        ]
      },
      {
        "id": 2,
        "name": "Bob",
        "position": "CTO",
        "projects": [
          {
            "project_id": "p2",
            "project_name": "DataRevolution",
            "status": "planned",
            "tasks": [
              {
                "task_id": "t3",
                "task_name": "Data Collection",
                "assigned_to": "Bob",
                "due_date": "2023-09-15"
              },
              {
                "task_id": "t4",
                "task_name": "Algorithm Design",
                "assigned_to": "Charlie",
                "due_date": "2023-09-30"
              }
            ]
          }
        ]
      },
      {
        "id": 3,
        "name": "Charlie",
        "position": "Lead Engineer",
        "projects": [
          {
            "project_id": "p3",
            "project_name": "OptimizationDrive",
            "status": "completed",
            "tasks": [
              {
                "task_id": "t5",
                "task_name": "Code Refactoring",
                "assigned_to": "Charlie",
                "due_date": "2023-07-15"
              }
            ]
          }
        ]
      }
    ]
  }
}

This is my nested data i want to transfer this to azure data explore from azure logic apps through blob storage. give me a solution and workflow chart 

Answer 1

@SURULIRAJAN V Thanks for reaching out.

Data ingestion is the process used to load data records from one or more sources into a table in Azure Data Explorer and the supported ways are documented here.

Logic app does have Azure Data Explorer connector and the available action are listed here where you can render chart, run query etc. at the Azure data explorer end.

As you already have the DataSource as blob in your storage account so you can refer to this document to Ingest data from a container into Azure Data Explorer.

Hope the above clears things up and you cannot use Azure logic app data explorer connector to send data to data explorer.

Let me know if you have any queries or concerns.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.