One to Many Request Delay

Integrator.io
, , ,
1

Hello All,

I need your valuable insights! While performing one-to-many requests on a database record, we're experiencing overload issues. Out of four requests, one often fails, but retrying the failed request succeeds in updating the record.

To address this, I've created a Celigo flow for automatic error retries. However, I'd love to hear if any of you faced similar challenges and how you tackled them.

Also, can we add delay while making one to many request?

Please share your experiences and ideas.

2

@yashkumar what database type are you using and what is the concurrency level on your connection settings?

3

We are making post request to Microsoft Dynamics365 business central. Concurrency is default

4

@yashkumar by default do you mean the field is blank? If so, you should specify a concurrency level so that we don't make too many requests at a time.

5

Are you referring to the below field on the import to define the concurrency here ? Also Unlike NetSuite we don't have an option to define concurrency for the business central connection.

5301043caa20740200000001-2e5d33cf881044ba912150a6c359e4ae.png
5301043caa20740200000001-2e5d33cf881044ba912150a6c359e4ae.png783×507 14.3 KB

6

@yashkumar concurrency level is on the connection resource itself and not on import/export/flow resources. Here is a screenshot of a BC 365 concurrency setting on the connection level.

5301043caa20740200000001-25b178e789984cd2b0c30516c6c55b55.png
5301043caa20740200000001-25b178e789984cd2b0c30516c6c55b55.png2232×1253 121 KB

Also, here are a few good docs explaining how concurrency works:

7

Thanks Tyler! I though there is something different setting in case of one-many request.

I'll try with this