I am using the following:
WITH 'https://xxx.service-now.com/api/now/table/sys_user?sysparm_fields=name,title,sys_id,email&sysparm_query=activeINtrue' AS uri
CALL apoc.load.jsonParams(uri, {Authorization: 'Bearer xxx'}, null)
YIELD value
UNWIND value....