Dynamics 365日期和时间字段

1
var req = new XMLHttpRequest();
2
var apiVersion = "v9.1";
3
var entityName = "gdh_invoices";
4
var recordId = "98F83878-1E35-EF11-8409-0017FA0671FA";
5
var selectFields = [
6
  "gdh_d_d",
7
  "gdh_d_tz_independent",
8
  "gdh_d_userlocal",
9
  "gdh_dt_tz_independent",
10
  "gdh_dt_userlocal",
11
].join(",");
12
var baseUrl = Xrm.Page.context.getClientUrl();
13
var apiPath = `/api/data/${apiVersion}/${entityName}(${recordId})`;
14
var queryParams = `?$select=${selectFields}`;
15
var fullUrl = baseUrl + apiPath + queryParams;
16
req.open("GET", fullUrl, true);
17
req.setRequestHeader("OData-MaxVersion", "4.0");
18
req.setRequestHeader("OData-Version", "4.0");
19
req.setRequestHeader("Accept", "application/json");
20
req.setRequestHeader("Content-Type", "application/json; charset=utf-8");
21
req.setRequestHeader("Prefer", 'odata.include-annotations="*"');
22
req.onreadystatechange = function () {
23
  if (this.readyState === 4) {
24
    req.onreadystatechange = null;
25
    if (this.status === 200) {
26
      var result = JSON.parse(this.response);
27
      var gdh_d_d = result["gdh_d_d"];
28
      var gdh_d_tz_independent = result["gdh_d_tz_independent"];
29
      var gdh_d_userlocal = result["gdh_d_userlocal"];
30
      var gdh_dt_tz_independent = result["gdh_dt_tz_independent"];
31
      var gdh_dt_userlocal = result["gdh_dt_userlocal"];
32
    } else {
33
      Xrm.Utility.alertDialog(this.statusText);
34
    }
35
  }
36
};
37
req.send();

1
{
2
  "@odata.context": "https://sample.com/api/data/v9.1/$metadata#gdh_invoices(gdh_d_d,gdh_d_tz_independent,gdh_d_userlocal,gdh_dt_tz_independent,gdh_dt_userlocal)/$entity",
3
  "@odata.etag": "W/\"9300793\"",
4
  "gdh_invoiceid": "98f83878-1e35-ef11-8409-0017fa0671fa",
5
  "gdh_dt_userlocal@OData.Community.Display.V1.FormattedValue": "2025/03/10 14:30",
6
  "gdh_dt_userlocal": "2025-03-10T06:30:00Z", // [!code highlight]
7
  "gdh_d_d@OData.Community.Display.V1.FormattedValue": "2025/03/14",
8
  "gdh_d_d": "2025-03-14", // [!code highlight]
9
  "gdh_d_userlocal@OData.Community.Display.V1.FormattedValue": "2025/03/10",
10
  "gdh_d_userlocal": "2025-03-09T16:00:00Z", // [!code highlight]
11
  "gdh_d_tz_independent@OData.Community.Display.V1.FormattedValue": "2025/03/12",
12
  "gdh_d_tz_independent": "2025-03-12T00:00:00Z", // [!code highlight]
13
  "gdh_dt_tz_independent@OData.Community.Display.V1.FormattedValue": "2025/03/24 09:30",
14
  "gdh_dt_tz_independent": "2025-03-24T09:30:00Z" // [!code highlight]
15
}