How to traverse an array and insert record by record in the database?

[Reginaldo Junior]

Hello, I have an integration that returns an array of objects which I need to insert into the database, is it possible to scroll using While present in the Flow Tool? How can I do this?

[Felipe Laera Ignacio]

Hi, how are you?

To iterate over your array you can use the "for" module tool.

You will need to pass your array as a parameter and put the modules that you use to insert the data between the start and end of the for. 

[Reginaldo Junior]

Thank you, it solved my problem!

[Caio Klein]

Reginaldo,

Dependendo do volume de dados você pode inserir um array json com múltiplos registros (onde cada elemento é um objeto que representa uma linha do seu banco) diretamente nas tabelas do seu banco em um único comando.

Para isso é necessário usar funções dos bancos que mapeiam o JSON para as tabelas.

Colocamos alguns exemplos aqui:

Abraço,

Caio

--
You received this message because you are subscribed to the Google Groups "integra" group.
To unsubscribe from this group and stop receiving emails from it, send an email to integra-sky...@skyone.solutions.
To view this discussion on the web visit https://groups.google.com/a/skyone.solutions/d/msgid/integra-sky/ae48932e-502a-4d22-b3ca-b8be500e87ean%40skyone.solutions.