Pulling service now data into azure blob using Azure Service Now connector through ADF pipeline

Question

I am trying to pull entire incident table history from service now.

Using following items in my ADF Pipeline.

Service Now ADF Connector.

Using basic Service Now authentication and tested the connection, it works

Able to preview the records successfully.

Configured the sink to store the file as json output.

Used below query for testing it works. which is limited to just 20 rows.

SELECT number_value,short_description_value,state_value,sys_created_on_value,category_value,severity_value,sys_updated_on_value,assignment_group_value,sys_updated_by_value,opened_by_value FROM Actual.Incident where sys_created_on_value > (CURRENT_DATE - 365) limit 20;

Tried changing the query to pull all the records for past 365 days (sample query below).

SELECT number_value,short_description_value,state_value,sys_created_on_value,category_value,severity_value,sys_updated_on_value,assignment_group_value,sys_updated_by_value,opened_by_value FROM Actual.Incident where sys_created_on_value > (CURRENT_DATE - 365);

It never returns any rows or neither the pipeline fails.

Please share your thoughts or let me know if there is a workaround to resolve this.