Question

When the state is empty and the AWS lambda returns hasMore = true, will Fivetran call the lambda function immediately and will continue to call it indefinitely as long as hasMore = true ?

Environment

Connector: AWS Lambda

Answer

If hasMore = true

Yes, we call the Lambda Function immediately and we will continue to call until we receive hasMore = false

If hasMore = false

We will not call the Lambda Function anymore until the next sync.

Notes

hasMore is an indicator for Fivetran to make a follow-up call for fetching the next set of data. Fivetran keeps making repeated calls until it receives hasMore = false. If the connector continuously runs for six hours, it will reschedule and save intermediate progress.

For more information about the function response format, please check the documentation here.