You should convert the service connector response to a Process Object List, so that you can iterate over the list for each record.
Can you provide more information if you have already done this part ? Since you mentioned you are able to fetch the top record.
Once you have a list which has multiple elements and you want to store each in you dabase, you can follow below KB to loop around the lsit and insert record once by once using a create step on your JDBC connection.
Are you able to achieve the use case?
Thank You Anand, the KB which you shared help me achieve the task.