Dynamics Community Forum Thread Details

How to create Lead from HTTP Response through Power Automate

{
"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! 😊

Categories:

Dynamics 365 general

Power Platform integration

Quick Links

Leaderboard