collection$iterate()$batch(n=10000) returns "Error: Cannot advance a completed or failed cursor." instead of NULL when exhausted

[bfurtwa]

I think when the iterator is exhausted it should return NULL.

[enricodata]

did you solve this? I am having the same issue

[ploner]

I had the same issue. Solved it simply using:

it = collection$iterate(query) 
res = c() 
try(
  repeat({
    res = dplyr::bind_rows(res, it$page(size=10000))
  }),
  silent=TRUE
)

[pabecerra]

Me too have this issue. This is my solution:

it = con$iterate("{}")
out <- NULL

while(!is.null(tryCatch(x <- it$page(size=10000), 
                        error = function(e){x <<-  NULL}))){
  #Do something
  out <- dplyr::bind_rows(out, x)
}