Query limit for ADF ServiceNow connector

[ramanv0109]

We are trying to integrate ServiceNow with Azure ADF. When they try to get the data from ServiceNow, the connector is breaking down the query into chunks of 300, because of this the data transfer is taking more time. Is there any possibility increase this chunk size?

[AnveshKumar M · Accepted solution]

Hi @ramanv0109 

The ADF service now connector uses OOTB Table API only and by design you can not change the sysparm_limit value in the connector configuration.

Instead you can call the TABLE REST API directly from ADF without using connector which will give you much more flexibility in querying as well as limits and the performance will be increased a lot.

Please mark my answer helpful and accept as solution if it helped you 👍✅

[ramanv0109]

@AnveshKumar M Thanks for your response. It is very helpful. Do they need to model the database in ADF again?

[AnveshKumar M]

@ramanv0109 Yes they have to.