msgraph-sdk-java
msgraph-sdk-java copied to clipboard
microsoftgraph
delta group query call for members
Hi I'm unable to get delta member list for groups using the initial delta query. This is the code for executing the query
public DirectoryObjectCollectionPage getGroupDeltaMembers() {
LinkedList<Option> requestOptions = new LinkedList<Option>();
requestOptions.add(new HeaderOption("ConsistencyLevel", "eventual"));
GroupDeltaCollectionRequestBuilder groupReq = client.getGraphServiceClient().groups().delta();
GroupDeltaCollectionPage groupPage = null;
int count = 0;
int grpCount = 0;
List<Group> groups = null;
String displayName = null;
String id = null;
String description = null;
// do {
// if (count == 0) {
groupPage = groupReq.buildRequest(requestOptions)
// .delta()
.filter(" id eq 'bc5bef51-2571-46e2-8d47-3d787e7ea083'")
// .filter("id eq '" + graphIdString + "'")
.select("id,description,displayName,onPremisesSamAccountName,createdDateTime,members")
//.expand("members")
.get();
groups = groupPage.getCurrentPage();
// AdditionalDataManager additionalDataManager = groupPage.additionalDataManager();
Group firstGroup = groups.get(0);
id = firstGroup.id;
displayName = firstGroup.displayName;
description = firstGroup.description;
String onPremisesSamAccountName = firstGroup.onPremisesSamAccountName;
OffsetDateTime createdDateTime = firstGroup.createdDateTime;
DirectoryObjectCollectionPage members = firstGroup.members;
count++;
log.info("Page# " + count);
log.info("GRAPH Group ID: " + id);
log.info("GRAPH Group Name: " + displayName);
log.info("GRAPH Group Description: " + description);
log.info("GRAPH Group onPremisesSamAccountName: " + onPremisesSamAccountName);
log.info("GRAPH Group createdDateTime: " + createdDateTime);
log.info("GRAPH Group Members: " + members);
count++;
log.info("Page# " + count);
return members;
}
Expected behavior
"members@delta": [ { "@odata.type": "#microsoft.graph.user", "id": "24d9a7d8-8cb5-4fbb-a2dd-bb7226b22b5f" }, { "@odata.type": "#microsoft.graph.user", "id": "eedadebe-fb8c-456a-b480-1b23a69e0192" }, { "@odata.type": "#microsoft.graph.user", "id": "9f11ed87-e3a5-4a95-a5a3-0b6423da39ed" }, { "@odata.type": "#microsoft.graph.user", "id": "d9fd16bf-41fc-4a2d-8c16-d94dc7fd671d" }, { "@odata.type": "#microsoft.graph.user", "id": "530fc5da-faaf-4059-9cb1-51cd9cdb3645" }, { "@odata.type": "#microsoft.graph.user", "id": "76f569e5-af21-4fe5-982d-493290bce248" }, { "@odata.type": "#microsoft.graph.user", "id": "465b42d6-c97f-41d9-a8e4-f09aaa0631ae" }, { "@odata.type": "#microsoft.graph.user", "id": "ae99443d-a80b-4e49-af47-9f2f48306b51" }, { "@odata.type": "#microsoft.graph.user", "id": "49548968-d62c-43b9-a494-8fbd10198524" } ]
Actual behavior
Steps to reproduce the behavior
Following files attached GraphResource.java GraphClient.java end point /graph/getGroupDeltaMembers
Console Log:
2022-09-06 09:50:03,484 INFO [com.gm.GraphResource] (executor-thread-0) Page# 1 2022-09-06 09:50:03,486 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group ID: bc5bef51-2571-46e2-8d47-3d787e7ea083 2022-09-06 09:50:03,488 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Name: jvawt_honda_sav_body 2022-09-06 09:50:03,492 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Description: Stephen Gross Body Work Team 2022-09-06 09:50:03,492 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group onPremisesSamAccountName: JVAWT_Honda_SAV_Body 2022-09-06 09:50:03,493 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group createdDateTime: 2020-11-10T20:16:27Z 2022-09-06 09:50:03,493 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Members: null 2022-09-06 09:50:03,494 INFO [com.gm.GraphResource] (executor-thread-0) Page# 2
GraphClient.txt GraphResource.txt
This is the query I'm running in insomnia
https://graph.microsoft.com/v1.0/groups/delta?%24filter=id%20eq%20'bc5bef51-2571-46e2-8d47-3d787e7ea083'&%24select=id,description,displayName,onPremisesSamAccountName,createdDateTime,members
I get the following result:
{ "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#groups(id,description,displayName,onPremisesSamAccountName,createdDateTime,members)", "@odata.nextLink": "https://graph.microsoft.com/v1.0/groups/delta?$skiptoken=m3Kv4K6Avb1-QZZIW3XL8pxp6-iqA2j9IzyPsnkP_wZh0-YIYgDQ7nUdkK1nl5xrkT58FEMCRT6vouuDMRTVQFVoVdy4BdyV3fKXQ6CSD4m3_tPLMiq7wdEAYV4xZH6aq868uUir0wdVImn7Aqk6dgNt8JinZ4fqFOI8GlRVLl1ucBfmvglv3j2cv06O89YheMIhpWbZK4pPHSeVZUb8GnNnyJl2WRFa_FXLEcPk0MSLCPTkher33csOPUB1sRQL58flPHQh1OURdCvMB9JJfPxOlhKzwn9_z0IjEdRgBPZA9-IcvWDWACryUGJuUinRxcgEh1fTt6ZXk5HWn506deORIw5ZHzpCS2wot-FnG5k4uUO4yCt0EkjRstaQbv6TiQfuR8XIJYsJAc0H2jSQwGSU7yn_q_TNJfT9aZLXDE1BX_owIcC6YQy3jIS0yLXAlo-t6vcNuYDznHrvFsg3S4sddWyo1uVHkol3VbyYnVtkqWwQ_RixHqu3lk8Wi4to3JA3fmzzJMJcs71CdX5aZz6GsUhQMyaXqn_QFieHxPe56npF-Sfy7Zs82NuPdaHif9tF4p1stcnodBTLDHn4Pd4KG9gOlTkkKOsi5LwqHogFscrpTTfifZHEgSb7p4JRQcQtRlGXRQni1RwHkD_e-EyrJt9RWxRqV5yr3C5mHNhxpvQLgoXsvprG9pkXvUdUDUFdg9oUILjSOCuL4Ef3vQ7NmXtQ1Zy4_0bv2ffNcexfJcVGt-uwmX7BskTSCYCcwcTE23Rkyzd2AdQdCWSMZ8Ls5PXzn-KvZy-OVZmlAfvOeHKbtpLV45vJLK8smXH0Ov9uFLCmAlaOWOKjYpQXLCEsk2RjQflj-wZZp4X9m-Zc_sH_x0gUOWIsNxC08mivMRcrk2ymjeHSi-gM75FRi2nv8_MkiBlvwBqzNOdtaJ2kCCkqJGZSTs9QXy5GgQmz3LJJE92LxZEETnpV-q_RCDKEf25lffiu5TfXjzanF3Lm46SmOtA2VRTC4IDlQCcsroyyyHiJHRzTbl4BPBCdNeBnMR7pvZmnn5RDbQDYDtLGuV1Pa_FvM_kcdFmxuHx8GX_7J1doEvGzkdR449zV3fsCMZqmfQr-89Q7XuVGFHoF6GbGCzVn986y3a5UfjctEHXhW7KHwLZyi8FvbYKCx9FaGO_t2zhXByiOSqRYMwFUnVueHbHqwVCnTYFnICUk-F7ypUCCR0iO8v0K2iRGxI35erlCUGQlU9XGjTeofaQgmid72TQCtzRqbiYvgdKsZOoQ_GBp3W2A_AQZg5woxrDwu0mSNA6fgMVkr05bS2aOJ8mVz30ZKiYclxhvRu38vRzhtPsr3E7sGAQuUzVfcD2qN-9FGWPJaD-iX68XdIohcOa0ySnSI-wE-VYHsoAq2BYEQHbXgSSGeQTJNHGLIH7u5G9T1U9cvm9Qlos9K2Fwfgb6NeyRgY97CG2Do_YnX9Py_EvXCyll-fgitNjDIofbwlIkFbcxzoFJ322QHcKoXnDmJdsSAiNWXCBwQzCnzVRSVD61Vu6bAj6IX96vlmHw5xfPxDfBj9G4A1RWAccmF3tVDW8lV70QyiZr5ME0j7x9OY5zXVqQFTp0glJ1TaEqqSTcTlfgXVGNTYV2-xXQ5x5gRC9nBvmwMXSW-unD8KRqxTPPNttcfSJGggXUVPv5E7CgrB1xWhU_B92b7nIw5F6XhQbGj5RMWvm2KR4LHxjtGF1RePp9pOYSJJ3WJzZXic-2rnz-z5JxQwtqfgj1EqzHsSpLoCvv_8kx3K4gY4PwHCgbuwwrhXOU7aNMR7ivi-zURmPAc_wjfsR7qQUuPLvm_wvcwkK73OVx0jCXEvVii9YfO6-irLJBv1BdQY6uSRplm5ESvk6us_0csREMbRoRYzdgbrSjNvkx3iU2xb0eUUucxAJ5fLItdlzZMgV3bjO-tbUsb1e6fY8rcUvvJcf6jp5-ADqCGk7pAR1aUoWflLKwuT2DvGbmOiYon1E1YssL5TmnQTdnD21rgxj9obvy0oYmlVdPTNCxNg9bnR9HHplCJzObff8gxL_BD0dwfKUUty2X7n3rSmvKNuoZTBjV0zcD_oKoW34oZfAna6bslyUTRjArGfnVgd2EqkSIHMIg8qCIvi8H1WsJ-fMM4BpshDgnxN72-lkgXPnacXZZ_eiijP5tYqycT42yeqeEP3qgaoMW5zKJQICewFcuku87I9kSJSqM4rUsUaky1lQNRcpKY1Rx-iHLeF2d9cV0SaiO4BHhs-QfMnzioIJpjiAID1W1uAplCi88Q2p-1SigqmYxnDzYMPPEKbkadLTFwBLSJao7AxMlyST0TTmAXvKp3LxESM5HXyT-Q98pgmrGBO9D4_D0RdJzwOY2a815Doo8KMRG59H_4IfLXf9-L_lL7jDJzm52UIoRl8LjHZBEpGdzlDnF3Bg3x4zF-KRSQQAhSSv5OcIAmU9nyCDdlKJc8RSMslk8zuO8OwVF3i9-fII-Res9haLYVmA93fcHZiKTTA0KGAx9wsrB93h1M0Ey-KJiJlhjBCUf02UIPSgxK4y8arTMu8Sa2imjclyPIIun0-9h5dX81Kjc04q0FNtLYWSKv4Cr3v_qLt5Wi7uxjR-Z1v8sCaRvq1JQ1B1M0j49vwwQZ85d2pp6t9B-u2DgaGwOaGLj2o63g0JFKWQxIcp1NBOx-eZih2Cng6usTHWtT-XXm_ss4PS0tuezpFsApbV3-ljvztNT1FTNdxMUOr_nBgVqOvyhPYypJsypm69MT6t2q7Sr3-hiJYHsWyeeavlsVaLZVkV2S7GAih-sJCW-R80pBbwIeeqVHxtM006pvxF51vttNG7DlNEZ4HPKs9pI6Eda6dmQDGoo_X1m21A_qYPyPmTf32j8s6OkGiIU5GeDsQksLfj_BnWvsXMTj6ua3gwYTgOJYUorzW-KXbSRCzEjefY8uzSxeQG57xz8yUV1P5n3qhPDoqxKMHof_MCyJC-AjAxJHoVxEqvn2773Ww5BQqDuqVQAlTF5EUoc7tVVo7oHteXfxpeoN8lCSXzu0N2JaHNFm4RKSmxVNiuOKUXKuopC3owz27FbKw9QdoBxuyZjF_KJiidMRF6h3Og1LOjc_I2klQo0Cka-j6E6BpeEYehJy4E7ho9451iYhQ16Na9N2QvITA1tYb8lF2E8qi61seTGTj6MY1weUmLTx0qsCHoquh54r2gUjotqTUQGfmIg24AgPuSNCFMbuVEekKIYqKXB_NfydYPPeJPkCCUlmvajoFF9ibt8H-Evecnd5L_5Ph1c1cJ-DxE2QuUaEQ_4Z1_KQE2lRXkWMg5mAQ4SUPb7nN5CZhC8K-42DJuzVnDWZbp9e9myzoZXTLw1iG8IUBgssvWaYdZBRm5KnrUYVJ5OYNZDmujeWEJyipQTtR9BfBXFuypcAKawzFfASZbL4L_gzC7y8karg5MmI5wWG2Q3IbW_v_BaC_NVhtRgPQFFQfVqaQ4ipIJYYlsMhFJ1_v4Nq06JSTfGnkcdxGBJCjiUlP7qtw8KDQtyjtHYLMKdSsrl_SIdkFoGUN1oXYLo97jdlihmgXy-widd2m-o31pZV4kk7sI3lk8i_k9008RmnogQQasQ0iFMqlroyKpuL-jQLMoUmdSbx0nx-KY7lz57K49W8CDdv21FoVofDIrfVDH9VYgMZqlPzmSyuq18Q4hFkkhhzbGdt8Nd6bp4nnTYZKESaoImGtdTqviwK_LBer2QA_fv508SbKdBtPYqnXFFTxuLtCXgksRcL4VgUb6imdSVHH0x2G3p8PJHkvytdM0xfQYb6Xkt1HErGSB6knynp1x9VAgIqai-8eVsuU-GP1jeGPV1rtSbDzv_c8IZU2BZ5OOFXAZRpOwBL3d7nHcz5yV9J4X8Jkzx2R8tMImyWIGrvZChvZaShM_Ooo_CRf4i_ILhjs9TDwCET5i_SrOnlXCvI7W_avr6g1RVkQN2Q_2yRJ5ZWDukNx9cgxdhiTPzV3wmB5jbebdPCW6f8ylNjsGAMfyQvcXRztGrEngT4XiexM3R7adU5X8Oj3YMTPbeOwDYjvZFzcEzomM00wz5izNk6NEp0HcYjTXKI9c9VuwqEcwkvIAf8AzX2IErwOL3bIlC35_XKPhQYtTv6DP09pf_Dj3hDnZckOehhh_c-j6WzQSxgUdREdN6JomQsvwZU20UG5wnBbd29cp4oq7D7ylc0XxPbGGtkOh1x28FM2Cfs420J1chUcxKptU-r-gOfGegAwwLWTUGTrFLolvgd0zI4AomXGQF7FG0U8SpqVIlYj2RVjn3uayMcNYmd7CVqKiMX3HdcLf4Ablwqw3OU6-73FBIBxkLlVmP7BAze7-zGbO7VUQxUh4sz78r39E21Z5wlnaGauBmtDBrBICQyyKpfz7oM7uzqKIvVOxOvU40BYG2BFuUQNQtoAlaNw4SfcIsXIbNhMSDW_bXz5vr_mZeRjhNv6mgTuxF249Z8KlEiTtZChjySzYqCK3ESgpV6cyLTp_HdrFAyR4r-QdlRy1GCtgn8odz6I_uUMttrHd62yX4ul7DAtuAEEUdp-GGj-tma3uqoX7EF4ytYIPVzFA6O4SnIboP28BA5LjCx6r9ewarw1VhfDNKvbFsM0I0ousutgP0PZcCUnQTx7PhUvn8RzR5ge1av1dCShCjLa5OWPDz5oO7SSLoRnS2HJc9Zxg2b5YBuB8TMMwN6Mk59bdpyGiT56LnpuHGWYX4b7wWnKlyPl2zuV9hryc1Bcvd0jNktBjMKRWo_MGYX-QvvP9n3uSs_r_MWE1SYJC_BWgK9oi9FyciW2J2nhfcdjlMHHSEElPQ4pbxNnVEHK4A2tn27OS5C4etSJK4dKkzFS0gzRznC_avdbQ6lZalhFcIksoGegwN1GCTZsMBf-7YhFlNq-6MrfFnQRMDKLlmh0WRQaDLz_5VGo1cU-HQ8c5-mOPRYZdKZCfg5LZHlZZhFVa6cFHmKA4o4Pwb_asxV54KI0O2aHTHaWVkMXwriBECd1ufh6WUHgdJDYQcJssnL06VMR7XB-h-Lz1cBX5QIqLcHXBwSeUCBadFdBhRtI-BIVLs2wc8jg9WEM4w7eAk82-PtjH62aDyPGEjmQrcAcMm5068YMTQwtYPJdyrY5AxfJmFUnS56kTWPGqHsU8ixCLtWNMS9BRflZHaAwdRCNWWd89o4UiUT87Eo0j7zk8XZHIliN5dUIAsltef8Lyv9Y1Xcdnnz4ytUdeB4jZULFvYAKvimr3FMw8dmmMfAIIlhMCT8r-fUer-O77o7J6EvpX8d5AbbZDnuD0sDK9vb2VWAodjt8-OA2ueWm1Boj6zPKOwDnQgrY9m1ZwZlc18WpXStCFMoW_Vd_a_BxC9dQ2IIumfCFCnIwzJPpQUSmwEYxxIJLiRDXDxBsA0t5-02FdByxg3UBAPtYnORNzVEEZMI4WnukW1vxPMvSoCb7zszoJ5S7zK06rLH-16bR2nby5lo-ggxvDA6A4OZFkXcC57t7DhIFwD8s66nSNVCuhqIqKfh-yBZU5B5pk7-yYu0w53BOMlxhCzoHWfjTC9-JloPFju2_bgeVqfZWDrF1YJecuke00m89-fSWU92jop8eWJUP2-Y1BrGvb3ieICkh9RetFpxy54jJofBrNvXWmjSMBizMqjryF4i3hihHSiqPVI1pkPnZdWDMclqjhBtQ1j1LxaKnohss4CPCbD2eoDsNFlMT4XJoqqE5N2Rz7QTS75LuFceNZkPSYLzMsH1M-33A60lWgw0EJoyxqK16jj96K3-e7ePjdY3baPpz0vK6edLpSxhAzslGiI8fpv-zi-1QgbiOrt4cUFNrmSCSuJQu98hWLV-Tw8Cqf1YUi_MuiiBVfkKCr9MGvhVjp3_CT7oObE4uWbhecQw6tlhAxPXH9V7c9k3VBEVO9eqxHOjy4mxZf8eq5yzpAwJPY509LmxdRuJDJnn7dwtHbtklZkiDXB3SDCdCH1g_K6ddsCPr.0NsRYBfYaTXPxsHT7f3mUDYU0e2bujDl4yBIToH2QNs", "value": [ { "description": "Stephen Gross Body Work Team", "displayName": "jvawt_honda_sav_body", "onPremisesSamAccountName": "JVAWT_Honda_SAV_Body", "createdDateTime": "2020-11-10T20:16:27Z", "id": "bc5bef51-2571-46e2-8d47-3d787e7ea083", "members@delta": [ { "@odata.type": "#microsoft.graph.user", "id": "24d9a7d8-8cb5-4fbb-a2dd-bb7226b22b5f" }, { "@odata.type": "#microsoft.graph.user", "id": "eedadebe-fb8c-456a-b480-1b23a69e0192" }, { "@odata.type": "#microsoft.graph.user", "id": "9f11ed87-e3a5-4a95-a5a3-0b6423da39ed" }, { "@odata.type": "#microsoft.graph.user", "id": "d9fd16bf-41fc-4a2d-8c16-d94dc7fd671d" }, { "@odata.type": "#microsoft.graph.user", "id": "530fc5da-faaf-4059-9cb1-51cd9cdb3645" }, { "@odata.type": "#microsoft.graph.user", "id": "76f569e5-af21-4fe5-982d-493290bce248" }, { "@odata.type": "#microsoft.graph.user", "id": "465b42d6-c97f-41d9-a8e4-f09aaa0631ae" }, { "@odata.type": "#microsoft.graph.user", "id": "ae99443d-a80b-4e49-af47-9f2f48306b51" }, { "@odata.type": "#microsoft.graph.user", "id": "49548968-d62c-43b9-a494-8fbd10198524" } ] } ] }
We are seeing same behavior for owners@delta wherein the java sdk is not returning the owners for the group.
Updated GraphResource.java attached for reference.
Console logs 2022-09-06 10:52:19,688 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group ID: 77646912-a056-4cd9-b276-4c7b0695e7f1 2022-09-06 10:52:19,689 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Name: Overall 2022-09-06 10:52:19,689 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Description: Overall 2022-09-06 10:52:19,689 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group onPremisesSamAccountName: null 2022-09-06 10:52:19,689 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group createdDateTime: 2016-05-11T19:19:30Z 2022-09-06 10:52:19,690 INFO [com.gm.GraphResource] (executor-thread-0) GRAPH Group Members: null 2022-09-06 10:52:19,690 INFO [com.gm.Graph GraphResource - Owners-Delta.txt Resource] (executor-thread-0) GRAPH Group Owners: null
@ramsessanchez Can you help us to review this query? Thanks in advance for the help!
Hi @mkariro, apologies for the overdue delay. Could you please try the following your variation of the following snippet:
LinkedList<Option> requestOptions = new LinkedList<Option>();
requestOptions.add(new QueryOption("?$select", "id,description,displayName,members"));
GroupDeltaCollectionPage delta = graphClient.groups()
.delta()
.buildRequest( requestOptions )
.filter("id eq 'GroupID'")
.expand("members")
.get();
Hi,
I've made the suggested changes but still cant get the member list for group delta. Please find attached GraphResource.java, console_log.txt and json.txt for your reference.
Please use end point /graph/initialDeltaQuery which calls the function executeInitialDeltaQueryTest created for this testing.
Thanks Mahinder console_log.txt json.txt GraphResource.java.txt
Sorry for the late reply, we've been working hard to release a new major version of the SDK Since this is an issue with the older version, we'll be closing it for now. Please go ahead and try with this new version, if you're still facing issues, feel free to open a new issue.
