not getting third party data at once through integration

[akankshak15]

Hi All,

I have integrated ServiceNow with third party system and calling this integration through Ui macro, integration set up properly but i am not getting data at once if there are 200 records in the third-party system in ServiceNow we are getting like 30 records and then loading the table where updating the records next reload 45 and next reload 57 like this . is there any way i can get this data at once 

[JackieZhang]

then please test your flow to check the offset is correct or not？

[Its_Azar]

Hi @akankshak15 

this sounds like a pagination issue from the third-party API. mostt external systems limit the number of records returned per request (e.g., 30 r 50 records) to avoid performance issues. You’ll need to check if the third-party API supports pagination (using parameters like offset and limit or pageNumber). In your integration, implement a loop to make multiple calls until all records are retrieved, and then process them together.

Provide some screenshots or how the json looks like for better understanding.

If this helps kindly accept the solution thanks much.

[akankshak15]

"PVos": [
        {
            "PayeeName": "",
            "CustomerCode": "",
"Gender": "M",
            "IdType": "1",
            "PCode": "107",
            "Id": 100098877654,
            "PName": "test test",
            "RoleList": [
                {
                    "RoleName": "Employer",
                    "RoleType": "IND",
                   
                }
            ],
            "PType": "1",
           
        },
        {
            "PayeeName": "Asics",
            "CustomerCode": "",
            "Gender": "M",
            "IdType": "",
            "PCode": "1",
            "Id": 18687686802381,
            "PName": "_Test10",
            "RoleList": [
                {
                    "RoleName": "Driver",
                    "RoleType": "IND",
                   
                }
            ],
            "PType": "1",
           
        },

this kind of response data I'm getting i have attached two records response,