Get Value from Json Output in Copilot studio

(0) Share

Report

Posted on by Tobias_Brouwer

Hi,

I am really struggeling with Parsing a value from a JSON output from a connector.

I try to get the values of the property name "value" from the property "CreatedDateTime".

When I use the Set Variable and I enter a Formula I get this error.

How to fix this?

Categories:

General

All responses (7)

Answers (0)

adilei on at

Like (1)

Report

Re: Get Value from Json Output in Copilot studio

I would raise a case with support, as First(topic.myVar.value).createdDateTime is parsed as a DateTimeNoTimeZone, and Copilot Studio does not seem to be able to convert this type to any other type.
jga_lu on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

Same, I'm interested too
MattMMeyer 6 on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

Working on the same issue, any movement?
Tobias_Brouwer 8 on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

{
"@odata.deltaLink": null,
"@odata.nextLink": null,
"value": [
{
"body": "<html>",
"categories": [],
"createdDateTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-02-29T09:17:48.2574022Z"
},
"end": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T10:30:00.0000000Z"
},
"endWithTimeZone": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T10:30:00.0000000Z"
},
"iCalUId": "040000008200E00074C5B7101A82E0080000000050EC6A82F86ADA010000000000000000100000008D7C54BC53E2D545B9D1F7BF04CB1ED9",
"id": "AAMkADY5MWIwMGJkLWQzNTgtNGRmNS1iZTk1LWQ2MmY4MGQ1YzVlYwBGAAAAAABM367r9ZRQTa3Pe5S1LmZ3BwBcdMM2Dp4CTLwdTujvm8bqAAAAAAENAABcdMM2Dp4CTLwdTujvm8bqAAJ3DhZNAAA=",
"importance": "normal",
"isAllDay": false,
"isHtml": true,
"isReminderOn": false,
"lastModifiedDateTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-02-29T09:17:50.4076005Z"
},
"location": "",
"numberOfOccurences": null,
"optionalAttendees": "",
"organizer": "t.brrmaris.nl",
"recurrence": "none",
"recurrenceEnd": null,
"reminderMinutesBeforeStart": 15,
"requiredAttendees": "t.bteis.nl;",
"resourceAttendees": "",
"responseRequested": true,
"responseTime": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "0001-01-01T00:00:00.0000000Z"
},
"responseType": "none",
"selectedDaysOfWeek": null,
"sensitivity": "normal",
"seriesMasterId": null,
"showAs": "busy",
"start": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T09:30:00.0000000Z"
},
"startWithTimeZone": {
"$kind": "DateTimeNoTimeZoneDataValue",
"value": "2024-03-04T09:30:00.0000000Z"
},
"subject": "Voeg",
"timeZone": "UTC",
"webLink": "https://outlooDY5MWI"
}
]
}
adilei on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

This JSON is not valid. Not sure if that is the issue, but it means that I'm not able to test anything.
Tobias_Brouwer 8 on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

{ "@odata.deltaLink": null, "@odata.nextLink": null, "value": [ { "body": "<html>, "categories": [], "createdDateTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-02-29T09:17:48.2574022Z" }, "end": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T10:30:00.0000000Z" }, "endWithTimeZone": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T10:30:00.0000000Z" }, "iCalUId": "040000008200E00074C5B7101A82E0080000000050EC6A82F86ADA010000000000000000100000008D7C54BC53E2D545B9D1F7BF04CB1ED9", "id": "AAMkADY5MWIwMGJkLWQzNTgtNGRmNS1iZTk1LWQ2MmY4MGQ1YzVlYwBGAAAAAABM367r9ZRQTa3Pe5S1LmZ3BwBcdMM2Dp4CTLwdTujvm8bqAAAAAAENAABcdMM2Dp4CTLwdTujvm8bqAAJ3DhZNAAA=", "importance": "normal", "isAllDay": false, "isHtml": true, "isReminderOn": false, "lastModifiedDateTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-02-29T09:17:50.4076005Z" }, "location": "", "numberOfOccurences": null, "optionalAttendees": "", "organizer": "t.brrmaris.nl", "recurrence": "none", "recurrenceEnd": null, "reminderMinutesBeforeStart": 15, "requiredAttendees": "t.bteis.nl;", "resourceAttendees": "", "responseRequested": true, "responseTime": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "0001-01-01T00:00:00.0000000Z" }, "responseType": "none", "selectedDaysOfWeek": null, "sensitivity": "normal", "seriesMasterId": null, "showAs": "busy", "start": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T09:30:00.0000000Z" }, "startWithTimeZone": { "$kind": "DateTimeNoTimeZoneDataValue", "value": "2024-03-04T09:30:00.0000000Z" }, "subject": "Voeg", "timeZone": "UTC", "webLink": "https://outlooDY5MWI" }}
adilei on at

Like (0)

Report

Re: Get Value from Json Output in Copilot studio

Can you paste the JSON payload here as text?