Workday integration

[Ashutosh4]

Hello Team, 

I have this issue where , I am facing this error.

This speicfically happens when the HR profiles are being created or udpated via WD integration.

I tried to check further into it

This is where it takes time , it basically calls into WD and pulls data into Staging table.

Do we have any method to resolve this?

[Ashutosh4]

@Ankur Bawiskar : Also One thing I noticed that, the data comes in completely into the staging table completely, the transform is where this issues comes up, i feel maybe it is something happening in correctly IN flow designer like timeout or something.

Tanushree shared something similar experience she had as well,  I am trying to understand that

[Ankur Bawiskar]

@Ashutosh4 

so you can try to debug and see how many records are imported

can that process be made asynchronous?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @Ashutosh4 

This appears to be a Flow Designer issue related to the Look Up Records action.

We encountered the same issue while using the Azure spoke, where we attempted to retrieve approximately 10,000 records in a single execution.

As a workaround, we divided the expected data into smaller batches by updating the query used in the Look Up Records action. We then executed the flow through a scheduled job for each batch. With this approach, the flow completed successfully without any issues.

Same thing almost written in Servicenow documentation: Look Up Records action 

[Ashutosh4]

This helps TanuShree,

But one question , in my case 
I am calling another sub flow which goes in to The WD data and retrieves records and then passes through each of it.

Like how do we do it in batch ?

I am not very sure.

Example it has 11,313 records.

Currently it iterates through each.

so how do we make it in batch ?

[Ashutosh4]

This is where it takes lot of time, Liek how do i do it in batch ?