Https Result To readable table

pcsoft.us.windevCopyright 2026, PC SOFT10 Apr 2015 12:57:41 Z10 Apr 2015 12:57:41 ZGood Day I am trying to integrate Office 365 to Windev. I managed to use HTTPRequest and get the data from HTTPGetResult. What is the easiest or best way to get it in a table view where it's easier to read. I have and example of the returned data but dont know what do do with it from there. Sorry for the long file: [code:xml] { "@odata.context": "https://outlook.office365.com/api/v1.0/$metadata#Me/Events", "value": [ { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG93AAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x48w==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG93AAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x48w==", "Categories": [], "DateTimeCreated": "2014-10-19T23:13:47.3959685Z", "DateTimeLastModified": "2014-10-19T23:13:47.6772234Z", "Subject": "Weekly Meeting on Contoso Project", "BodyPreview": "Setting up some time to review the budget and planning on the Contoso Project", "Body": { "ContentType": "HTML", "Content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>\r\nSetting up some time to review the budget and planning on the Contoso Project\r\n</body>\r\n</html>\r\n" }, "Importance": "Normal", "HasAttachments": false, "Start": "2014-10-13T21:00:00Z", "End": "2014-10-13T22:00:00Z", "Location": { "DisplayName": "Alex's Office" }, "ShowAs": "Busy", "IsAllDay": false, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SeriesMaster", "SeriesMasterId": null, "Attendees": [ { "EmailAddress": { "Address": "janets@a830edad9050849NDA1.onmicrosoft.com", "Name": "Janet Schorr" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" }, { "EmailAddress": { "Address": "pavelb@a830edad9050849NDA1.onmicrosoft.com", "Name": "Pavel Bansky" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" } ], "Recurrence": { "Pattern": { "Type": "Weekly", "Interval": 1, "Month": 0, "Index": "First", "FirstDayOfWeek": "Sunday", "DayOfMonth": 0, "DaysOfWeek": [ "Monday" ] }, "Range": { "Type": "NoEnd", "StartDate": "2014-10-13T00:00:00-07:00", "EndDate": "0001-01-01T00:00:00Z", "NumberOfOccurrences": 0 } }, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG92AAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x48A==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG92AAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x48A==", "Categories": [], "DateTimeCreated": "2014-10-19T23:13:01.9733945Z", "DateTimeLastModified": "2014-10-19T23:13:02.426753Z", "Subject": "Daily Team Meeting", "BodyPreview": "Daily sync on project progress and team member status", "Body": { "ContentType": "HTML", "Content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>\r\nDaily sync on project progress and team member status\r\n</body>\r\n</html>\r\n" }, "Importance": "Normal", "HasAttachments": false, "Start": "2014-10-13T18:00:00Z", "End": "2014-10-13T18:30:00Z", "Location": { "DisplayName": "Team Room" }, "ShowAs": "Busy", "IsAllDay": false, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SeriesMaster", "SeriesMasterId": null, "Attendees": [ { "EmailAddress": { "Address": "roby@a830edad9050849NDA1.onmicrosoft.com", "Name": "Rob Young" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" }, { "EmailAddress": { "Address": "pavelb@a830edad9050849NDA1.onmicrosoft.com", "Name": "Pavel Bansky" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" }, { "EmailAddress": { "Address": "janets@a830edad9050849NDA1.onmicrosoft.com", "Name": "Janet Schorr" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" }, { "EmailAddress": { "Address": "garthf@a830edad9050849NDA1.onmicrosoft.com", "Name": "Garth Fort" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" }, { "EmailAddress": { "Address": "katiej@a830edad9050849NDA1.onmicrosoft.com", "Name": "Katie Jordan" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" } ], "Recurrence": { "Pattern": { "Type": "Weekly", "Interval": 1, "Month": 0, "Index": "First", "FirstDayOfWeek": "Sunday", "DayOfMonth": 0, "DaysOfWeek": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday" ] }, "Range": { "Type": "NoEnd", "StartDate": "2014-10-13T00:00:00-07:00", "EndDate": "0001-01-01T00:00:00Z", "NumberOfOccurrences": 0 } }, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG91AAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x47Q==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG91AAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x47Q==", "Categories": [], "DateTimeCreated": "2014-10-19T23:12:40.7543183Z", "DateTimeLastModified": "2014-10-19T23:12:41.0043215Z", "Subject": "Rob:Alex 1:1", "BodyPreview": "Let's meet every month to engage in project review and career discussion", "Body": { "ContentType": "HTML", "Content": "<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<style type=\"text/css\" style=\"display:none\"></style>\r\n</head>\r\n<body dir=\"ltr\" style=\"font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;\">\r\n<p>Let's meet every month to engage in project review and career discussion<br>\r\n</p>\r\n</body>\r\n</html>\r\n" }, "Importance": "Normal", "HasAttachments": false, "Start": "2014-10-15T16:30:00Z", "End": "2014-10-15T17:30:00Z", "Location": { "DisplayName": "Alex's Office" }, "ShowAs": "Busy", "IsAllDay": false, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SeriesMaster", "SeriesMasterId": null, "Attendees": [ { "EmailAddress": { "Address": "roby@a830edad9050849NDA1.onmicrosoft.com", "Name": "Rob Young" }, "Status": { "Response": "None", "Time": "0001-01-01T00:00:00Z" }, "Type": "Required" } ], "Recurrence": { "Pattern": { "Type": "RelativeMonthly", "Interval": 1, "Month": 0, "Index": "Third", "FirstDayOfWeek": "Sunday", "DayOfMonth": 0, "DaysOfWeek": [ "Wednesday" ] }, "Range": { "Type": "NoEnd", "StartDate": "2014-10-15T00:00:00-07:00", "EndDate": "0001-01-01T00:00:00Z", "NumberOfOccurrences": 0 } }, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG90AAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x46g==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG90AAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x46g==", "Categories": [], "DateTimeCreated": "2014-10-19T08:48:13.6271741Z", "DateTimeLastModified": "2014-10-19T08:48:13.6427985Z", "Subject": "Thanksgiving Holiday", "BodyPreview": "", "Body": { "ContentType": "HTML", "Content": "" }, "Importance": "Normal", "HasAttachments": false, "Start": "2015-11-26T00:00:00Z", "End": "2015-11-27T00:00:00Z", "Location": { "DisplayName": "" }, "ShowAs": "Free", "IsAllDay": true, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SingleInstance", "SeriesMasterId": null, "Attendees": [], "Recurrence": null, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9zAAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x46Q==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9zAAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x46Q==", "Categories": [], "DateTimeCreated": "2014-10-19T08:46:18.8700566Z", "DateTimeLastModified": "2014-10-19T08:46:18.8856803Z", "Subject": "Thanksgiving Holiday", "BodyPreview": "", "Body": { "ContentType": "HTML", "Content": "" }, "Importance": "Normal", "HasAttachments": false, "Start": "2014-11-27T00:00:00Z", "End": "2014-11-28T00:00:00Z", "Location": { "DisplayName": "" }, "ShowAs": "Free", "IsAllDay": true, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SingleInstance", "SeriesMasterId": null, "Attendees": [], "Recurrence": null, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9yAAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x46A==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9yAAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x46A==", "Categories": [], "DateTimeCreated": "2014-10-19T08:43:37.2138006Z", "DateTimeLastModified": "2014-10-19T08:43:37.2450436Z", "Subject": "New Year's Day Holiday", "BodyPreview": "", "Body": { "ContentType": "HTML", "Content": "" }, "Importance": "Normal", "HasAttachments": false, "Start": "2015-01-01T00:00:00Z", "End": "2015-01-02T00:00:00Z", "Location": { "DisplayName": "" }, "ShowAs": "Free", "IsAllDay": true, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SingleInstance", "SeriesMasterId": null, "Attendees": [], "Recurrence": null, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } }, { "@odata.id": "https://outlook.office365.com/api/v1.0/Users('alexd@a830edad9050849NDA1.onmicrosoft.com')/Events('AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9xAAA=')", "@odata.etag": "W/\"nfZyf7VcrEKLNoU37KWlkQAAA0x45w==\"", "Id": "AAMkAGI2NGVhZTVlLTI1OGMtNDI4My1iZmE5LTA5OGJiZGEzMTc0YQBGAAAAAADUuTJK1K9aTpCdqXop_4NaBwCd9nJ-tVysQos2hTfspaWRAAAAAAENAACd9nJ-tVysQos2hTfspaWRAAADTG9xAAA=", "ChangeKey": "nfZyf7VcrEKLNoU37KWlkQAAA0x45w==", "Categories": [], "DateTimeCreated": "2014-10-19T08:33:45.1538198Z", "DateTimeLastModified": "2014-10-19T08:33:45.200696Z", "Subject": "Christmas Holiday", "BodyPreview": "", "Body": { "ContentType": "HTML", "Content": "" }, "Importance": "Normal", "HasAttachments": false, "Start": "2014-12-25T00:00:00Z", "End": "2014-12-26T00:00:00Z", "Location": { "DisplayName": "" }, "ShowAs": "Free", "IsAllDay": true, "IsCancelled": false, "IsOrganizer": true, "ResponseRequested": true, "Type": "SingleInstance", "SeriesMasterId": null, "Attendees": [], "Recurrence": null, "Organizer": { "EmailAddress": { "Address": "alexd@a830edad9050849NDA1.onmicrosoft.com", "Name": "Alex D" } } } ] } [/code] Thanks for your help30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51454-https-result-readable-table/read.awpHttps Result To readable tablemoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)