When Filters / Query Params are passed into GET Contracts List, the value against total_rows is incorrect

  • Org name: Oahi WFM (Tambla WFM)
  • Detailed description of the issue and where it occurs:
  • Instance Login Email: oahidemo2@letsdeel.co
  1. User GET Contracts List API to fetch global_payroll contracts where status is “in_progress” filtered by Team_id the returned results shows total_rows = 193

GET https://api-sandbox.demo.deel.com/rest/v2/contracts?types[]=global_payroll&statuses[]=in_progress&team_id=a27aa8a9-8a73-4876-b719-643723517cc5&limit=100

  1. Screenshot of Response showing Returned Collection of Objects length is 14 however total_rows = 193
{
    "data": [
        {
            "id": "5e9xdz9",
            "title": "Adriana Costa - Group Lead",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:50:51.349Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "7edg42q",
            "title": "Clementia Hacquel - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:00.403Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "g4d862x",
            "title": "Darell Marriage - Product Management",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:26.904Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "ej5ryzx",
            "title": "Eberto Chatwin - Product Manager",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:23.770Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "r25wpqn",
            "title": "Elmo Christopherson - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:06.345Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "nrd97gy",
            "title": "Emir Ozturk - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:50:54.590Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "2xn9qvk",
            "title": "Gabi Van Arsdale - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:15.234Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "j4r5qev",
            "title": "Heidie Flatte - Product Manager",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:21.041Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "4x7gnr5",
            "title": "Idaline Goodings - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:12.202Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "zn26q4k",
            "title": "Jae Jiras - Marketing Lead",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:09.434Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "v89yxrn",
            "title": "Kameko Haselhurst - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:17.989Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "9k2gvdd",
            "title": "Morganne Eyree - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:03.552Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "y54rdzk",
            "title": "Nerti Heffernan - Team Lead",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:50:57.621Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        },
        {
            "id": "kxzn5g2",
            "title": "Sabrina Hawney - Software Engineer",
            "type": "global_payroll",
            "status": "in_progress",
            "client": {
                "team": {
                    "id": "a27aa8a9-8a73-4876-b719-643723517cc5",
                    "name": "US - group"
                }
            },
            "worker": null,
            "invitations": {
                "client_email": "",
                "worker_email": ""
            },
            "signatures": {
                "client_signed_at": null,
                "worker_signed_at": null,
                "worker_signature": ""
            },
            "is_shielded": false,
            "is_archived": false,
            "created_at": "2025-06-30T06:51:30.178Z",
            "termination_date": null,
            "notice_period": 0,
            "external_id": null
        }
    ],
    "page": {
        "cursor": "eyJsYXN0SWQiOjI3MTI5MzgwLCJzb3J0X2J5IjoiY29udHJhY3RfbmFtZSIsInNvcnRfb3JkZXIiOiJhc2MiLCJ0b3RhbCI6MTkzLCJsaW1pdCI6MTAwLCJsYXN0TmFtZSI6IlNhYnJpbmEgSGF3bmV5IC0gU29mdHdhcmUgRW5naW5lZXIiLCJ0ZWFtX2lkIjpbImEyN2FhOGE5LThhNzMtNDg3Ni1iNzE5LTY0MzcyMzUxN2NjNSJdLCJjb250cmFjdF90eXBlIjpbImdsb2JhbF9wYXlyb2xsIl0sInN0YXR1cyI6WyJpbl9wcm9ncmVzcyJdfQ",
        **"total_rows": 193**
    }
}