Https Result To readable table - WINDEV 2024 - Foro de desarrolladores

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio

Mensajes recientes

Conéctese...

Español

Inicio → WINDEV 2024 → Https Result To readable table

Https Result To readable table

Iniciado por Ruan, 10,abr. 2015 12:57 - No hay respuesta

Ruan

Miembro registrado
214 mensajes

Publicado el 10,abril 2015 - 12:57

Good 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:

{
"@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"
}
}
}
]
}

Thanks for your help

Informar

Debe estar conectado para evaluar este mensaje

→ Volver a WINDEV 2024