APIRest data to MySQL (Cpanel services) ?

Status: Closed · Asked by RRC on · 0 views

RRC — Question ·

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 — Reply ·

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 — Reply ·
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.


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

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.

Back to all forum threads · Log in to reply