@ismailp just stumbled upon this post and wanted to close the loop, I know it has been awhile ! Were you ever able to figure this out? I tested in our API Explorer and was able to get the query you posted in your last comment to work:
Let me know if you were ever able to figure it out or have any other issues!