Source HTTP: Add pagination support

[davinchia]

Tell us about the problem you're trying to solve

Today the HTTP Source Connector ignores any sort of pagination token and just passes along the received JSON blob.

Describe the solution you’d like

If there is pagination, the HTTP request connector should iterate through all the pages, combine the blobs, and write the final list to the destination.

See scenario #1 of this user doc for real life use case.

Additional context

Add any other context or screenshots about the feature request here.

[cgardens]

@sherifnada

[islador]

There are numerous pagination strategies out there: limits, pages, etc. It'd be ideal if it were possible for the exact keys used to be specified during configuration.

[sherifnada]

won't do given that we released the CDK which is a better fit for such cases