A very simplified example

example.ts

@Injectable()
export class ExampleService {
  readonly totalCount = httpResource<number>('exampleCountUrl', {
    defaultValue: 0,
  });

  readonly limit = signal(50);
  readonly page = signal(0);

  private readonly offset = computed(() => this.page() * this.limit());

  readonly todosFetcherResource = httpResource<MediaTitle[]>(
    () => {
      if (this.totalCount.value() <= this.offset()) return; // disable the resource by returning undefined
      return {
        url: 'exampleMediaTitleListUrl',
        params: {
          limit: this.limit(),
          offset: this.offset(),
        },
      };
    },
    {
      defaultValue: [],
    }
  );

  readonly mergedArray = linkedSignal<MediaTitle[], MediaTitle[]>(
    {
      source: () => this.todosFetcherResource.value(),
      computation: (source, prev) =>
        prev ? [...prev.value, ...source] : source,
      equal: (a, b) => {
        // you can use a better comparison here
        // but length will probably be the only thing that changes
        return a.length === b.length;
      },
    },
  );

  onNearEndScroll() {
    this.page.update((v) => v + 1);
  }
}