Java pagination

gabriel.sroka · December 9, 2022, 8:31pm

Pagination doesn’t seem to work with Java SDK 10.0. I’ve read old posts and old readmes.

I created an issue 6 days ago, but didn’t see a response:

github.com/okta/okta-sdk-java

pagination is not automatic

opened 03:44PM - 03 Dec 22 UTC

gabrielsroka

bug

### Describe the bug? 1. The readme says that pagination is automatic, but do…esn't provide a complete example. what does "automatic" mean? i don't have to write additional code? i was able to get this working, but i don't know if it's correct. is there a better/shorter way? does the SDK do some of this for me? (i'm not a Java programmer.) ```java import com.okta.sdk.client.Clients; import com.okta.sdk.resource.common.PagedList; import org.openapitools.client.ApiClient; import org.openapitools.client.api.UserApi; import org.openapitools.client.model.User; class Main { public static void main(String[] args) { ApiClient client = Clients.builder().build(); UserApi userApi = new UserApi(client); String filter = "profile.lastName eq \"Doe\""; String after = null; do { PagedList<User> usersPagedList = userApi.listUsersWithPaginationInfo(null, after, 2, filter, null, null, null); for (User user : usersPagedList.getItems()) { System.out.println(user.getProfile().getLogin()); } after = getAfter(usersPagedList.getNextPage()); } while (after != null); } public static String getAfter(String nextPage) { String after = null; if (nextPage != null) { String query = nextPage.split("\\?")[1]; for (String pair : query.split("&")) { String[] nv = pair.split("=", 2); if (nv[0].equals("after")) after = nv[1]; } } return after; } } ``` https://replit.com/@gabrielsroka/okta-sdk-java#Main.java parts of ^^ were stolen from https://github.com/okta/okta-sdk-java/blob/cb0a648f39f2f7a7c72912d5c19bac0c44102f1e/integration-tests/src/test/groovy/com/okta/sdk/tests/it/UsersIT.groovy#L874-L880 2. Either way, the readme is wrong. `after` below should be the 2nd argument, not the 1st: https://github.com/okta/okta-sdk-java/blob/cb0a648f39f2f7a7c72912d5c19bac0c44102f1e/README.md?plain=1#L423-L427 same with https://github.com/okta/okta-sdk-java/blob/cb0a648f39f2f7a7c72912d5c19bac0c44102f1e/examples/quickstart/src/main/java/quickstart/ReadmeSnippets.java#L282-L286 3. You can't use `q` to paginate users or groups, because the API doesn't return link headers when using `q`, so this: ```java String q = "Doe"; PagedList<User> usersPagedList = userApi.listUsersWithPaginationInfo(q, after, 2, null, null, null, null); ``` returns this exception ``` Exception in thread "main" java.lang.NullPointerException: Cannot invoke "java.util.List.iterator()" because "linkHeaders" is null at org.openapitools.client.api.UserApi.listUsersWithPaginationInfo(UserApi.java:3506) ``` Note that apps, authorizationServers, idps, logs, etc. do return link headers with `q`, but users, groups, etc. don't. 4. This example doesn't work: https://github.com/okta/okta-sdk-java/blob/cb0a648f39f2f7a7c72912d5c19bac0c44102f1e/README.md?plain=1#L184-L185 same with https://github.com/okta/okta-sdk-java/blob/cb0a648f39f2f7a7c72912d5c19bac0c44102f1e/examples/quickstart/src/main/java/quickstart/ReadmeSnippets.java#L103-L104 it'd need to be one of these: ```java // q by email List<User> users = userApi.listUsers("jcoder@example.com", null, 5, null, null, null, null); // search by email List<User> users = userApi.listUsers(null, null, 5, null, "profile.email eq \"jcoder@example.com\"", null, null); ``` ### What is expected to happen? automatic pagination ### What is the actual behavior? it doesn't paginate. i had to write the code to figure out `after` and add the loop. ### Reproduction Steps? see above ### Additional Information? _No response_ ### Java Version openjdk version "17.0.3" ### SDK Version 10.0 ### OS version NAME="Ubuntu" VERSION="20.04.2 LTS (Focal Fossa)" ID=ubuntu ID_LIKE=debian PRETTY_NAME="Ubuntu 20.04.2 LTS" VERSION_ID="20.04" VERSION_CODENAME=focal UBUNTU_CODENAME=focal

What’s the SLA on responses?

Thanks.

gabriel.sroka · December 14, 2022, 3:12pm

Thanks for your reply but it doesn’t seem to answer the question at all, whatsoever.

I’m asking about the Okta Java SDK, not mysql. Please check the question above and the linked GitHub Issue.

akrishnakumar · December 21, 2022, 6:20pm

@gabriel.sroka Thanks for the post!

Please follow pagination is not automatic · Issue #787 · okta/okta-sdk-java · GitHub for updates on this.

system · December 23, 2022, 6:40pm

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.