Answered

Stuck creating an HTML Table after Append to array variable

(0) Share

Report

Posted on by Alejotecelec

Hi,

I'm stuck here! Basically I have to tables "List Constituents" and "Get a constituent last gift" I'm initializing variable because I need data from "Get a constituent last gift" that is not available in "List Constituents", all works and the final result Append to array variable has the information I need. The problem comes when I try to convert that result in a HTML Table ( I wanna send an email that contains the info in the Append to array variable result )

This is what I got in the Append to array variable ( all information I need )

But I get this message from Create HTML Table:

I have tried defining the columns but it doesn't work either the field gray out immediately:

Any help really appreciated !!!

The full flow :

All responses (3)

Answers (1)

Alejotecelec 8 on at

Like (1)

Report

Re: Stuck creating an HTML Table after Append to array variable

Thanks @abm . That was the problem !! Now is solved !
Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Stuck creating an HTML Table after Append to array variable

Try the below

Add a compose above the Append to array. Inside the compose map the values like below

{

"ID":555,

"Name":"Smith"

}

Then append the array using the compose action step. Finally use the append array variable for the HTML action step.
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Stuck creating an HTML Table after Append to array variable

Hi @Alejotecelec

Looking the screenshot why you have two Curley brackets?

Ideally it should be

[

{

"ID":333,

"Name":"David"

},

{

"ID":555,

"Name":"Smith"

},

{

"ID":892,

"Name":"Albert"

}

]