How can I use all email addresses from a json array to send mail with sendinblue?

[dlimmer]

Hello,
How can I use all email addresses from a json array to send in sendinblue?
With the first email from the array it works like in the screenshot.

thanks a lot
Dirk

[vunguyenhung]

Hi @dlimmer,

I think you can use custom expression with Node.js code to produce the format that SendInBlue accept. For example,

Assuming your steps.get_request.$return_value is something like

[
  {"cstEmail": "test1@test.com"},
  {"cstEmail": "test2@test.com"},
]

You can try to put this expression into SendInBlue To prop

{{ steps.get_request.$return_value.map(obj => ({email: obj.cstEmail})) }}

The expression will produce the value, which might be accepted by SendInBlue

[
  {"email": "test1@test.com"},
  {"email": "test2@test.com"},
]

You can change the Custom Expression per your need. The Custom Expression accepts any Node.js code

[dlimmer]

Hi,
seems to work. Thanks a lot

Dirk