Try our conversational search powered by Generative AI!
AI OnAI Off
EPiServer.Profiles.Client 1.9.0
EPiServer.Profiles.Client 1.9.1
Jul 18, 2019
Jul 30, 2019
Closed, Fixed and tested
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.