not getting third party data at once through integration

akankshak15
Tera Guru

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 

12 REPLIES 12

Hi @Ankur Bawiskar 

In third party system data is available in pagination and the type of API is rest api and configure this through custom action in flow and through the subflow creating the records

@akankshak15 

how is the JSON looking like?

Is it huge JSON file?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

is not huge only 15 key pair values are there in JSON response but records which we are receiving are in huge number like 500 and 600 

and JSON is array of object format 

@Ankur Bawiskar 

its not huge only 15 key pair values are there in JSON response but records which we are receiving are in huge number like 500 and 600 

and JSON is array of object format 

@akankshak15 

since you said from postman you are getting complete JSON, then some config issue in flow or subflow or action

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader