EMEA/APAC/EASTUS/WESTUS/CAEA-Nested field displays null when exporting trackevent

Found in

EPiServer.Profiles.Client 1.9.0

Fixed in

EPiServer.Profiles.Client 1.9.1

Created

Jul 18, 2019

Updated

Jul 30, 2019

State

Closed, Fixed and tested


Description

  • Preconditions*: There are some track events in the system

Steps to reproduce

1. Export trackevent by:

 
GET/TrackeventAPI/default/ExportByQuery?$filter=CountryCode eq NL&$Select=DeviceId,User.Name
 
It returns the response: 
{
    "Query": "CountryCode eq NL",
    "Select": "DeviceId,User.Name",
    "RequestId": "4d38aad3-066a-4e47-965a-f57a785f3c52",
    "ResultUrl": "https://profilesapi-emea01.profilestore.episerver.net/api/v1.0/trackevents/ExportByQueryResult/4d38aad3-066a-4e47-965a-f57a785f3c52",
    "Scope": "default",
    "RequestedTime": "2019-07-18T04:09:47.2680235Z",
    "Status": "Accepted"
}

2. View the export result status:

GET/TrackeventAPI/ExportByQueryResult/4d38aad3-066a-4e47-965a-f57a785f3c52

Its response is:

{
    "Query": "CountryCode eq NL",
    "Select": "DeviceId,User.Name",
    "RequestId": "4d38aad3-066a-4e47-965a-f57a785f3c52",
    "ResultUrl": "https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_index.json",
    "Headers": {
        "x-ms-date": "Fri, 19 Jul 2019 04:09:47 GMT",
        "x-ms-version": "2018-03-28",
        "Authorization": "SharedKey emeappgibinbixvyuwasync:Nl92pqYUxhaoie+gBO1ROk2NR0CeN5zkGYklAuvLImw="
    },
    "Scope": "default",
    "RequestedTime": "2019-07-18T04:09:47.2680235Z",
    "Status": "Finished"
}

3. Process to get the blobs file with inserting header keys.

Get/https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_index.json
 
It returns response: 
{
    "NumberOfBlobs": 2,
    "ResultUrlsAndHeaders": {
        "https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_e6262969-291a-496b-abb7-2db0f0f264cb.json": {
            "x-ms-date": "Fri, 19 Jul 2019 04:09:47 GMT",
            "x-ms-version": "2018-03-28",
            "Authorization": "SharedKey emeappgibinbixvyuwasync:o//vAjPW+PnBDApdbkzIITb1svaLTB22BERRp2z2EWk="
        },
        "https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_0abaf25c-4ebc-4e80-9bf7-b606755379ce.json": {
            "x-ms-date": "Fri, 19 Jul 2019 04:09:47 GMT",
            "x-ms-version": "2018-03-28",
            "Authorization": "SharedKey emeappgibinbixvyuwasync:9viZt7j8dCex3IVSJsk4/PCiWlfELqM5Xh5qBvneR3s="
        }
    }
}

4. View the first and second exported data file.

GET/https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_e6262969-291a-496b-abb7-2db0f0f264cb.json
 
GET/https://emeappgibinbixvyuwasync.blob.core.windows.net/190718/dnNHUEdUEUZRE3NyRFAQBEsVV0dydRQKEFAXT1BLJiE07RDU/default/190718040947268_default_0abaf25c-4ebc-4e80-9bf7-b606755379ce.json
 
It shows data in the first file as below: 
 
{
    "NumberOfItems": 1,
    "Items": [
        {
            "DeviceId": "d2",
            "User": {}
        }
    ]
}
 
The data in the second files:
 
{
    "NumberOfItems": 2,
    "Items": [
        {
            "DeviceId": "d3",
            "User": {}
        },
        {
            "DeviceId": "d2",
            "User": {}
        }
    ]
}

Expected: It displays the User.Name field.

Actual: It does not display the User.Name field.