a small remark, I’m unsure if this is relevant or not with QueryTool Beta 20.1.529:
select fle.totalpages from httpdownload@DataDictionary (url => 'https://myurl' , contentType => 'application/json' , headers => 'Authorization=Bearer mybearer' , diskCache => false , method => 'GET' ) htp join jsontable ( passing htp.contents_char columns nextpage_url varchar2 path 'next' ,totalpages integer path 'lastPage' ) fle;
htp.contents_char columns identifier is not filled correctly (for example lastpage instead of lastPage) then the data in the JSON table is not found, and this does not raise an error nor a warning.
Maybe that could be interesting to check, preventing headaches in finding wrong typos unless this behaviour is expected to prevent other cases I don’t have in mind.
Best to the Team