Is there a way to do a Row count at the beginning of each row in Integration Studio?

Originally replied by Aman Gaur on Feb 1, 2026, 2:28 AM.

Hello Eddie,

You can follow the below steps-

1. Create Integration and add first column as rowCount, in Dayforce field you can select whatever field you want to select as keeping that blank would generate error.
2. Now after creating integration click save.
3. Now go to View IDL and do the below changes in mapping instruction section:

mapping {

    root = map(source?.Data?, (srcData, srcDataIndex) => {

        Data = [{

            rowCount = srcDataIndex + 1;

            FirstName = srcData?.FirstName?;

        }];

    });

}

My integration has 2 columns, I just modifiedthe IDL for rowCount.

Below is my output:

I hope this helps.

Thanks.

Originally replied by Aman Gaur on Feb 2, 2026, 7:32 AM.

Hey Eddie,

Does that work for you?

Do let me know.

Thanks

Originally replied by Aman Gaur on Feb 1, 2026, 2:29 AM.

Keep rowCount as Number.

Originally replied by Eddie Heinzelman on Feb 5, 2026, 5:12 PM.

Yes, that helped. Thank you!!