Limit the number of records returned when using an encoded query string

[jeremyduffy]

I have a servicenow connector from a Copilot agent, but it is erroring due to the size of the returned data. I'd like to reduce the returned records to a manageable amount, but how can I do that? I already tried adding ^sysparm_record_count=10 to the end of the string, but it doesn't seem to have had any effect. To be certain, I even reduced it to 2 records, but the result is the same. It says the return is too large which suggests I'm using the wrong limiter.

I have searched online and in documentation, but not found an answer.

[jeremyduffy]

I have a "get records" option, not "structure connector interface". Get records asks for a record type value (what table) and a query (a query string).

[jeremyduffy · Accepted solution]

It turns out that you can "add input" for the Inputs section. Along with "Record Type" and "Query" there's a separate "limit" option where you can directly limit the results returned.