Pagination Works From Record Source but Not Record Listing

I do not see any obvious problems. Can you share more of your code? Especially I am interested in that local!integrationResponse. Starting with the integration object itself, you need to validate each and every step, making sure that the correct values go in and come out.

Two tips:

- You can cast a list of items without a foreach. Just cast to a!listType(<YOUR_RECORD_TYPE>).

- You can extract all values form a list of items without a foreach -> "local!integrationResponse.result.body.items.id"

After your suggestions, here is my updated record data source:

a!localVariables(
  /* Call the integration and store the response in a local variable */
  local!integrationResponse: rule!YYY_searchRecords(
    pagingInfo: ri!pagingInfo,
    searchText: ri!searchText
  ),

  if(
    /* This will return true if the integration succeeds */
    local!integrationResponse.success,

    /* If needed, modify the expression below to return a list of maps, dictionaries, or CDTs that map to your record data */
    /* local!integrationResponse.result.body, */
    
    a!dataSubset(
      startIndex: ri!pagingInfo.startIndex,
      batchSize: ri!pagingInfo.batchSize,
      totalCount: local!integrationResponse.result.body.total_items,
      sort: ri!pagingInfo.sort,
      data: cast(
        a!listType('recordType!{ed44efbc-d562-4c71-b1ee-87905a73c395}YYY Record'),
        local!integrationResponse.result.body.items
      ),
      identifiers: local!integrationResponse.result.body.items.id
    ),
    

    /* If the integration is unsuccessful, handle accordingly */

    if(
      /* Note: handling of out of bounds exceptions varies by web service */
      tointeger(index(local!integrationResponse.result, "statusCode", 0)) = 416,

      /* If this is an out of bounds error, return an empty list to finish syncing */
      {},

      /* If this is a different error, return the integration error. */
      /* If you need additional logic to determine the error, use a!integrationError() in the integration to format the error displayed in the sync monitor */
      local!integrationResponse.error
    )
  )
)

I think I eliminated caching as the possible problem because when I set the number of records for the record listing to 1000, it lists all of those records.

Caching might only become an issue when the parameters do not change.

Does that local integrationResponse contain the expected data when paging?

Yes. Both the integration and the record data source properly page the data when testing individually.

Do you use it in a grid to display the data? Can you share that code?

Like the definition of the columns?

{
  a!gridColumn(
    label: "Col1",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col1}col1',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col1}col1']
  ),
  a!gridColumn(
    label: "Col2",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col2}col2',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col2}col2']
  ),
  a!gridColumn(
    label: "Col3",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col3}col3',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col3}col3']
  ),
  a!gridColumn(
    label: "Col4",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col4}col4',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col4}col4']
  ),
  a!gridColumn(
    label: "Col5",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col5}col5',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col5}col5']
  ),
  a!gridColumn(
    label: "Col6",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col6}col6',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col6}col6']
  ),
  a!gridColumn(
    label: "Col7",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col7}col7',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col7}col7']
  ),
  a!gridColumn(
    label: "Col8",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col8}col8',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col8}col8']
  ),
  a!gridColumn(
    label: "Col9",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col9}col9',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col9}col9']
  ),
  a!gridColumn(
    label: "Col10",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col10}col10',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col10}col10']
  ),
  a!gridColumn(
    label: "Col11",
    sortField: 'recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col11}col11',
    value: fv!row['recordType!{4d44effc-c462-4c70-b1aa-87905a73c395}YYY_MyRecord.fields.{col11}col11']
  )
}

:-) I need to see all the code, except the columns!

The grid needs to interact with your expression to read paged data from that API. There are a few way to do so and I am interested in the way how you did it.

I did not create an interface. I am just using the grid record list on the data record. I did not write the code for it.

How do I give you the code of the record list on the data record? I don't see any buttons that let me see the whole thing, just the columns. As far as I can see, Appian does not give a way to see that, but hopefully I am wrong.

OK. I understand. Then, there is no code.

Can you share the record source configuration? I mean, assuming that the API supports paging, the integration successfully applies paging, and the wrapper expression as well, the only spot left, is the source config.