web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

How to create Lead from HTTP Response through Power Automate

(4) ShareShare
ReportReport
Posted on by 8
          
{
  "request": {
    "startDateTimeUTC": "2025-02-01T08:00Z",
    "swid": "XXXXXXXXXXXX",
    "endDateTimeUTC": "2025-02-01T08:30Z",
    "orgid": "XXXX"
  },
  "response": {
    "client_1": {
      "count": 1,
      "detail": {
        "r": 1234567890,
        "i": "XXXXXXXXXXXX",
        "type": "e",
        "server_time": 1738396882000,
        "ap_mac": "XXXXXXXXXXXX",
        "client_mac": "XXXXXXXXXXXX",
        "client_ip": "10.0.0.1",
        "client_useragent": "UserAgentStringHere",
        "user_id": "sample1@example.com",
        "name": "Sample User 1",
        "firstname": "Sample",
        "lastname": "User",
        "email": "sample1@example.com",
        "mobileFromEmailLogin": "971500000001",
        "schemaFields": {
          "firstname": "Sample",
          "birthdate": null,
          "mobile": "971500000001",
          "email": "sample1@example.com",
          "lastname": "User"
        }
      }
    },
    "client_2": {
      "count": 1,
      "detail": {
        "r": 1234567891,
        "i": "XXXXXXXXXXXX",
        "type": "e",
        "server_time": 1738397749000,
        "ap_mac": "XXXXXXXXXXXX",
        "client_mac": "XXXXXXXXXXXX",
        "client_ip": "10.0.0.2",
        "client_useragent": "UserAgentStringHere",
        "user_id": "sample2@example.com",
        "name": "Sample User 2",
        "firstname": "Sample",
        "lastname": "User",
        "email": "sample2@example.com",
        "mobileFromEmailLogin": "971500000002",
        "schemaFields": {
          "firstname": "Sample",
          "birthdate": null,
          "mobile": "971500000002",
          "email": "sample2@example.com",
          "lastname": "User"
        }
      }
    }
    // Add more sample clients as needed...
  },
  "error": null,
  "authorization": {
    "usage": null,
    "time": "2025-04-16T09:07:28Z",
    "executionDurationInMillis": 892
  }
}
- This is sample http response, the output is getting above JSON object format like Single JSON has multiple objects.
 
I want to create lead from HTTP Response, So How to parse json which having multiple response objects, like one json had multiple leads info which we need to create in msd through power automate?
 
Thanks in advance! 😊
I have the same question (0)
  • Suggested answer
    Tom_Gioielli Profile Picture
    2,792 Super User 2025 Season 2 on at
    • Use the "Parse JSON" built in action and feed in your JSON information. You can provide a sample payload to create the JSON schema automatically to make this even easier
    • You'll then add in a "For Each" action using the Parsed JSON as your input.
    • Within the For Each Loop, you will use the Dataverse Action "Add a new Row".
      • Table = Leads
      • Pull in fields from your JSON parsing action to populate fields on the lead table
    This should loop through all of your items and create leads, whether 1 or 500 were sent in from the initial request.
     
    If this answer helped, please consider marking as verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans