First, create an input that is a JSON data type.
Secondly, open the Query all Records function. In the Output tab, under return enable paging.
Next, link the configuration in the External query tab to the JSON input using the drop down menu. Additionally, select "Allow Page Override" and "Allow Per Page Override" permission. (Note: you can choose just one between Page Override and Per Page Override or both. Determine what works best for your use case).
Now, we are ready do paging by the external query. Because the external query takes a JSON input, we must format the input in a JSON like the examples below.
The below JSON object uses both Page Override and Per Page Override. It will return page 1 and 2 items per page:
The below JSON input would be used for just Page Override:
The below JSON input would be used for just Per Page Override: