APIRest data to MySQL (Cpanel services) 🧐

[RRC]

I need your help to complete the next scenario:

I have an APIRest connected to a MongoDB atlas db, and I need to copy ad update some collections to MySQL db every Friday at 2pm.

Can I use Pabbly connect to do it?

 

[Pabblymember11]

Hey @RRC

Could you please tell us how much data you are having and what is the size of the row on it?

Further, the use case can be done in the following steps.

 

[RRC]

Hey @RRC

Could you please tell us how much data you are having and what is the size of the row on it?

Further, the use case can be done in the following steps.

View attachment 20252

The bigger collections have 1600 registers, what do you mean by row size? So each row has 12-15 data columns

 

[Pabblymember11]

Hey @RRC

I am afraid to say that your use case, will require the Iterator action step to pass the data at once whereas the Iterator action step can only have 500 records at a time.